Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 ui I 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 ui

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Collectible Investments For The High Net Worth Investor

Authors: Stephen Satchell

1st Edition

0123745225,0080923054

More Books

Students also viewed these Finance questions

Question

1. Define reality mining.

Answered: 1 week ago