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? |
| 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started