IT 234 IT234 Unit 1 Assignment (Kaplan)
IT 234 Unit 1 Assignment (Kaplan)
1: Correctly identifies the entity name and the entity type
2: Correctly identifies the primary keys for each entity.
Consider every entity you have identified above.
3: Correctly identifies any corresponding foreign keys
Consider every entity you have identified. Use ‘none’ if no foreign keys are required.
There may be more than one foreign key for an entity.
4: Correctly identifies entities, the relationship(s) between them, and their degree.
Remember that relationships may differ by direction, so you may need another entry.
For example: order only has one customer, but a customer may have many orders.
1 to 1, 1 to many, many to many, none to many, etc.
You may use abbreviations such as 1:1, 1:M, M:M 5:
Correctly identifies the intersection table(s) and the attributes