List any four disadvantages of file system approach over database approach. Differentiate between physical and logical data independence. What is the difference between DROP and DELETE command? What are different Integrity Constraints?List all prime and non-prime attributes In Relation R(A,B,C,D,E) with FD set F = {AB→C, B→E, C→D}. Explain MVD with the help of suitable example. Discuss Consistency and Isolation property of a transaction. Draw a state diagram and discuss the typical states that a transaction goes through during execution. List the four functions of DBA. When a relation set is called a recursive relationship set? What do you mean by currency with respect to database?What is Relational Calculus? What is Equi-Join in database? What is a CLAUSE in terms of SQL? When is a transaction Rolled Back? List the various levels of locking?Discuss Conservative 2PL and Strict 2PL.Describe how view serializability is related to conflict serializability.A database is being constructed to keep track of the teams and games of a sport league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of players participating in each game for each team, the positions they play in that game and the result of the game. Design an E-R schema diagram for this application. Map the E-R diagram into relational model.What are Joins? Discuss all types of Joins with the help of suitable examples.14:50