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
Get step-by-step solutions from verified subject matter experts
