ProductsLogo
LogoStudy Documents
LogoAI Grader
LogoAI Answer
LogoAI Code Checker
LogoPlagiarism Checker
LogoAI Paraphraser
LogoAI Quiz
LogoAI Detector
PricingBlogAbout Us
logo

Student ID: Student Name:.

Verified

Added on  2023/03/30

|6
|373
|318
AI Summary

Contribute Materials

Your contribution can guide someone’s learning journey. Share your documents today.
Document Page
Student ID:
Student Name:

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Report
ER Diagram
(Smartdraw 2016)
Document Page
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
Document Page
5. TableStock
Attribute Data Type Key Compulsory
fieldmemberID INTEGER PRIMARY KEY
FOREIGN KEY
REFERENCES
TableMember
(fieldmemberID)
Yes
fieldplantID INTEGER PRIMARY KEY
FOREIGN KEY
REFERENCES
TablePlant
(fieldplantID)
Yes
fieldpriceDate DATETIME PRIMARY KEY Yes
fieldprice DOUBLE Yes
fieldunitShoppingCost DOUBLE Yes
fieldinStock INTEGER Yes
6. TableOrder
Attribute Data Type Key Compulsory
fieldorderID INTEGER PRIMARY KEY Yes
fieldmemberID INTEGER FOREIGN KEY
REFERENCES
TableMember
(fieldmemberID)
Yes
fieldclientID INTEGER FOREIGN KEY
REFERENCES
TableClient
(fieldclientID)
Yes
fieldorderDate DATETIME Yes
fieldstatus VARCHAR(20) Yes
fieldshippingDate DATETIME Yes
fieldcourierName VARCHAR(30) Yes
fieldnurseryState VARCHAR(3) FOREIGN KEY
REFERENCES
TableShippingMultiplier
(fieldnurseryState)
Yes
fielddestinationState VARCHAR(3) FOREIGN KEY
REFERENCES
TableShippingMultiplier
(fielddestinationState)
Yes

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
fieldshippingReferenceNumber VARCHAR(20) Yes
7. TableOrderItem
Attribute Data Type Key Compulsory
fieldorderID INTEGER PRIMARY KEY
FOREIGN KEY
REFERENCES
TableOrder
(fieldorderID)
Yes
fieldplantID INTEGER PRIMARY KEY
FOREIGN KEY
REFERENCES
TablePlant
(fieldplantID)
Yes
fieldcost DOUBLE Yes
fieldquantity INTEGER Yes
fieldunitShippingcost DOUBLE Yes
8. TableMessage
Attribute Data Type Key Compulsory
fieldmessageID INTEGER PRIMARY KEY Yes
fieldclientID INTEGER FOREIGN KEY
REFERENCES
TableClient
(fieldclientID)
Yes
fieldmemberID INTEGER FOREIGN KEY
REFERENCES
TableMember
(fieldmemberID)
Yes
fieldmessageDate DATETIME Yes
fieldmessage VARCHAR(100) Yes
(Edugrabs.com 2015)
Assumptions
1. In an order, number of items can be ordered.
2. A client can do any number of orders. There is no limit on it.
3. Plants stocks will be managed into the database.
Document Page
4. The shipping cost depends upon the source and destinations.
References
Smartdraw (2016). Entity Relationship Diagram. [Online]. Available:
https://www.smartdraw.com/entity-relationship-diagram/. [Accessed: 4-June-2019]
Edugrabs.com (2015). Types of Attributes in DBMS with Example (ER MODEL – Part 2).
[Online]. Available: http://www.edugrabs.com/type-of-attributes-in-dbms/. [Accessed: 4-June-
2019]
1 out of 6
[object Object]

Your All-in-One AI-Powered Toolkit for Academic Success.

Available 24*7 on WhatsApp / Email

[object Object]