Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Formal SQL Tuning For Oracle Databases Practical Efficiency Efficient Practice

Authors: Leonid Nossov ,Hanno Ernst ,Victor Chupis

1st Edition

3662570564, 978-3662570562

More Books

Students also viewed these Databases questions