Introduction to Database Design

Database
A collection of related pieces of data –
.. Representing/capturing the information about a real-world enterprise or part of an enterprise.
.. Collected and maintained to serve specific data management needs of the enterprise.
.. Activities of the enterprise are supported by the database and continually update the database.
Example
University Database-
Data about students, faculty, courses, research- laboratories, course registration / enrollment etc.
Reflects the state of affairs of the academic aspects of the university.
Purpose: To keep an accurate track of the academic activities of the university.
Database Management System (DBMS)
Software system enabling-
.. Creation of large disk-resident databases.
.. Posing data retrieval queries in a standard manner.
.. Retrieval of query results efficiently.
.. Concurrent use of the system by a large number of users in a consistent manner.
.. Guaranteed availability of data irrespective of system failures.

By Prof. P.Sreenivasa Kumar, IIT Chennai

view / download: DB-Introduction (size 72 KB)

Comments are closed.