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 June -2003

Question Paper of CS-06 Data Base Management system June -2003 Q.l(a). XYZ Bank offers 5 types of accounts, namely Savings, Recurring, Loan, Current and Money market It operates a number of branches and a client of the Bank can have any number of accounts, can be individual and joint Identify the entities of your interest and show their attributes. What relationships exist among these entities? Draw the corresponding E-R diagram. Also design a relation data base to the relational database to the above E-R diagram. (b) Discuss the differences between the following file organisations: (i) Sequential (ii) Indexed sequential (iii) Relative file organisation (iv) Multikey

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-2004

Question Paper of CS-06 Data Base Management System June-2004 Q.1. (a). What are the advantages of DBMS over a traditional file system? (b) What is ISAM? How are records stored in ISAM? Show this with diagrams. (c) Define BCNF. How does it differ from 3NF? Explain them through an example. (d) What is a knowledge-base system? Differentiate between a knowledge base system and a database system.