CS计算机代考程序代写 Introduction

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: