Database Defination

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 Tasks

CRUD is performed by database engine

DBMS

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.

RDBMS

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.

Next