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]
Apply normalization (3rd normal form)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!