Database Assignment week 3

Assignment week 3

Review the Entity Relationship diagram and derive a relational schema using the rules and naming conventionsof the course text. To receive full credit for this assignment, your schema must be well organized, easy to read, and include:

• All relations, labeled with appropriate names
• A primary key identified for each relation
• Attributes listed for each relation
• Primary-foreign key constraints