Question: Based on the 4 Steps of Implementation, how many foreign keys will be needed in the Customer table? 1. 0 2. 1 3. 2 4.

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

1.

0

2.

1

3.

2

4.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!