Create a website for online sales of movies, DOT NET Program, Database Management System

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: 3/20/2013 8:58:46 PM | Location : United States







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

Write discussion on Create a website for online sales of movies, DOT NET Program
Your posts are moderated
Related Questions
Define the step - Rearranging the Execution Order for Efficiency As we know that algorithm and data structure are closely related to one another, but data structure is conside

Consider the following relations: BRANCH( bno, street, area, city, pcode, Tel_no, Fax_no) STAFF( Sno, Fname, Lname, address, position , salary, bno) Express the subsequent qu

Attributes having a one value for a particular entity. For instance, Age is a single valued attribute of a student entity. Attributes  that  have  more  than  single  values

Explain the Functional Mode with help of an example. Functional Model  The functional model shows a computation and functional derivation of data values in it without ind

Define a view and a trigger. Construct a view for the above relations that have the information about suppliers and the elements they supply. The view holds the S#, SNAME, P# , PNA

What are the two distinct aspects to the implementation of associations? i) It is required to define data declarations which will enable details of actual links to be stored. I

What are the functions of an accumulator? The accumulator is the register associated with the ALU operations and sometimes I/O operations. It is an integral part of ALU. It hol

Update Anomaly : This anomaly is occurred due to data redundancy. Redundant information makes updates more complex since, for example, varying the name of the instructor of MCS-014

Your friend owns and operates a wholesale shoe business with annual revenues of $5 million dollars. His wholesale business specializes in supplying and supporting retailers with sh

Explain the Recoverable Schedule A recoverable schedule is one in which for each pair of transactions Ti and Tj such that Tj reads a data item formerly written by Ti, the comm