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.
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 with AI-Powered 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