- Why data independence is important in data modeling? Differentiate between physical and logical data independence.
- Draw an ER-diagram for the following mini-case. What is the difference between strong and weak entity sets?
- Write relational algebra queries for (a, b, c). Write SQL queries for (i, ii, iii)
- Retrieve the detail of employee with eno, add, dob, phone with highest salary.
- Create above table Emp as indicated [2]
- Find employee who earns more than 50000, works in CS department and name contains alphabet a. [2]
- Increase salary of those employee who ears less than average by 25% [2]
- Find total amount spent by ECON department for its employee salary. [2]
- Find total number of posts in CS department. [2]
-
- What is lossless decompostion and dependency preservation? Suppose that we decommpose the schema R = (A, B, C, D, E) into (A, B, C) and (C, D, E). Is it lossless decomposition? Is it dependency preserving? Consider that the following set F of functional dependencies hold:
- A -> BC
- CD -> E
- B -> D
- E -> A
- What is importance of normalization? Define BCNF. [2+3]
- Explain the steps involved in query processing. What is the significance of materialized views? [6+2]
- Write about fixed length record and variable length record organization DBMS. Define B+ free structure used for indexing. [4+4]
- Explain different states of a transaction along with state transition diagram. Explain conflict serializability with example. [4+4]
- Explain briefly two phase locking protocol for Concurrency Control. [4]
- Explain in detail the working of log-based recovery system. [6]
- Explain the importance of data warehouse in decision making. Write the application areas of spatial database. [3+3]
