Database Management Systems Quiz 2: 6 August 2023 (May 2023 term)

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?