BCA IGNOU

Related Other Question Papers

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

CS- 68 Computer Network Dec -2004

Question Paper of CS- 68 Computer Network Dec- 2004 Q. l(a) What do you understand by simplex, half-duplex, full-duplex modes? Explain with relevant examples. Q. l(b) Differentiate between base band and broadband communication . In which types of applications are these used/ Explain. Q. l(c) (i) How do Remote Produce Calls (RPC work? (ii) Distinguish between upward and downward multiplexing, and explain the need of multiplexing at transport layer. Q. l(d) Describe the two methodologies used by bridges for transmission of frames. Explain the operation of bridge through proper diagram. Q. l(e) Explain the operation of Go-Back-N. How is Selective Repeat better than

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