Contents

Revision on database
Some of DBMS engines
The SQL language
Relational algebra and translating SQL queries to relational algebra
Selection, Projection, Rename Operation
UNION Operation , Intersection, Cross product, Set Diffrence
Natural Join, ............

-->

What is Database?

January 8, 2020

a Database can be viewed as a “repository for data” or “a collection of related data.” DBMS is a software for managing data management activities.There are different types of database such as OODATABASE , relational database, graph based database....
Relational database:- stores data in the form of row and columns(table). This form of DBMS designed to simplify file management activities of manual system
OODBMS also stores data in the form of row and columns but with an object oriented feature From the DBMS software's that currently available oracle supports this future
Graph based database:- stores data in the form of node instead of row and column. This type of DBMS engines can be used in artificial intelligence development environment

Some of DBMS engines

MYSQL
an open source command line database management system which used to perform relational database management activities. MYSQL is an open source database management system
SQL SERVER:-
is a Microsoft product which is not open source and platform dependent. SQL SERVER runs on a windows operating system only.
ORACLE :-
a java based database management system which is not open source but it’s platform in dependent. ORACLE also supports object oriented capabilities.
Neo4j :
a graph based database management system which stores data in the form of nodes. This database management system is not compatible for relational data management so that it’s used in artificial intelegency