Question Paper of CS - 06 Data Base Management System June - 2005

Q.1 (a) Suppose you have been designated as a database administrator of an organization. Describe the responsibilities that may be generally assigned to you in order to maintain the centralised database efficiently. Also include at least 2 responsibilities with respect to the Database security.

(b) Create an ER diagram for the loan management system of a finance company. Loans are given on the purchase of various items with different interest rates. The company keeps track of defaulters and takes appropriate steps against them. Make, and state, suitable assumptions (if any).

©. Explain the three-level architecture of DBMS, including the diagram. How is the mapping between these levels achieved?

(d) Explain the evolution of Client/Server Architecture. List the components and the usage in Client/Server computing. Mention any two applications of this model.

Question Paper of CS-06 Data Base Management System Dec-2004

Q.l(a) Explain the various components of a database management system with the help of a diagram.
Below is the diagram of various components of DBMS :

(b) Define 2NF and 3NF. Normalize the following table to 3NF.

© Design an E-R diagram for an Airlines Reservation System consisting of flights, airports, fares, reservations, tickets, crew and passengers. Clearly indicate the entities, relationships and the key constraints.

(d) Explain three levels of architecture of a DBMS with the help of a diagram.

(e) Explain the concept of frame based representation with the help of an example showing the frames and facts/slots.

We are in the process of upadting this section for the question papers of BCA IGNOU