June 3 ICT 701 Relational Database Systems.

ICT 701 Relational Database
Systems
June 3
2019
Student ID:
Student Name:

Part A
ER Diagram
(Tutorialcup 2015)
(Ziff Davis 2017)

Relational Schema and Supplementary Design Requirements
1. Customer
Attribute Data Type Key Compulsory
customerNumber INT PRIMARY KEY Yes
customerName VARCHAR(40) Yes
phone VARCHAR(20) Yes
email VARCHAR(30) Yes
address VARCHAR(50) Yes
balanceOwing DOUBLE Yes
creditLimit INT Yes
2. Item
Attribute Data Type Key Compulsory
itemCode INT PRIMARY KEY Yes
description VARCHAR(50) Yes
category VARCHAR(20) Yes
suggestedRetail DOUBLE Yes
cost DOUBLE Yes
overseas BIT Yes
QOH INT Yes
minStockLevel INT Yes
3. DeliveryMethod
Attribute Data Type Key Compulsory
deliveryMethod VARCHAR(20) PRIMARY KEY Yes
charge DOUBLE Yes