Introduction
This is an individual assignment. You must submit it as an individual. Week1-2&3-4 homework together will be weighted 10% of your final subject grade.
Please write your student number and full name here:
Student Name:
Student Number:
Date:
Section 1 – Please define each of the following key terms and then give examples (6 marks):
1. Supertype and Subtype (4 marks):
Definition:
Please give an example of a Supertype and the corresponding Subtypes:
2. Disjointness Constraints (2 marks):
Definition:
Please give an example of an overlapping condition (you can use the same scenario that you have given in Question 1 if you like):
Section 2 – Please answer the following questions (4 marks):
1. Please Contrast the following terms of Generalization and Specialization
2. What are the requirements for a table to qualify as a relation?
Section 3 – Please convert the following ERD into tables (10 marks):
Please convert the following ERD into tables, indicating primary and foreign keys. Use an underline to indicate primary key attributes and asterisk (*) to indicate foreign keys, just like in the tutorial. An example is shown below:
1. Please convert the following ERD into corresponding tables. Please note that this ERD is drawn using ERAssistant APP.
Result after conversion:
2. Please convert the following ERD into corresponding tables. Please note that this ERD is drawn using ERAssistant APP.
Result after conversion: