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/29

|6
|354
|210
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
ER Diagram
(Holowczak.com n.d.)
(Perucci D. n.d.)
Document Page
Relational Schema and Supplementary Design Requirements
1. TClient
Attribute Data Type Key Compulsory
FclientID INTEGER PRIMARY KEY Yes
FclientName NVARCHAR(50) Yes
Femail NVARCHAR(50) Yes
Flocation NVARCHAR(100) Yes
FstartDate DATETIME Yes
FdeliveryAddress NVARCHAR(100) Yes
FaccountNumber NVARCHAR(12) Yes
2. TMember
Attribute Data Type Key Compulsory
FmemberID INTEGER PRIMARY KEY Yes
FmemberName NVARCHAR(50) Yes
FcontactName NVARCHAR(50) Yes
FstartDate DATETIME Yes
FendDate DATETIME No
FnurseryName NVARCHAR(50) Yes
FnurseryAddress NVARCHAR(100) Yes
FnurseryPhone NVARCHAR(20) Yes
FnurseryEmail NVARCHAR(50) Yes
FmemberDescription NVARCHAR(100) Yes
3. TPlant
Attribute Data Type Key Compulsory
FplantID INTEGER PRIMARY KEY Yes
FbotanicalName NVARCHAR(50) Yes
FcommonName NVARCHAR(50) Yes
Fdescription NVARCHAR(100) Yes
4. TShippingMultiplier
Attribute Data Type Key Compulsory
FnurseryState NVARCHAR(3) PRIMARY KEY Yes
FdestinationState NVARCHAR(3) PRIMARY KEY Yes
FshippingCostMultiplier Double Yes
5. TStock
Document Page
Attribute Data Type Key Compulsory
FmemberID INTEGER PRIMARY KEY
FOREIGN KEY
REFERENCES
TMember
(FmemberID)
Yes
FplantID INTEGER PRIMARY KEY
FOREIGN KEY
REFERENCES
TPlant (FplantID)
Yes
FpriceDate DATETIME PRIMARY KEY Yes
Fprice DOUBLE Yes
FunitShoppingCost DOUBLE Yes
FinStock INTEGER Yes
6. TOrder
Attribute Data Type Key Compulsory
ForderID INTEGER PRIMARY KEY Yes
FmemberID INTEGER FOREIGN KEY
REFERENCES
TMember
(FmemberID)
Yes
FclientID INTEGER FOREIGN KEY
REFERENCES
TClient (FclientID)
Yes
ForderDate DATETIME Yes
Fstatus NVARCHAR(20) Yes
FshippingDate DATETIME Yes
FcourierName NVARCHAR(50) Yes
FnurseryState NVARCHAR(3) FOREIGN KEY
REFERENCES
TShippingMultiplier
(FnurseryState)
Yes
FdestinationState NVARCHAR(3) FOREIGN KEY
REFERENCES
TShippingMultiplier
(FdestinationState)
Yes
FshippingReferenceNumber NVARCHAR(20) Yes

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
7. TOrderItem
Attribute Data Type Key Compulsory
ForderID INTEGER PRIMARY KEY
FOREIGN KEY
REFERENCES
TOrder (ForderID)
Yes
FplantID INTEGER PRIMARY KEY
FOREIGN KEY
REFERENCES
TPlant (FplantID)
Yes
Fcost DOUBLE Yes
Fquantity INTEGER Yes
FunitShippingcost DOUBLE Yes
8. TMessage
Attribute Data Type Key Compulsory
FmessageID INTEGER PRIMARY KEY Yes
FclientID INTEGER FOREIGN KEY
REFERENCES
TClient (FclientID)
Yes
FmemberID INTEGER FOREIGN KEY
REFERENCES
TMember
(FmemberID)
Yes
FmessageDate DATETIME Yes
Fmessage NVARCHAR(100) Yes
Assumptions
1. Cost of shipping is based upon the destination and source both.
2. An order may contain any number of items.
3. Any number of orders may belong to a single client.
Reference
Document Page
Holowczak.com (n.d.). Database Normalization. [Online]. Available:
http://holowczak.com/database-normalization/. [Accessed: 4-June-2019]
Perucci D. (n.d.). Pros and Cons of Database Normalization. Online. Available:
https://dzone.com/articles/pros-and-cons-of-database-normalization. [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]