Create a website for online sales of movies, DOT NET Programming

Niles Video Inc. wants to create a website for online sales of movies (DVD and videotapes). People will be allowed to register as customers on the website 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 movies. The items in a single sale will be shipped to a single address and will have a single credit card charge.

The website must provide customers the ability to store items to be purchased.  When the customer finishes shopping, he will be directed to a checkout area where payment and shipping information is entered. Once the sale is complete, the customer will be sent a receipt by e-mail.

Draw an ER diagram to represent Niles Video Inc.  Your ER diagram should include all the essential attributes for each entity to support the application.  You should use the notation that we use in the class and should include primary key information as well as cardinalities.

Translate your ER diagram into the corresponding relational database schema.

Identify the primary key for each table obtained from step 2 above (Identify the primary key for two of the tables obtained from step 2 above if you're working on this on your own.)

Using DDL, create your database obtained from step 2 above. (using H2)

Using DDL, populate the database (for all the tables in your design) with meaningful records to support the queries in question 6 below. (Using H2)

Identify the appropriate indexes for each table obtained from step 2 above (Identify the appropriate indexes for two of the tables obtained from step 2 above if you're working on this on your own.)

Write queries to answer the following questions based on your design:

Find all those customers who have not purchased anything from Niles Video Inc.

Get the total number of DVDs and video tapes sold per genre.

Get the average number of DVDs per purchase.

Posted Date: 2/14/2013 7:23:56 AM | Location : United States







Related Discussions:- Create a website for online sales of movies, Assignment Help, Ask Question on Create a website for online sales of movies, Get Answer, Expert's Help, Create a website for online sales of movies Discussions

Write discussion on Create a website for online sales of movies
Your posts are moderated
Related Questions
Delay signing During the development process you  need strong keys name  to be exposed to the developer which is not a good practice from security aspect .In such situations yo

Project Description: I have a site that's previously fully developed, and need to fix some small problems (Text editor posting error, and a Server error caused by some Nhibernat

deploying a mysql vb offline desktop application in new system that doesnot have any server or database created

Create login page: Consider the login page for a typical webmail service, such as GMail or Outlook Mail. Your task for this assignment is to design a test plan for such a logi

Describe the services that UDDI provides to Web applications. UDDI gives the following types of services to a Web application: XML Schema for business descriptions - Contain

What are benefits and limitations of using Hidden frames 1)    The benefits of using hidden frames are as follows: 2)    More than one data field can cache. 3)    The abi

Project Description I require a Automated penny auction bidder software (bidder robot, sniper software, Autobidder ) that put bid at specific milliseconds Nanoseconds from the e

Explain the XML elements. The elements are the central units of an XML document that define and identify data. The elements are represented by the tags. You can also make your

What is garbage collection? Explain the difference among garbage collections in .NET 4.0 and earlier versions. Garbage collection stops memory leaks during execution of pro

Explain memory-mapped files. Memory-mapped files (MMFs) permit you map the content of a file to the logical address of an application. These files enable the multiple processes