Foreign keys

1. Draw an Entity Relationship diagram for the system [8 Marks]
2. Create a schema for each table. Ensure that all fields/attributes are listed and the primary key
is clearly underlined. Identify foreign keys where applicable. Below is a template of the
schema.
Please follow the example below:
TableName(PrimaryKey¸ attribute1, attribute2, …, attributeM, refAttribute1, …
refAttributeN)
where refAttribute1, …, refAttributeN are foreign keys [7 Marks]
3. Draw paper design for the summary report. The design should clearly identify the report
header/footer, page header/footer, identifying fields, totals, etc. You should follow good
output design principles. [20 Marks].