B.TECH - Semester 5 database design Question Paper 2019 (apr)
Practice authentic previous year university questions for better exam preparation.
Sample Questions
- (x) Each course can have any number of students.
- (b) Explain the three schema architecture of DBMS.
- Differentiate between a strong entity and a weak entity with an example.
- What is data independence? What are its types?
- Explain the advantage of a B+tree over a B tree.
- Differentiate between participation and cardinality constraint.
- What is the need of normalization of relational tables?
- Explain amstrong's axioms of functional dependency. Why they are called sound and complete?
- Explain referential integrity in SQL.
- What is a view definition? Create a view called all-customer with branch name and customer name who can borrow and deposit amounts using their accounts.
- Why cascading rollback is potentially costly?
- Define a serializable schedule with an example. ( $10 \times 4=40$ Marks ) P.T.O. Answer one full questions from each Module.
- (a) Draw an ER diagram for the following specification given for the College database :
- (i) A college contains many departments. (ii) Each department can offer any number of courses. (iii) Many instructors can work in a department. (iv) An instructor can work only in one department.
- (v) For each department there is a Head. (vi) An instructor can be head of only one department. (vii) Each instructor can take any number of courses. (viii) A course can be taken by only one instructor. (ix) A student can enroll for any number of cou...
- (a) Explain the procedure for insertion into a $B$ tree. Create a $B$ tree of order $p=3$ by inserting values in the sequence $64,22,3,45,1,88,34,99,24$, 5, 2, 77.
- (b) Briefly explain the advantages of a DBMS system over a file system.
- (a) Create a table Weather with the following structure using SQL | Name of Column | Type | | :--- | :--- | | City | Character(15) | | Temperature | Number(2) | | Humidity | Number(2) | | Condition | Character(20) | | Country | Character(20) | Crea...
- (i) List the cities which have city name start with "I". (ii) Display all cities which have the temperature between 35 and 40 and city name consists of letter ' $R$ '. (iii) List the cities where temperature is less than 25 and weather condition is r...
- (v) List the countries and weather condition where the humidity is between 20 and 45.
- (b) Explain 2NF, 3NF and BCNF with suitable examples 10
- (a) Explain any five fundamental operations in relational algebra that are applicable in relational database with suitable examples. 10
- (b) Briefly explain the join dependency and fifth normal form. 10
- (a) Explain the different lock based protocols for concurrency control. ..... 15
- (b) What are the ACID properties of a transaction? ..... 5 OR
- (a) Explain any one database recovery algorithm with an example. ..... 10
- (b) Briefly explain the optimistic concurrency control algorithm. ..... 10