Customer Service Chat
Get quote & make Payment
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
Ask an Expert
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
Write your message here..
Database Design & Management, I need help for my Uni assignments
I need help for my Uni assignments
Define data independence, Data independence seems that "the application is...
Data independence seems that "the application is independent of the access strategy and storage structure of data". In other words, the ability to change the schema definition in o
What is deadlock, What is deadlock? Neither of the transaction can ever...
What is deadlock? Neither of the transaction can ever proceed with its normal implementation. This situation is known as deadlock.
Explain outer join, Explain outer join? Outer Join - If there are any...
Explain outer join? Outer Join - If there are any values in one table which do not have corresponding value(s) in the other, in an equi-join which will not be chosen. Such ro
ER-diagram, The State of NewYork certifies firefighters throughout state an...
The State of NewYork certifies firefighters throughout state and keep track all of them, as well as of the state’s fire departments. Each fire department has unique department numb
Demonstrate the design of associations, Demonstrate the Design of associati...
Demonstrate the Design of associations During object design phase we must design a strategy to implement associations. Association may be unidirectional or bi-directional. Wha
Extended star schema model, A customer places orders for parts and belongs ...
A customer places orders for parts and belongs to a particular industry group. An individual order is taken by a particular sales representative on a specific date and the sales re
Define a view and a trigger, Define a view and a trigger. Construct a view ...
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 decision support systems, Question: (a) What are decision sup...
Question: (a) What are decision support systems, and what role do they play in the business environment? (b) Data mining is a knowledge discovery process of automated extr
Explain the object-oriented decomposition, Explain the Object-oriented deco...
Explain the Object-oriented decomposition Object-oriented decomposition targets at identifying individual sovereign objects that encapsulate both a state and certain behavio
Accounting Assignment Help
Economics Assignment Help
Finance Assignment Help
Statistics Assignment Help
Physics Assignment Help
Chemistry Assignment Help
Math Assignment Help
Biology Assignment Help
English Assignment Help
Management Assignment Help
Engineering Assignment Help
Programming Assignment Help
Computer Science Assignment Help
Why Us ?
~24x7 hrs Support
~Quality of Work
~Time on Delivery
~Privacy of Work
Human Resource Management
Literature Review Writing Help
Terms & Conditions
Copyright by ExpertsMind IT Educational Pvt. Ltd.