The system development team at the XYZ Company is working on developing a new cu
ID: 3827363 • Letter: T
Question
The system development team at the XYZ Company is working on developing a new customer order entry system. In the process of designing the new system, the team has identified the following data entity attributes:
Inventory Order
Order Number (identifier)
Order Date
Customer Name
Street Address
City
State
Zip
Customer Type Initials
District Number
Region Number
1 to 22 occurrences of:
- Item Name
- Quantity Ordered
- Item Unit
- Quantity Shipped
- Item Out
- Quantity Received
1) State the rule that is applied to place an entity in first normal form. Revise this data model so that it is in first normal form.
2) State the rule that is applied to place an entity into second normal form. Revise the data model (if necessary) to place it in second normal form.
Explanation / Answer
1) First Normal Form : A relation is in first normal form if all the attribute values of relation are atomic.
All the attributes of the above relation are atomic by removing mutiple values . So the relation is in First Normal Form.
Inventory Order (Order Number,Order Date,Customer Name,Street Address,City,State,Zip,Customer Type Initials,District Number,Region Number,Item Name,Quantity Ordered,Item Unit,Quantity Shipped,Item Out,Quantity Received)
2) Second Normal Form : A relation is in Second Normal Form if it is in First Normal Form and all non key attributes are fully functionally dependent on the primary key
The above relation is not in the Second Normal Form as some of the non key attributes are not fully functionally dependent on Order Number
Functional dependencies:
Order Number -> Order Date
Order Number -> Customer Name
Order Number -> Street Address
Order Number -> City
Order Number -> State
Order Number -> Zip
Order Number -> Customer Type Initials
Order Number -> District Number
Order Number -> Region Number
Item Number -> Item Name
Item Number -> Quantity Ordered
Item Number -> Item Unit
Item Number -> Quantity Shipped
Item Number -> Item Out
Item Number -> Quantity Received
So revised relations are:
ORDER(Order Number ,Order Date,Customer Name, Street Address,City, State,Zip, Customer Type Initials,District Number, Region Number)
ITEM(Item Number ,Item Name,Quantity Ordered, Item Unit,Quantity Shipped,Item Out, Quantity Received)
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.