Answered step by step
Verified Expert Solution
Link Copied!

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 3 records.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Forensic Accounting

Authors: Michael A Crain, William S Hopwood

2nd Edition

1948306441, 978-1948306447

Students also viewed these General Management questions