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
Define the ToolTip control. How can you associate it with other controls? The ToolTip control produces a small pop-up window with explanatory text for an element it is displaye

How will you do code reviews? The way in which the code reviews are done change from person to person and also from company to company. But generally when a project is started

What is the difference between "using System.Data;" and directly adding the reference from "Add References Dialog Box"? When you compiles a program using command line, u add th

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

What are tuples? Tuple is a fixed-size collection that can have elements of either similar or different data types. Same to arrays, a user must have to specify the size of a tu

What is code access security (CAS)? Code access security (CAS) is part of the .NET security model that stops unauthorized access of resources and operations, and restricts the

I want a C# school project Project Description: The project is made in C# and haves a database connection. We have some small problems asking up data from the database.

I want to develop SMS application with auto reply based on the content of the message using gsm modem. eg.Student results checking using cell phone via sms. How do i do this?

What is MVC pattern? The main purpose  of using  the MVC pattern is to decouple the GUI from the Data. It also gives the ability to provide multiple views for the same Data. Th

Explain ExpandoObject and DynamicObject classes. The ExpandoObject class refers to a class whose members can be explicitly added and removed at runtime. In other words, the Exp