Use a customer order form and follow the bottom-up database

 Use a customer order form and follow the bottom-up database design  approach. Please include the website URL and an image of this form. 

  1. Find all the attributes on the form.
  2. Establish the dependenci es (determinants).
  3. Group attributes that have a common determinant into an entity type; name it.
  4. Find directly-related entity type pairs.
  5. Determine the connectivity for each pair.
  6. Draw the ERD.
  7. Review the ERD and update to be in 3NF if ERD from step 6 is not in 3NF.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions