Database Design ITC211

Database Design ITC211
Task 2
6/5/2019
Student ID:
Student Name:

ER Diagram
(B. Peter n.d.)
(Cinergix Pty Ltd. 2011)

Relational Schema and Supplementary Design Requirements
1. TbClient
Attribute Data Type Key Compulsory
fdclientID INTEGER PRIMARY KEY Y
fdclientName VARCHAR(50) Y
fdemail VARCHAR(50) Y
fdlocation VARCHAR(100) Y
fdstartDate DATETIME Y
fddeliveryAddress VARCHAR(100) Y
fdaccountNumber VARCHAR(12) Y
2. TbMember
Attribute Data Type Key Compulsory
fdmemberID INTEGER PRIMARY KEY Y
fdmemberName VARCHAR(50) Y
fdcontactName VARCHAR(50) Y
fdstartDate DATETIME Y
fdendDate DATETIME No
fdnurseryName VARCHAR(50) Y
fdnurseryAddress VARCHAR(100) Y
fdnurseryPhone VARCHAR(20) Y
fdnurseryEmail VARCHAR(50) Y
fdmemberDescription VARCHAR(100) Y
3. TbPlant
Attribute Data Type Key Compulsory
fdplantID INTEGER PRIMARY KEY Y
fdbotanicalName VARCHAR(50) Y
fdcommonName VARCHAR(50) Y
fddescription VARCHAR(100) Y
4. TbShippingMultiplier
Attribute Data Type Key Compulsory
fdnurseryState VARCHAR(3) PRIMARY KEY Y
fddestinationState VARCHAR(3) PRIMARY KEY Y
fdshippingCostMultiplier Double Y
5. TbStock