Download JNTUA MCA 2018 July Reg-Supply 3rd Sem 9F00301 Database Management Systems Question Paper

FirstRanker.com
Firstranker's choice
FirstRanker.com Code: 9F00301

--- Content provided by⁠ FirstRanker.com ---

Answer any FIVE questions

--- Content provided by FirstRanker.com ---

1. Explain database users, DBA and functions of a DBA.
2. Compare file systems and database systems.
3. What is null attribute? With suitable diagram, explain weak and strong entity set.
4. Develop ER-diagram for a hospital with a set of patients and a set of medical doctors, associated with each patient a log of the various tests and examinations conducted.

--- Content provided by‍ FirstRanker.com ---

5. Consider the following schema for company database:
   Employee (Name, ESSN, Salary, DNo, SuperSSN);
   Department(DName, DNos, MGRSSN);
   Project(PName, PNo, DNum);
   Works_ON(ESSN, PNo, Hours);
   

   --- Content provided by‌ FirstRanker.com ---

   Department(ESSN, DName, Sex);
   Write the queries in relational algebra and SQL
   (i) List the name of employees with at least two dependants.
   (ii) Find the name of employees who work on all projects controlled by department 5.
   (iii) Retrieve the names of managers who do not have female dependents.

--- Content provided by⁠ FirstRanker.com ---

6. What is the usage of ‘group by’ and ‘having’ clauses in SQL?
7. Demonstrate the following operators in SQL with examples:
   (i) SOME. (ii) EXCEPT.
8. Why normalization is needed? Explain the process of normalization.
9. Explain briefly about 3NF, 4NF and BCNF with suitable examples.

--- Content provided by‍ FirstRanker.com ---

10. Discuss two phase locking protocol and strict two-phase locking protocol.
11. Discuss about conflict serializability with an example.
12. Construct an ER diagram for university registrar’s office. The office maintains data about each class, including the instructor, the enrollment and the time and place of the class meetings. For each student class pair a grade is recorded. Determine the entities and relationships.
13. Draw transaction state diagram and describe each state that a transaction goes through during its execution.
14. Write short notes on:
    

    --- Content provided by‌ FirstRanker.com ---

    a) Characteristics of a database system.
    b) Entity integrity and referential integrity constraints.
    c) Different data types of SQL.

FirstRanker.com

--- Content provided by FirstRanker.com ---