Answer the following. 1. Explain advantages of using DBMS Approach. 2. Explain recursive relationship set with example. 3. Justify the need of aggregation in ER model.
[2 marks]Discuss classification of database management systems.
[7 marks]Briefly discuss the role of DBA.
[7 marks]Design an ER diagram for a database application of your choice. Specify all constraints that should hold on the database. Make sure that the schema has at least five entity types, four relationship types, a weak entity type and a superclass/subclass relationship.
[7 marks]Explain generalization and specialization with suitable example.
[7 marks]Consider a relation R(A, B, C, D, E) with the following dependencies: AB → C, CD → E, DE → B Is AB a candidate key of this relation? If not, is ABD? Explain your answer.
[7 marks]Discuss insertion, deletion, and modification anomalies. Illustrate with examples.
[ marks]Consider the following relation for published books with FDs:07 BOOK (Book_title, Author_name, Book_type, List_price, Author_affil, Publisher) Book_title → Publisher, Book_type Book_type → List_price Author_name → Author_affil Normalize the relation up to 3rd NF.
[ marks]Define constraints. Explain relational model constraints in brief.
[7 marks]Explain conflict serializability in detail.07
[ marks]Discuss BCNF and 4NF in brief.
[7 marks]Discuss why concurrency control is needed in transaction processing.
[7 marks]Draw a transaction state diagram and discuss the typical states that a transaction goes through during execution.
[7 marks]Define transaction. Explain ACID properties of transaction.
[7 marks]Explain transaction control commands.07
[ marks]Consider the following tables and answer the queries in Books (isbn_no, title, publisher_id, year) Authors (author_id, author_name, country, city) Publishers (publisher_id, publisher_name, city) WrittenBy (isbn_no, author_id) 1) List all the books published after 2000. 2) Update the city of author to Delhi whose author id is 15. 3) List all the book titles written by author Mitchell. 4) Add column price in the table Books. 5) Display number of Publishers from the city Ahmedabad. 6) List all the books published by McGaw Hill. 7) Display all publishers in the ascending order of their name.
[ marks]Explain View Serializability with example.07
[ marks]