Page 17 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database

Notes 8. A ................................... is conceptually a table, but the records of this table are not stored in
the database.
9. In DBMS the access programs are written independent of any specific ...................................

10. In file processing the data definition is part of the ................................... program.

1.10 Review Questions

1. Define database. Explain the concepts in database environment.
2. List and explain various Database System Applications.
3. What are the differences between File processing systems and DBMS?

4. Write the advantages of DBMS.
5. Write short notes on Disadvantages of Database Management System.
6. What is Data independence? Explain the types of Data Independence.

7. What are the database languages? Explain the various languages.
8. What are the responsibilities of a DBA? List and explain them.
9. What is the role of Data user? Explain the types of users.
10. Explain the architecture of DBMS.
11. Explain the components of DBMS.

12. Write history of Database Systems.

Answers: Self Assessment

1. (b) 2. (c)
3. (d) 4. Indices
5. plural 6. information

7. Metadata 8. view
9. files 10. application

1.11 Further Readings

Books C.J. Date, Introduction to Database Systems, Pearson Education.
Elmasri Navrate, Fundamentals of Database Systems, Pearson Education.
Martin Gruber, Understanding SQL, BPB Publication, New Delhi

Peter Rob & Carlos Coronel, Database Systems Design, Implementation and
Management, 7th Edition.
Raghurama Krishnan, Johannes Gehrke, Database Management Systems, 3rd Edition,
Tata McGraw Hill.
Silberschatz, Korth, Database System Concepts, 5th Edition, McGraw Hill.

10 LOVELY PROFESSIONAL UNIVERSITY