Based on the 4 Steps of Implementation, how many foreign keys will be needed in the Sale Table? 1. 2 2. 1 3. 0 4. 4

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