Opening the paper…
Database Management Systems, Quiz 2
The Reserve Bank of India (RBI) maintains a database of financial transactions carried out by various banks across the country. The database contains transaction records of varying magnitudes. The RBI decides to normalize the database to eliminate data redundancy and improve data integrity.
Original database structure:
Transaction
The functional dependencies applicable to Transaction are:
F
Normalized database structure:
Table 1: Bank
Table 2: Transaction
Which of the following normal forms has the RBI achieved by the new normalized database structure?
The Reserve Bank of India (RBI) maintains a database of financial transactions carried out by various banks across the country. The database contains transaction records of varying magnitudes. The RBI decides to normalize the database to eliminate data redundancy and improve data integrity. Original database structure: **Transaction**$(Transaction\_ID, Bank\_Name, Bank\_Location, Amount, Date)$ The functional dependencies applicable to **Transaction** are:\ F $= \{Bank\_Name \rightarrow Bank\_Location,$\ $Transaction\_ID \rightarrow Amount, Date\}$ Normalized database structure: Table 1: **Bank** $(Bank\_Name, Bank\_Location)$ Table 2: **Transaction** $(Transaction\_ID, Bank\_Name, Amount, Date)$ Which of the following normal forms has the RBI achieved by the new normalized database structure? The G20 is a global forum that brings together the world's major economies to discuss and cooperate on international economic and financial issues. The organizers of the G20 event have designed a database to store information about the participants, their countries, and the issues discussed.\ The original database is\ **G20Participants** $(Participant\_ID, Participant\_Name, Participant\_Email, Participant\_Country, Country\_Leader\_Name, Country\_GDP, Issue\_Discussed)$ The functional dependencies are:\ F $= \{Participant\_ID \rightarrow Participant\_Name, Participant\_Email$\ $Participant\_Country \rightarrow Country\_Leader\_Name, Country\_GDP\}$ The initial design of the database is as follows:\ Table 1:\ **Participants** $(Participant\_ID, Participant\_Name, Participant\_Email)$ Table 2:\ **Country** $(Participant\_Country, Country\_Leader\_Name, Country\_GDP, Issue\_Discussed)$ The database designers have identified that this design violates the third normal form (3NF) of database normalization. Which of the following changes would bring the database design into 3NF? Consider the relational schema $\mathbf{R}(J, K, L, M, N)$ and the set of functional dependencies\ $\mathcal{F} = \{$\ $J \rightarrow K,$\ $JK \rightarrow L,$\ $M \rightarrow LJ,$\ $MN \rightarrow JK$\ $\}$\ Which of the following functional dependency sets is equivalent to the given set of functional dependencies?