Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Entities: - Customer ( Attributes ) : - CustomerID [ Primary Key ] - Name - Email - Phone - StreetAddress - Referral - Company
Entities:
Customer Attributes:
CustomerID Primary Key
Name
Email
Phone
StreetAddress
Referral
Company Attributes:
CompanyID Primary Key
CompanyName
Email
Phone
Website
AccountType
Consultation Attributes:
ConsultationID Primary Key
Date
Time
CustomerID Foreign Key
DesignerID Foreign Key
Designer Attributes:
DesignerID Primary Key
Name
Quote Attributes:
QuoteID Primary Key
Accepted
TotalAmount
Taxes
DiscountRate
Note
ConsultationID Foreign Key
Unit Attributes:
UnitID Primary Key
UnitName
Price
Quantity
Notes
QuoteID Foreign Key
Installation Attributes:
InstallationID Primary Key
Date
Time
Address
QuoteID Foreign Key
DesignerID Foreign Key
Write SQL statements for the following:
A Creating all tables with appropriate data types and constraints
B Filling all tables with minimum records.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started