SQL_Assignment - 96991

Solution Posted by
ankitpunia

ankitpunia

Rating : No Rating
Solution Detail
Price: $40.00
Request Description
0
Solution Description

 

 

 

 

 

SQL Database assignment

Your Name

University of UniversityName

 

Course Number

Course Name

Date

 

 

 

 

 

 

 

 

 

 

 

 

 

Part A

  1. First Normal Form

Customer

Cust_id(PK)

FName

LName

Street

Apartment

City

State

Country

Zip

HomePhone

OfficePhone

 

This table is labeled as “Customer” and is created to include all the relevant information for a customer in the database. The table employs “Cust_id” as the Primary Key for each customer value. The “Cust_id” PK column auto- increments for each customer value. Following, the “Phone Number” columns (HomePhone, OfficePhone) will be eliminated from this Customer table. These columns are a repeating group that and be normalized by creating another table called “CustPhone” and featuring a joining table between “Customer” and “CustPhone”

  1. Second Normal Form

Donut

Donut_id(PK)

DonutName

Description

Price

 

 

 

SalesOrder_Donut

SalesOrder_id(FK)

Donut_id(FK)