There will one page for each data structure
1.Using the ERD (reduced from Part 1) provided below, create logical data structures for all the entities and associative entities.
2.For each data structure, include a Data Structure Form that lists all of the assumptions and business rules relating to the data structures. (Copy of this form and sample completed form are provided below (next page).)
PK |
|
has | PK | has | ||
---|---|---|---|---|---|---|
PK,FK1 |
|
|||||
PK,FK2 | ||||||
Enrollment_Date | ||||||
|
||||||
|
||||||
|
||||||
|
||||||
1
Sample page and instructions to illustrate Data Structure Form
•Each Employee has a unique ID.
•Employee can be instructor for many courses, but a course is taught by only one Employee.
(Example )