Question: Normalization Steps 1-6 for Database design. Attributes: Long name Short name Description Company Expenses Cexpenses Expenses for Company(outside hires/payroll) Address Saddress Address of where it

Normalization Steps 1-6 for Database design.

Attributes:

Long name

Short name

Description

Company Expenses

Cexpenses

Expenses for Company(outside hires/payroll)

Address

Saddress

Address of where it was sold at.

Salesman

Ssalesman

Who sold it?

Installation Cost

Cinstallation

How much was the installation?

Installation Location

Linstallation

Where was the installation?

Product ID

Pid

What was installed?

Email

Cemail

Customers email.

First Name

Cfirst

Customers First name.

Address

Caddress

Customers address.

Last Name

Clast

Customers last name.

Product Estimate

Pestimate

Estimate of what they got.

Total Cost

Tcost

Estimate of the cost

Estimated materials needed

Ematerials

Estimate of the materials needed.

Step 1 Identify All Attributes:

Step 2: Determine Dependencies

Step 3: 1NF

Step 4: 2NF

Step 5: 3NF

Step 6: Name Tables Entity or Relationship

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 Databases Questions!