Question

The two entities are:

A= {AID, F1}
B = {BID, F2}
At the physical design level, these two entities are convert into:
a. A= {AID, FI}
B= {BID, F2, AID}
b. A={AID, F1}
B = {BID, F2}
c. A= {AID, F1, BID}
B = (BID, F2}
d. A=(AID, FI, BID}
B= (BID, F2, AID}

Answer 1

At the physical design level, entity B is converted by adding the foreign key attribute AID, resulting in B = {BID, F2, AID}. Entity A remains the same as A = {AID, F1}.

Step-by-step explanation:

At the physical design level, the two entities A and B are combined in a relational database using the concept of foreign keys. The foreign key attribute of B, AID, is added to B's attributes, resulting in B = {BID, F2, AID}. This means that B now has an additional attribute AID, which is used to establish a relationship with entity A. However, there is no need to add any new attributes to A, so A remains the same as A = {AID, F1}. Therefore, the correct conversion is:

A = {AID, F1}

B = {BID, F2, AID}