DBMS - Part 2
DBMS - Part 2
DBMS - Part 2
Navathe
Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 1- 2
What is data, database, DBMS
Data: Known facts that can be recorded and have an implicit meaning; raw
Database: a highly organized, interrelated, and structured set of data about a
particular enterprise
Controlled by a database management system (DBMS)
DBMS
Set of programs to access the data
An environment that is both convenient and efficient to use
Database systems are used to manage collections of data that are:
Highly valuable
Relatively large
Accessed by multiple users and applications, often at the same time.
A modern database system is a complex software system whose task is to
manage a large, complex collection of data.
List the names of students who took the section of the ‘Database’ courseoffered in fall
Create a new section for the ‘Database’ course for this semester
Enter a grade of ‘A’ for ‘Smith’ in the ‘Database’ section of last semester
The design is then translated to a logical design that can be expressed in a data
model implemented in a commercial DBMS
The final stage is physical design, during which further specifications are provided
for storing and accessing the database. The database design is implemented,
populated with actual data, and continuously maintained to reflect the state of the
miniworld.