Homework

Homework Questions? Ask a Tutor for Answers ASAP

Ask an Expert,
Get an Answer ASAP!

Any database experts who can help with below term project?

Customer Question
Hello , Any database experts...
Hello , Any database experts who can help with below term project?Objective
Create an initial design for the database schema for an online DVD rental business that is
similar to the DVD rental portion of the business pioneered by NetFlix®. Map your conceptual
design into your approved DBMS, and implement the database schema.
Project Description
Design a database for a DVD rental business such as Netflix.com. The store rents DVDs online.
The customer business model is illustrated below.
In order to rent a movie, a person must be enrolled at the online store. There are two different
membership programs. As quoted from NetFlix®:
“With NetFlix you can rent as many DVDs from the comfort of your home and have them
delivered to your door in about 1 business day. There are no late fees and no due dates,
and shipping is free both ways. Programs start at $11.99 plus any applicable tax. With our
most popular program, 3-at-a-time, you can rent as many DVDs as you want for just
$17.99 a month. You keep a revolving library of up to 3 DVDs at a time and can exchange
them for new available DVDs as often as you like. … Our 2-at-a-time program (limit 4
DVDs per month) is $11.99 plus any applicable tax per month.” (From
http://www.netflix.com)
Below is an example use case to aid in understanding the Netflix operation:
1. A customer signs up for the three-at-a-time plan.
2. The same customer adds 10 movies to their queue.
3. Netflix mails to the customer the first three movies in their queue.
4. The customer watches and returns the first movie to Netflix.
Page 2 of 5
5. Netflix mails out the next movie in the queue to the customer, which is the fourth movie
added to the queue in Step #3.
This use case is not exhaustive. There will be elements in your database mentioned in the
Netflix specification, but not mentioned in this use case.
The database will store membership information for each person, the movies she/he rented,
movies in the queue to be rented, and so on. The rental history can be used for many purposes,
including:
 customers reviewing what they have rented.
 employees reviewing what a customer has rented for situations where the customer
never mailed the movie back or the movie was lost in the mail.
 Neflix analyzing many customers’ rental histories to determine the least popular and most
popular movies for marketing purposes.
Use Cases
Below are a total of 10 use cases. The use cases come in pairs, and each pair covers one
aspect of the Netflix Operation. A complete schema design will allow all ten of these use cases
to be addressed in full. For use cases where information is requested, provide a single query to
retrieve the information. For use cases that require data modification, develop a parameterized
stored procedure that performs the modifications, and invoke the stored procedure. The stored
procedures you create should be designed to be reusable, by making use of one or more
parameters. For example, the stored procedure for use case #***** should use at least two
parameters – one to specify the customer and another to specify the particular movie being
rented.1) Rentals
a. A customer rents the movies “X-Men: Days of Future Past” and “The Angry
Birds Movie”. Develop a parameterized stored procedure that supports a
customer renting a movie, then invoke the stored procedure two times (to
satisfy the use case) for acustomer of your choosing.
b. A customer requests the titles of all movies they have rented that are directed
by “George Lucas” and “Rich Christiano”. Write a single query that retrieves
this information for a customer of your choosing.
2) Movie Queue
a. A customer adds a movie to their queue so that the newly added movie will be
the next movie they receive. Develop a parameterized stored procedure that
accomplishes this, then invoke the stored procedure for a customer and movie
of your choosing.
b. A customer wants to see the names of the first three movies in their queue.
Write a single query that retrieves this information for a customer of your
choosing.
3) Enrollment
a. A customer enrolls in the two-at-a-time plan and another customer enrolls in
the three-at-a-time plan. Develop a parameterized stored procedure that
accomplishes this, then invoke the stored procedure two times (to satisfy the
use case) for customers of your choosing.
Page 3 of 5
b. Management requests the names of all currently active customers that are
enrolled in the two-at-a-time plan. Write a single query that retrieves this
information.
4) Inventory
a. Netflix acquires three more copies of the movie “Star Trek Into Darkness”, and
two more copies of “Dredd”, and a staff member records these inventory
changes in the database. Develop a parameterized stored procedure and
invoke it multiple times to satisfy the use case.
Submitted: 7 months ago.Category: Homework
Show More
Show Less
Ask Your Own Homework Question
Answered in 1 day by:
11/30/2017
Tutor: George Sibiya, Computer Hardware Engineer replied 7 months ago
George Sibiya
George Sibiya, Computer Hardware Engineer
Category: Homework
Satisfied Customers: 364
Experience: PhD in Computer Science
Verified
Hi,
Welcome to JustAnswer and thank you for utilizing our services.
By when is this require?
Regards,
G
Ask Your Own Homework Question
Customer reply replied 7 months ago
next week, thanks.
Tutor: George Sibiya, Computer Hardware Engineer replied 7 months ago

Ok I'll target to complete it over the weeked

Ask Your Own Homework Question
Tutor: George Sibiya, Computer Hardware Engineer replied 7 months ago

Please do not hesitate to check on progress then

Ask Your Own Homework Question
Customer reply replied 7 months ago
ok sure
Customer reply replied 7 months ago
do you have update?
Tutor: George Sibiya, Computer Hardware Engineer replied 7 months ago

I'll update you in lesser than 6 hours

Ask Your Own Homework Question
Tutor: George Sibiya, Computer Hardware Engineer replied 7 months ago

delayed but still on it

Ask Your Own Homework Question
Customer reply replied 7 months ago
ok, what you looking from me?
Tutor: George Sibiya, Computer Hardware Engineer replied 7 months ago

Just got back to it now after office work

Ask Your Own Homework Question
Tutor: George Sibiya, Computer Hardware Engineer replied 7 months ago

Just a quick one, is MySql one of your approved DBMS?

Ask Your Own Homework Question
Customer reply replied 7 months ago
i would need need Oracle SQL developer
Tutor: George Sibiya, Computer Hardware Engineer replied 7 months ago

Ok thanks

Ask Your Own Homework Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a tutorLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Scott Your Own Question
Scott
Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3,040
3,040 Satisfied Customers
Experience: MIT Graduate (Math, Programming, Science, and Music)

Scott is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

Meet the Experts:

LogicPro

LogicPro

Engineer

5,867 satisfied customers

Expert in Java C++ C C# VB Javascript Design SQL HTML

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

4,556 satisfied customers

More than 5000 online tutoring sessions.

Linda_us

Linda_us

Finance, Accounts & Homework Tutor

3,138 satisfied customers

Post Graduate Diploma in Management (MBA)

Chris M.

Chris M.

M.S.W. Social Work

2,698 satisfied customers

Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)

F. Naz

F. Naz

Chartered Accountant

2,190 satisfied customers

Experience with chartered accountancy

Bizhelp

Bizhelp

CPA

1,887 satisfied customers

Bachelors Degree and CPA with Accounting work experience

Seanna

Seanna

Tutor

1,781 satisfied customers

3,000+ satisfied customers, all topics, A+ work

< Previous | Next >

Related Homework Questions
Need help with term project. 1) Rentals a. A customer rents
Helloneed help with term project.1) Rentals a. A customer rents the movies “X-Men: Days of Future Past” and “The Angry Birds Movie”. Develop a parameterized stored procedure that supports a customer r… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,867 satisfied customers
I have the same project with the person who asked 3 months
so I have the same project with the person who asked 3 months ago.(https://www.justanswer.com/homework/adlff-term-project-need-help-with.html) I'm wondering that if I can get the answer? … read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
201 satisfied customers
I saw that you've helped out Matt last month. I need similar
Hi Donna. I saw that you've helped out Matt last month. I need similar help with the same project. I have the logical ERD but need help with the use cases. Is that something you can help me with pleas… read more
George Sibiya
George Sibiya
Computer Hardware Engineer
364 satisfied customers
I need the following 10 use cases and and ERD completed. For
I need the following 10 use cases and and ERD completed. For the use cases below- please provide the queries in a zipfile. The logical ERD will be mapped to a relational database schema through the us… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,867 satisfied customers
In this project you will be provided with a description of
In this project you will be provided with a description of an application (below) to create an entity-relationship diagram (ERD) and design accompanying table layout using sound relational modeling co… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,867 satisfied customers
I have 10 use case questions that need programming in sql projec
I have 10 use case questions that need programming in sql for a project that I a working on. I can send over the requirements and wondered if you would be willing to take on this small project? It wou… read more
ATLProg
ATLProg
Sr Software Engineer
Master\u0027s Degree
1,448 satisfied customers
In this project you will be provided with a description of
In this project you will be provided with a description of an application (below) to create an entity-relationship diagram (ERD) and design accompanying table layout using sound relational modeling co… read more
ATLProg
ATLProg
Sr Software Engineer
Master\u0027s Degree
1,448 satisfied customers
I have a 2 part project that I need completed. It must be
I have a 2 part project that I need completed. It must be original. It includes a entity relationship diagram and detailed documentation. This is similar to what you did three months ago. I'll tel you… read more
Expert
Expert
This project allows students to demonstrate their skills in
This project allows students to demonstrate their skills in the area of designing relational databases to satisfy specific business rules and requirements. The deliverables for this project include an… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,867 satisfied customers
Can you re-create a projected I saw that you worked on for a
Can you re-create a projected I saw that you worked on for a different customer? (Original URL: http://www.justanswer.com/question/qa-guest-expert.aspx?TID=11662296) Project Part 1 Details: In this pr… read more
jatechexpert
jatechexpert
Master\u0027s Degree
1 satisfied customers
In this project you will be provided a set of specifications
In this project you will be provided a set of specifications to create an entity-relationship diagram and design accompanying table layout using sound relational modeling concepts and practices. The r… read more
ehabtutor
ehabtutor
C.E.O
Bachelor\u0027s Degree
22 satisfied customers
Good morning,I noticed you have worked with this question
Good morning, I noticed you have worked with this question before: You are a database consultant with Ace Software, Inc. and have been assigned to develop a database for the Mom and Pop Johnson video … read more
jatechexpert
jatechexpert
Master\u0027s Degree
1 satisfied customers
Based on our operational database, movie distributing and renting
Based on our operational database, movie distributing and renting system (focus on movie distribution and sale), build a data mart (star schema) which can answer the following questions: 1) Which movi… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
In this project you will perform the physical design and implementation
In this project you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data Manip… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,867 satisfied customers
Project 1 Details: In this project you will be provided a
Project 1 Details: In this project you will be provided a set of specifications to create an entity-relationship diagram and design accompanying table layout using sound relational modeling concepts a… read more
Mr. Wilson
Mr. Wilson
Teacher
Master\u0027s Degree
200 satisfied customers
In this project you will be provided a set of specifications
In this project you will be provided a set of specifications to create an entity-relationship diagram and design accompanying table layout using sound relational modeling concepts and practices. The r… read more
Steve Herrod
Steve Herrod
Senior Customer Care Engineer
Master\u0027s Degree
882 satisfied customers
6.34. Specify and execute the following queries in
6.34. Specify and execute the following queries in relational algebra (RA) using the RA interpreter on the COMPANY database schema in Figure 3.5. a. List the names of all employees in department 5 who… read more
Steve Herrod
Steve Herrod
Senior Customer Care Engineer
Master\u0027s Degree
882 satisfied customers
Hello Toneemarie, I need your assistance with a case analysis
Hello Toneemarie, I need your assistance with a case analysis that I have to complete NLT 16July09. I would like to know if you can complete this for me for the sum of 50.00. I.Introduction (15 points… read more
RopTeam
RopTeam
Project Manager
Master\u0027s Degree
578 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x