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
Counting Number of Words in a String - C# Program Anyone can suggest me the output of the following program. using System;   class CountWords { public static void

I need asp.net print page task Project Description: I have a little task on asp.net, I need to print a text data to receipt printer from web page, I used the subsequent code

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?

In this assignment you will create a Windows application that mimic the ILDASM application. Your application should have at least the following features: 1. A multi-form applica

Briefly explain the characteristics of value-type variables that are supported in the C# programming language. The variables that are based on value types directly contain valu

Can you give a practical implementation of FAÇADE patterns? The Façade pattern sits on the top of lot of the subsystems & makes access easy to interfaces of these subsystems. T

Construct a .NET wrapper for a C++ Dll - repost Project Description: We have a classic VC++ Dll (source code of DLL not required) that requires a .NET wrapper built by you. U

Project Description: I am having a table available in excel format and features the subsequent: - It has about 170000 rows - Some text is longer than 255 in length. - S

Custom Login Page for SharePoint 2013 with Active Directory Project Description: I would like to prepare a webpart or an application for Sharepoint 2013 foundation. The we

What is DTD? The Document Type definition (DTD) defines how your XML should structure. For illustrate in the above XML we want to make it compulsory to provide "qty" and "total