become familiar with the data that is stored in the database that supports this website. You can assume that any data you see on the screens making
up Amazon.com’s website are stored in the database supporting this website. You may find it helpful to interact with the website by creating a
simulated order so that you can see the data involved in placing an order. Please note that there is absolutely no need to actually place an order in
order to answer the exam questions. Please answer the question in full sentences using standard English.
- Identify and describe one referential integrity rule that would be included in the physical design used to design the database supporting
Amazon.com’s website (http://www.amazon.com/).
.
Part 2.
Directions: Answer the question using full sentences and standard English. Please note that the question in this part of the exam is not related in any
way to Amazon.com’s website. - Imagine that you are interviewing job applicants to work in database design for the Ford Motor Company. You ask an applicant about a database
project he or she completed for a university course and he or she tells you that the several of the relations in the project were in third but not first
normal form. Assuming that this is the only thing you know about the applicant would you recommend that Ford hire this applicant? Why or why not?