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..
What are advantages of object models, What are advantages of object models?...
What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p
Entity-relationship diagram, 1. Item based services will be charged fixed p...
1. Item based services will be charged fixed prices, and time-based will be charged variably depending on time. Such as per hour. Item-based: Fixed, pedicure, waxing, threading, fa
Scope of traffic data management, A TDMS project plan is not a typical Info...
A TDMS project plan is not a typical Information Technology project plan; therefore, a traffic data project has several unique characteristics: Traffic data management system
Mr.dattu, Define a job scheduling strategy that will meet business requirem...
Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori
Fragmentation, let us consider a table having 2200 records and the fixed si...
let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation
Computer, 1. Will you advise that your organization uses open source softwa...
1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development
What are the drawbacks of shadow-paging technique, What are the drawbacks o...
What are the drawbacks of shadow-paging technique? The drawbacks of shadow paging is:- a) Commit Overhead b) Data fragmentation c) Garbage collection
Describe the capabilities offered via mysql client apis, Describe the capab...
Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server
The conceptual level or global level in dbms, The Conceptual Level or Globa...
The Conceptual Level or Global level The conceptual level presents a logical view of the complete database as a unified whole. It permits the user to bring all the data in th
Which operator is cartesian product in relational algebra, Which operator i...
Which operator is Cartesian product in relational algebra? Cartesian product in relational algebra is a binary operator. (It requires two operands. e.g., P X Q)
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
IT Courses and Help
Why Us ?
~24x7 hrs Support
~Quality of Work
~Time on Delivery
~Privacy of Work
Human Resource Management
Literature Review Writing Help
Follow Us |
T & C
Copyright by ExpertsMind IT Educational Pvt. Ltd.