Question: For this project exam, please pretend you are a database analyst for the Sees Candy company. This company exists, and you can visit their website
For this project exam, please pretend you are a database analyst for the Sees Candy company. This company exists, and you can visit their website at www.sees.com. Go to their website and look through their product pages. Answer for yourself and me the following questions: What types of product units do they sell? What is the smallest unit? What is the largest unit? Try out their online ordering process. (Dont order candy unless you plan to pay for it yourself! What is their online booking process like? When you place an order, what transaction data do they gather? When you try to order candy online, what customer data do they gather? When you order candy online, what payment data do they gather? Next, think about the database that underlies this web page. Assume that this is a typical normalized online transaction Database. Please identify the database tables needed to keep track of the information this web application collects. What to Submit Typed full-sentence answers to questions 1 through 5. An ERD (Entity Relationship Diagram) showing the table names, primary and foreign keys, and relationships for the Sees Database
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
