B.TECH - Semester 4 database design Question Paper 2019 (jun)
Practice authentic previous year university questions for better exam preparation.
Sample Questions
- What are the responsibilities of the DBA and the database designer?
- Differentiate two-tier and three-tier server architecture.
- List out the various cases where use of null value would be appropriate.
- What is a foreign key? Give an example.
- Explain how a One to many relationship in an ER diagram is converted into relation.
- Write any two data manipulation language commands with example.
- Define Multivalued dependency and fourth normal form.
- How does disk monitoring helps in improving reliability?
- What is partitioned hashing? List out its limitations.
- How does two-phase locking protocol ensure serializability? ( $10 \times 4=40$ Marks) P.T.O. PART - B Answer any one question from each Module.
- (a) Explain the components of a database management system.
- (b) A hospital offers rooms for a maximum capacity of 3 patients per room. The rooms are numbered consecutively. Doctors and Patients are registered by their first name, sur name and ID. Doctors have a certain function/special subject in the hospital...
- (a) Use the following database schema. Parts(part_id, name, Color, piece_weight;price) Orders(Order_id,customer, shipping_addr, orderdate,shipping_date) Parts_order(order_id,parts_id,quantity, parts_price) And write the relational algebra notation...
- (i) What is the total price of each order? (ii) List the name of all parts whose last letter is d' and are red in color. (iii) How many days does it take to ship the orders? (iv) Give the details of all the parts whose price is less than $\operatorna...
- (b) Explain the various data models to organize data in DBMS.
- (a) Explain in detail about functional dependencies and Amstrong's axiom.
- (b) Create the following tables with foreign key constraints wherever necessary. DEPOSIT(actno,cname,bname,amount,adate) BRANCH(bname,city) CUSTOMERS(cname,City) BORROW(loanno,cname,bname,amount) Write the SQL query for the following
- (i) List all customers who are depositors but not borrowers (ii) List all the customers along with their amount who are either borrowers or depositors and living in city nagpur. (iii) List the details of all depositors living in city nagpur. (iv) Giv...
- (a) Write the algorithm for finding a minimal cover F for a set of functional dependencies $E$. A set of $F D s$ for the relation $R(A, B, C, D, E, F)$ is $A B->C, C->A, B C->D, A C D->B, B E->C, E C->F A, C F->B D, D->E$. Find a minimum cover for th...
- (b) With an example for each explain third Bobabab formance Codd normal form.
- (a) Describe the technique for allowing a hash file to expand and shrink dynamically. What are its advantages and disadvantages?
- (b) Write an algorithm for testing the conflict serializability of a schedule. OR
- (a) Explain the different types of transaction failures. Also brief about catastrophic failure.
- (b) Describe the concurrency control mechanisms based on timestamp ordering. ( $\mathbf{3} \boldsymbol{\times} \mathbf{2 0} \boldsymbol{=} \mathbf{6 0}$ Marks)