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
Get step-by-step solutions from verified subject matter experts
