logo

Student ID: Student Name:.

   

Added on  2023-03-30

6 Pages373 Words318 Views
Student ID:
Student Name:
Student ID: Student Name:._1
Report
ER Diagram
(Smartdraw 2016)
Student ID: Student Name:._2
Relational Schema and Supplementary Design Requirements
1. TableClient
Attribute Data Type Key Compulsory
fieldclientID INTEGER PRIMARY KEY Yes
fieldclientName VARCHAR(40) Yes
fieldemail VARCHAR(30) Yes
fieldlocation VARCHAR(50) Yes
fieldstartDate DATETIME Yes
fielddeliveryAddress VARCHAR(50) Yes
fieldaccountNumber VARCHAR(12) Yes
2. TableMember
Attribute Data Type Key Compulsory
fieldmemberID INTEGER PRIMARY KEY Yes
fieldmemberName VARCHAR(40) Yes
fieldcontactName VARCHAR(40) Yes
fieldstartDate DATETIME Yes
fieldendDate DATETIME No
fieldnurseryName VARCHAR(50) Yes
fieldnurseryAddress VARCHAR(50) Yes
fieldnurseryPhone VARCHAR(20) Yes
fieldnurseryEmail VARCHAR(30) Yes
fieldmemberDescription VARCHAR(100) Yes
3. TablePlant
Attribute Data Type Key Compulsory
fieldplantID INTEGER PRIMARY KEY Yes
fieldbotanicalName VARCHAR(30) Yes
fieldcommonName VARCHAR(30) Yes
fielddescription VARCHAR(50) Yes
4. TableShippingMultiplier
Attribute Data Type Key Compulsory
fieldnurseryState VARCHAR(3) PRIMARY KEY Yes
fielddestinationState VARCHAR(3) PRIMARY KEY Yes
fieldshippingCostMultiplie
r
Double Yes
Student ID: Student Name:._3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
19. Relational Database Systems. ITC701. Student ID:. S
|6
|439
|42

Database Design ICT211 Part 2
|27
|1579
|113

Student ID: Student Name:.
|6
|354
|210

Database Design ITC211.
|7
|472
|84

June 3 ICT 701 Relational Database Systems.
|6
|459
|41

Database Design ITC211
|6
|522
|36