Homework 10 -- Normalization
The table
We'll start out with a table similar to the one used in Quiz 2. The table is used to track purchase orders.
Each purchase order is made to a specific company and contains several lines
corresponding to the items being ordered. The specific columns of this table
are
- PO-NUM
- A unique id for purchase orders
- LINE-NUM
- The line number within a purchase order
- REQUESTOR
- The name of the person requesting the purchase.
This is expressed as initials followed by last name.
- REQ-OFFICE
- The office of the person requesting the purchase.
This is where the item should be delivered.
- DEPT
- Department that pays for the order
- ACCT-NUM
- Account number to be charged
- ITEM
- Brief name of the item
- QUANTITY
- Number of the item being order
- COST
- Cost of the item
Here are some organization rules that should help you in normalized the
database.
- All items on a single PO must be paid from the same account number.
- Each item of PO is identified by a line number.
- Every requestor is associated with one department.
- Every account number is associated with one department.
- A department may have several account numbers.
- All items of the same type have the same price.
If you have any questions, send email to brock@cs.unca.edu for a
response.
The Assignment
The table is already in first order form. In a series of three steps
transform the table into tables of
- Second Normal Form
- Third Normal Form
- Boyce-Codd Normal Form
Due dates
This assignment is due on Monday, 5 May. You may turn in either a
handwritten assignment or, for a bit more extra credit, an assignemt
generated using one of the Silverrun CASE tools.
Back to the CSCI 363 homework page
Back to the CSCI 363 home page