MCA MAGADH UNIVERSITY QUESTION (2017-2020) (Third semester) Database Management System

MCA MAGADH UNIVERSITY QUESTION (2017-2020) (Third semester) Database Management System

                                                                         Time: 4 hours
                                                                         Full Marks: 80
                                                                Answer any five questions.

1. What is Database Management System? What are the characteristics of database management system?

2. What are the main components of a database management system?

3. Explain the following:
    (a)  Database language
    (b) Sequential Field
    (c) Data Mining & Data Warehousing
    (d) SQL

4. Explain the three level architecture of database management system.

5. What do you understand by Entity Relationship Diagram? Draw an E-R diagram for a student management system. Assume suitable entity and relations.

6. Give a complete description about concurrency control and recovery systems.

7. Describe Transaction. Explain the properties and life cycle of transaction.

8. What are the various types of database management system(DBMS) Models?

9. Explain in detail about functional dependencies.

10. Write short note of any two of the following:
      (a) Primary Key & Foreign Key
      (b) Normal form (1NF & 2NF)
      (c) ORACLE
      (d) Normalization