A television production company wants to start a Web site to sell items and replicas of items from its popular shows. Items on the site are generally sorted by show. People choose the items and add them to the shopping cart. At that point, they enter standard credit card data to check out. The server adds additional data such as the IP address of the user. Customers can also create accounts with a username and password. Create the class diagram and the list of the normalized tables (in a table notation form), for this TV Production company based on their business rules. As we discussed in class especially in this level there is not just one answer. You have to justify the decisions you made for the classes and the relationships. Show all the steps followed to reach the final tables and class diagram. Make sure to include the As-is, 1NF, 2NF, and 3NF normalizations when you submit (50 points)
Sale Date Shipping Address City, State, ZIP
Last name, First name
Billing Address
City, State, ZIP Code Credit Card Number Expiration Date
IP Address
Username/password
USD TV Show Description Quantity Sale Price Value
Total Tax Shipping
Total Amount