Advanced Entity Relationship Diagram An online video distributor such as Netflix might want to create an information system for online sales of movies in both DVD and Blu-ray format. People will be...

Advanced Entity Relationship Diagram An online video distributor such as Netflix might want to create an information system for online sales of movies in both DVD and Blu-ray format. People will be allowed to register as customers of the online site and to update their stored information. Information must be maintained about customers' shipping addresses, e-mail addresses and credit cards. In a single sale, customers will be allowed to purchase any quantity of videos. The items in a single sale will be shipped to a single address and will have a single credit card charge. A customer will be provided with a virtual shopping cart to stare items to be purchased. As each item is selected, it is added to the shopping cart. When the customer finishes shopping, he will be directed to a checkout area where he can purchase all of the items in the shopping cart. At this time, payment and shipping information is entered. Once the sale is complete, the shopping cart will be deleted and the customer will be sent a receipt bye-mail. List the entity classes and attributes that would be necessary for this information system. Develop an Entity-Relationship Diagram that would represent the necessary entities and their relationships. You may hand-draw and scan your ERD, create the ERD in Word, PowerPoint, or Access, or use a dedicated ERD creation program such as E/R Assistant, available for download at: http://highered.mcgraw-hill.com/sites/0072942207/student_view0/e_r_assistant.html