Reference no: EM133425157

Question: Consider purchasing two or more physical books or other products from Amazon. Feel free to visit amazon.com and pick out two or more books and take the order to the point it asks for your credit card if you are unsure of what is involved. Think about what key pieces of information Amazon must keep track of in order to process an order. Other than not assuming there is only one product in every order, you can simplify this as much as you want. For example, you don't need to worry about shopping carts, multiple shipments, or multiple payments for a single order. Focus on the bare essentials.

Use the ERDPlus tool shown in class, draw an entity-relationship diagram for a database to keep track of information for Amazon. Instructions to use the ERDPlus tool are on the next page. Focus on the customer/sales side of the business (you do not need to worry about employees or purchase orders from suppliers). Again, you also don't need to worry about shopping carts, multiple shipments, or multiple payments for a single order. You do not need to list all fields for each table, but you should specify cardinalities. Note that there is no 'right' answer to this question (although there are plenty of wrong and not so good answers). Your database should have at least three tables, but if you are ending up with many more than four you are making the assignment harder than intended, i.e., while the database could have many more than four tables, you should not worry about secondary tables