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: 4 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 4 months ago
George Sibiya
George Sibiya, Computer Hardware Engineer
Category: Homework
Satisfied Customers: 287
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 4 months ago
next week, thanks.
Tutor: George Sibiya, Computer Hardware Engineer replied 4 months ago

Ok I'll target to complete it over the weeked

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

Please do not hesitate to check on progress then

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

I'll update you in lesser than 6 hours

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

delayed but still on it

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

Just got back to it now after office work

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

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

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

Ok thanks

Ask Your Own Homework Question
Was this answer helpful?
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,731 satisfied customers

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

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

4,551 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,636 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,161 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
I have a school assignment; I have to write a motion in
Hello there, I have a school assignment; I have to write a motion in liming regarding "Plaintiff lying to a professor about a stolen laptop" Plaintiff told professor laptop was stolen but one of her f… read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
I have a question do want me to type it to you or is there a
i have a question do want me to type it to you or is there a fee that u will charge … read more
Ashok Kumar
Ashok Kumar
Master\u0027s Degree
291 satisfied customers
I just need some help for my Tefl course. I need to make a
Hello. i just need some help for my Tefl course. I need to make a straight-arrow ESA lesson plan for an elementary level class of adults in which the students would learn the vocabulary for finding pl… read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
Choose one of the thirteenth-century literary forms
Choose one of the thirteenth-century literary forms discussed in the lesson "Thirteenth-Century Literature." Find more information about it in an encyclopedia or an anthology of medieval literature. R… read more
GLENN
GLENN
Master of Mathematics
392 satisfied customers
I need help with an excel document. I have an excel document
I have an excel document that requires financial data put in the right columns from financial statement, balance sheet, and cash flow report from Alere Inc. I have the excel document and required financial report. … read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
Which of the following would measure the renal vein function
Which of the following would measure the renal vein function from the testicles to the kidney? Lower limb arterial doppler, lower limb venous doppler, carotid doppler, upper limb arterial doppler, upp… read more
GLENN
GLENN
Master of Mathematics
392 satisfied customers
Im trying to write an equation to test the following
Im trying to write an equation to test the following hypotheses - Districts that provide employee cybersecurity education provide more cybersecurity education opportunities for students than districts… read more
GLENN
GLENN
Master of Mathematics
392 satisfied customers
I have got an audio assignment in Spanish which I had to
I have got an audio assignment in Spanish which I had to translate and submit.. so can you help me with that? … read more
Cher
Cher
JustAnswer Expert & Mentor;Teacher/Tutor
Masters Degree
1,382 satisfied customers
Chapter: 10-11 Assignment: Do some research and write a 2-3
Chapter: 10-11Assignment: Do some research and write a 2-3 page paper on the use of Java in the browser. Pay particular attention to the future of the Java "plug-in" for browsers. Please include a dis… read more
GLENN
GLENN
Master of Mathematics
392 satisfied customers
I need help with my stats hw. Customer Amount of Tip ($)
Customer Amount of Tip ($) Amount of Bill ($) Number of Diners (Y) (X1) (X2) 1 $7.00 $48.97 5 2 $4.50 $28.23 4 3 $1.00 $10.65 1 4 $2.40 $19.82 3 5 $5.00 $28.62 3 6 $4.25 $24.83 2 7 $0.50 $6.24 1 8 $6.00 $49.20 4 9 $5.00 $43.26 3 10 $4.75 $31.36 4 11 $5.25 $32.87 4 12 $6.00 $34.99 3 13 $4.00 $33.91 4 14 $3.35 $23.06 2 15 $0.75 $4.65 1 16 $3.30 $23.59 2 17 $3.50 $22.30 2 18 $3.25 $32.00 2 19 $5.40 $50.02 4 20 $2.25 $17.60 3 21 $5.50 $44.47 4 22 $3.00 $20.27 2 23 $1.25 $19.53 2 24 $3.25 $27.03 3 25 $3.00 $21.28 2 26 $6.25 $43.38 4 27 $5.60 $28.12 4 28 $2.50 $26.25 2 29 $9.25 $56.81 5 30 $8.25 $50.65 5 … read more
GLENN
GLENN
Master of Mathematics
392 satisfied customers
The bank will be minute based. Each customer will be added
The bank will be minute based. Each customer will be added to the queue at a random interval from 1 to 4 minutes. Run the simulation for 480 minutes. Use the following Algorithm: . 1) Choose a random … read more
Raj
Raj
SAP ABAP Consultant
Master\u0027s Degree
27 satisfied customers
Seem to be stuck in Adapted Mind at Level 28 of 4th grade
Seem to be stuck in Adapted Mind at Level 28 of 4th grade math. Can you help with that? … read more
GLENN
GLENN
Master of Mathematics
392 satisfied customers
Can you please help me with the following Countries with a
can you please help me with the following Countries with a socialist background have been moving toward the decentralization of healthcare delivery thereby allowing more of a private sector. … read more
lani_s
lani_s
Bachelor\u0027s Degree
47 satisfied customers
C++ can also gve me the algoritm Part I: Create three
c++ can also gve me the algoritmPart I:Create three arrays: (Be sure to do this first) You can put the data into a file (extra credit) or hard code it in main. The data is as follows:NAMES GRADES AGES… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,731 satisfied customers
Drawings that depict existing conditions are often marked
Drawings that depict existing conditions are often marked with A. blue lines indicating future expansion plans. B. the term "graphic FACP required." C. the term "as-built." D. a symbols legend.… read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
Exam Results Technology Orientation, Part 1 Exam Number
Exam ResultsTechnology Orientation, Part 1 Exam Number 062005RR Grade 65 Date Graded 04/15/18 Question Number Your Answer Answer Reference 1. C Correct 2. C D PAGE 42 3. D C PAGE 66 4. C A PAGE 10 5. … read more
Chris M.
Chris M.
M.S.W. Social Work
Master's Degree
2,636 satisfied customers
I very new to programming. I am working on a uni assignment.
I very new to programming. I am working on a uni assignment. And I stuck on one part of my code. I have been trying to fix it for 4 hours, and I cant figure it out … read more
George Sibiya
George Sibiya
Computer Hardware Engineer
287 satisfied customers
Glenn, Attached you can see the new assignment. Due in three
Hi Glenn, Attached you can see the new assignment. Due in three days. Let me know if it is clear… read more
GLENN
GLENN
Master of Mathematics
392 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