BCA IGNOU

Related Other Question Papers

CS-06 Data Base Management System Dec- 2002

Question Paper of CS-06 Data Base Management System Dec- 2002 Q.1. (a). Design a Relational database to the E - R diagram given below: (b) Describe the following relational operators with examples: (i) UNION (ii) DIFFERENCE (iii) INTERSECTION (iv) CARTESIAN PRODUCT (v) PROJECTION (c) Write short notes on the following: (i) Distributed databases (ii) Object Oriented databases (iii) Data Redundancy (iv) Query Processor (d) Explain the difference between the physical and logical data independence. Q.2(a). Discuss why navigation is simpler in the Relational data model than in the Hierarchical data model. (b) ABC Ltd. is a software company involved in the design, development and marketing of SAV

CS-06 Data Base Management System Dec-2003

Question Paper of CS-06 Data Base Management System Dec-2003 Q.l(a). Construct an ER diagram (including important attributes) for a car insurance database that includes data about customer (car owners), cars accidents, drivers involved in accidents and injured drivers and/or passengers. Note that any customer can insure many cars, each car may have different drivers at different times and accidents typically involve one or more cars. (b) Explain the 3 levels of the database architecture. Also discuss the advantages of having the 3 levels. (c) What are functional dependencies? With a suitable example explain the importance of functional dependencies in database design

CS-06 Data Base Management system Dec-2001

Question Paper of CS-06 Data Base Management system Dec-2001 Q.1(a). Design a Relational database to the E- R diagram given below: Image No. 1 Tabular representation of the Relational Database for the above E-R Diagram Entities and its Attributes : (b) Explain the following general integrity rules of Relational Mode: (i) Entity Integrity (ii) Referential Integrity (c) For the relations P and Q, perform the following operation: (i)Find the projection of Q on the attributes (B,C) (ii) Find the natural join of P and Q on the common attributes. (d)Write short notes on: (i) Object oriented databases (ii) Specialization (iii) Generalization (iv) Data independence (v) Query processor Q.3(a).

CS-06 Data Base Management System Dec-2004

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. (c) 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

CS-06 Data Base Management System June-2002

Question Paper of CS-06 Data Base Management System June-2002 Q.l(a). Draw E-R diagram for a departmental store, after determining the entities of interest and the relationship that exist between these entities. Also construct a tabular representation of the entities and relationships. Are there any attributes (or collections of attributes) in each entity set that would uniquely identify an instance of the entity set? (b) What problems are caused by data redundancies? Can data redundancies be completely eliminated when the database approach is used? Explain. (c) Explain