Chapter 6, Problem 6DQ

Program Plan Intro

Database management system

• A database management system is a software package designed for defining, manipulating, retrieving and managing data in a database.
• It acts as an interface between the application programs and physical data files.
• The end user does not have to worry about where and how data is stored with the help of a database management system.

Database design

• Database design involves understanding the relationship among the data, type of data maintained in the database, how data will be used and so on.
• The conceptual and physical designs are two aspects for overall design of the database.
• The conceptual design is the abstract model of database from the business perspective.
• The physical design is the actual arrangement of database on direct access storage devices.