What is Database?
A collection of individual data items Stored in a highly structured way Represents a model of reality Data can be stored in a single location or harddrive. Or distributed across large networks. Database act as single entity to every system or user of it.
CRUD is performed by database engine
Dabase management system consists of Front End/Database Application software Database Engine Database
MS ACCESS has all the application, database engine and database MS SQL SERVER provide only database engine and database.
DBMS provide mangement, optimization, permissions, security, backups and other features.
Relational database are most used database type. They are developed arround 1970s.
Relational is one of type of database.
In relational database we store information in multiple data tables, these tables refer to each other in order to store lots of information about single entity.