Q1. A database is being made to keep track of the teams and games of a sport league. A team consists of a number of players, not all of whom participate in each game. This is desired to keep track of players participating in each game for each team, the positions they play in that game and the consequence of the game.
a) Design an E-R schema diagram for the above application.
b) Map the E-R diagram to relational model.
Select your favorite sport (ex: Soccer, Baseball or Football)
Q2. In what sense does the relational calculus distinct from the relational Algebra and in what sense they are alike?
Q3. Describe the meanings of the existential quantifiers (∃) and universal quantifier (∀).
Q4. Illustrate the difference between UPDATE and ALTER command in the SQL with proper ex.
Q5. Describe the term Multi-version Time-stamp ordering protocol.
Q6. Describe the concept of conflict serializability. State conflicting instructions and non-conflicting instructions.
Q7. Given below are the two sets of FDs for a relation R(A, B, C, D, E). Are they equal?
a) A → B, AB → C, D → AC, D → E
b) A → BC, D → AE