Homework

Homework Questions? Ask a Tutor for Answers ASAP

Ask an Expert,
Get an Answer ASAP!

I have 10 use case questions that need programming in sql projec…

Customer Question
I have 10 use case...
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 would need to be done by this Friday morning.
Submitted: 2 years ago.Category: Homework
Show More
Show Less
Ask Your Own Homework Question
Answered in 8 minutes by:
6/16/2015
Tutor: ATLProg, Software Engineer replied 2 years ago
ATLProg
ATLProg, Software Engineer
Category: Homework
Satisfied Customers: 9,151
Experience: Expert in Java C++ C C# VB Javascript Design SQL HTML
Verified
Hello can you provide more info
Ask Your Own Homework Question
Customer reply replied 2 years ago
Here you go.Objective
Create an initial design for a 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 MS SQL, and implement the database schema.
Default 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 3-at-a-time program.
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.
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.
6. The customer closes their account, but only returns two of the three movies the customer
has at home.
7. Netflix charges the customer $25 for the missing movie.
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, when were these movies returned, and so on.
The rental history is used for two purposes:
 To give employees a basis to work from when they are asked what movie the customer
has rented out or if it was lost in mail
 To determine if the movie was never mailed back by the customer
The database that you design must support all the usual value chain operations occurring at a
video rental e-store. You will design the Entity-Relationship model (ERD) for this database, and
its corresponding relational model. It is not possible to attempt a full production-capable
database for a large enterprise such as NetFlix in the time period afforded by this course; such a
database would have a few hundred tables. A general guideline is that to effectively create this
design for this course, the logical ERD should have between 10 and 20 entities. This number is
not exact and will vary according to your specific implementation. Example entities include
Customer, Movie, Rental, and Queue.
Customer reply replied 2 years ago
Note that this implementation need not provide for streaming or downloadable movie content. I can get you the use case objectives if you accept and I would agree to pay you $100 for your time on this project.
Customer reply replied 2 years ago
I can send over a document that has all the requirements in it. I don't think will take you long at all to do.
Customer reply replied 2 years ago
I have gone with another website and will be requesting a refund. Thank you
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 don't have a legal question, I'm doing a school assignment
I don't have a legal question, I'm doing a school assignment and I'm looking for types of reports for police writing and 5 criteria for good report … read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
A company purchases shipments of machine components and uses
A company purchases shipments of machine components and uses this acceptance sampling​ plan: Randomly select and test 25 components and accept the whole batch if there are fewer than 3 defectives. If … read more
Sandhya_sharma
Sandhya_sharma
Master\u0027s Degree
559 satisfied customers
Test consists of 10​ true/false questions. To pass the test
test consists of 10​ true/false questions. To pass the test a student must answer at least 9 questions correctly. If a student guesses on each​ question, what is the probability that the student will … read more
Sandhya_sharma
Sandhya_sharma
Master\u0027s Degree
559 satisfied customers
Find the probability of at least 2 girls in 8 births. Assume
Find the probability of at least 2 girls in 8 births. Assume that male and female births are equally likely and that the births are independent events. Round to three decimal places… read more
Sandhya_sharma
Sandhya_sharma
Master\u0027s Degree
559 satisfied customers
You can help about this question?: Facts: Garrett is a
you can help about this question ? : Facts: Michael Garrett is a former employee of ABC Auto Repair. He enters the repair shop claiming he is owed $800 in back wages. An argument ensues and he is orde… read more
Gerald, Esq
Gerald, Esq
Juris Doctor
3,868 satisfied customers
I am studying to be a special education teacher. I need
I am studying to be a special education teacher. I need some… I am studying to be a special education teacher. I need some help with an assignment. Can you answer these questions to help me? 1. How ha… read more
judybailey61
judybailey61
Bachelors degree
196 satisfied customers
I have a question about navigation: predicting when and
Hi. I have a question about navigation: predicting when and where two ships will meet. I know their current positions (latitude and longitude), their bearings (directions) and speed. … read more
GLENN GILONGOS
GLENN GILONGOS
Master of Mathematics
411 satisfied customers
On the 2 datasheets, will you find me what the resistance of
on the 2 datasheets, will you find me what the resistance of the thermistor is at 25C degree and 40C degree?… read more
Wes
Wes
Consultant
Bachelor\u0027s Degree
371 satisfied customers
I just need some help with my math homework. Maximum,
Hi there, I just need some help with my math homework … read more
GLENN GILONGOS
GLENN GILONGOS
Master of Mathematics
411 satisfied customers
QUESTION 1 A. Change the articles and the adjectives
QUESTION 1A. Change the articles and the adjectives according to the new nouns. Do not enter full sentences into the space provided. Enter only the words needed, separate each entry with a comma. EXAM… read more
Brad Summers
Brad Summers
Bachelor of Education
9 satisfied customers
What does assignment mean in raptor flowchart. Help with
help with writing programs and what symbols to use in raptor flowchart … read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,731 satisfied customers
I need Java expert to complete my University project.
I need Java expert to complete my University project.Students are required to work on ATM System.More detail will send you when you touch me.… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,731 satisfied customers
I'm trying to install a practice database using instructions
I'm trying to install a practice database using instructions from a book titled “SQL Practice Problems by Sylvia Vasilik” I've installed MS SQL Server MS 2017 and the SQL Server Express Edition 2017. … read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,731 satisfied customers
Compare and contrast the USDA's “MyPlate” with the Harvard
Compare and contrast the USDA's “MyPlate” with the Harvard “Healthy Eating Plate”. What are the similarities and differences between the two? In what ways are either/both of these models helpful for p… read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
Task 1. Do a risk management plan: list of risks involved,
Task 1. Do a risk management plan: list of risks involved, level of the risk, the likelihood of the risks of occurring, management plan, who is responsible for what, the implications/consequences to t… read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
I need help with testout PC Pro exam. Here is a sample link
I need help with testout PC Pro exam. Here is a sample link below: http://www.testout.com/home/certification/testout-pc-pro-certification http://www.testout.com/sample-exam Will provide additional inf… read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
A standard deck of cards contains 52 cards. One card is
A standard deck of cards contains 52 cards. One card is selected from the deck. ​(a) Compute the probability of randomly selecting aa ninenine or aceace. ​(b) Compute the probability of randomly selec… read more
GLENN GILONGOS
GLENN GILONGOS
Master of Mathematics
411 satisfied customers
A rubber ball retains 95% of its kinetic energy after each
A rubber ball retains 95% of its kinetic energy after each bounce. If a ball is dropped from a height of 2 meters what will its speed be just as it hits for its fourth bounce?… read more
GLENN GILONGOS
GLENN GILONGOS
Master of Mathematics
411 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