DBMS is: a collection of programs that enables users to create and maintain a database
n It is a general-purpose software system enables us in Defining, Constructing and Manipulating DB:
Ø Defining: specifying the data types, structures and constraints
Ø Constructing: storing the data in the DB
Ø Manipulating: as querying, updating and generating reports
Database + DBMS ................. Database System
n It is a general-purpose software system enables us in Defining, Constructing and Manipulating DB:
Ø Defining: specifying the data types, structures and constraints
Ø Constructing: storing the data in the DB
Ø Manipulating: as querying, updating and generating reports
Database + DBMS ................. Database System
Example
Example
n University database: to maintain students, courses and grades.
n We may have five files:
Ø STUDENT
Ø COURSE
Ø SECTION
Ø PREREQUISITE
Ø GRADE_REPORT
No comments:
Post a Comment