Ted's rental equip rents to individuals. Ea piece of equip has tag affixed w/ unique serial #. Customer signs rental agreement. Rental agreement has unique number and can include rental of one or more pieces of equip. Ea Cust has unique customer # and can have more than one rental agreement (even on same day).
1. Create single, unnormalized relation thaty includes all of the fields.
2. Convert the unnormalized relation to 1NF.
3. Convert the 1NF to 2NF.
4. Convert the 2NF to 3NF.
Must be done in Word.
Answer all four questions in MS Word file.