Based on the 4 Steps of Implementation, how many foreign keys will be needed in

Question

Based on the 4 Steps of Implementation, how many foreign keys will be needed in the Customer table?

0

1

2

3

1. Create a table for each distinct entity in model. 2. Create a table for each many-to-many (*:*)relationship. 3. Link entities with One to One (1:1) relationships via foreign keys^^. 4. Link entities with One to Many (1:*) or Many to One (*:1) relationships via foreign keys^^. Exception – when the primary key of the event that occurs second would normally post into the table of the event that occurs first. In this event, create separate table. ^^You can always link entities by creating a separate table. But, in this class, we will always try to use a foreign key to create the link unless it is a (*:*) in #2 above or the exception listed in #4. above. 1

0

1

2

3

Explanation / Answer

Answer)

Based on the understanding of the above, I think that Customer table will contain the primary key - as the CustomerID and other Customer relevant details.

Thus, there will be 1 foreign key for the Customer table, as Customer table will have a One to Many (1:*) or Many to One (*:1) relationships via foreign keys in the sense that one Customer can buy many products, thus here is a 1:many relationship.

Thus, the number of foreign keys needed in the Customer table are:

2. 1 foreign key.

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.