Database Management Systems Lecture Notes

1. Database Management Systems Lecture Notes UNIT-I. Data: It is a collection of information. The facts that can be recorded and which have implicit meaning known as 'data'. Example: Customer ----- Database : It is a collection of interrelated data . These can be stored in the form of tables. A Database can be of any size and varying complexity. A Database may be generated and manipulated manually or it may be computerized. Example: Customer Database consists the fields as cname, cno, and ccity Cname Cno Ccity Database system : It is computerized system , whose overall purpose is to maintain the information and to make that the information is available on demand. Advantages: can be reduced. can be avoided. can be shared. 2. can be enforced. restrictions can be applied. can be maintained. gathering can be possible. can be balanced. Database Management system (DBMS): It is a collection of programs that enables user to create and maintain a Database .

Under this, we have to analyze the collection of relations in our relational database schema to identify the potential problems. 4.Physical Database Design: Physical database design is the process of choosing specific storage structures and access paths for the database files to achieve good performance for the various database applications.

Loading..

Tags:

  Lecture, Notes, Database, System, Management, Relational, Relational database, Database management systems lecture notes

Information

Related search queries