19. Relational Database Systems. ITC701. Student ID:. S

Student ID:
Student Name:

Part A
ER Diagram
(Holowczak.com n.d.)

Relational Schema and Supplementary Design Requirements
1. TblCustomer
Attribute Data Type Key Compulsory
fldcustomerNumber INTEGER PRIMARY KEY Y
fldcustomerName VARCHAR(40) Y
fldphone VARCHAR(20) Y
fldemail VARCHAR(30) Y
fldaddress VARCHAR(50) Y
fldbalanceOwing DOUBLE Y
fldcreditLimit INTEGER Y
2. TblItem
Attribute Data Type Key Compulsory
flditemCode INTEGER PRIMARY KEY Y
flddescription VARCHAR(50) Y
fldcategory VARCHAR(20) Y
fldsuggestedRetail DOUBLE Y
fldcost DOUBLE Y
fldoverseas BIT Y
fldQOH INTEGER Y
fldminStockLevel INTEGER Y
3. TblDeliveryMethod
Attribute Data Type Key Compulsory
flddeliveryMethod VARCHAR(20) PRIMARY KEY Y
fldcharge DOUBLE Y
4. TblSalesRep
fldAttribute Data Type Key Compulsory
fldsalesRepID INTEGER PRIMARY KEY Y
fldsalesRepName VARCHAR(40) Y
fldaddress VARCHAR(50) Y
fldmobile VARCHAR(20) Y
fldemail VARCHAR(30) Y
fldhiredDate DATETIME Y
fldagreedSalary DOUBLE Y
fldcommissionRate INTEGER Y