Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
