Use a customer order form and follow the bottom-up database design approach. Please include the website URL and an image of this form.
- Find all the attributes on the form.
- Establish the dependenci es (determinants).
- Group attributes that have a common determinant into an entity type; name it.
- Find directly-related entity type pairs.
- Determine the connectivity for each pair.
- Draw the ERD.
- Review the ERD and update to be in 3NF if ERD from step 6 is not in 3NF.