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

Assignment Help:
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.

Related Discussions:- Create a website for online sales of movies, DOT NET Program

Query, Use a Set operator to create a list of academics who have written or...

Use a Set operator to create a list of academics who have written or co-written less than 5 papers and also have greater than 3 interests. List their academic number in the output.

Complexity- drawbacks of data distribution, Complexity : A distributed DBMS...

Complexity : A distributed DBMS that is available, reliable, and secure is inherently more difficult than a centralised DBMS. Though, adequate data replication is essential to have

Each statement should have a where clause, Submit SQL SELECT Statements to ...

Submit SQL SELECT Statements to demonstrate several reports off your database, according to the following guidelines: You must submit at least 5 SELECT Statements. Each

Guidelines for creation of table, Guidelines for creation of table: ...

Guidelines for creation of table: Table name should begin with an alphabet. In table name, single quotes and blank spaces are not allowed. Reserve words of that DBM

Access data using logical database, If one requires to access data using...

If one requires to access data using Logical Database , the use of events is unavoidable. Yes, if someone wants to access data using Logical database then the use of events

Normalise data to third normal form, A software contract and consultancy fi...

A software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. These details comprise: Employee Numbe

What is database files , The database files accept the actual data and ...

The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

Need customer management program, Project Description: This is a Custome...

Project Description: This is a Customer Management project. Customer data is presented in a text file. The program can load this text data into its database columns. The data ma

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd