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: 3 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 3 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 3 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 3 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 3 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 3 years ago
I have gone with another website and will be requesting a refund. Thank you
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,894 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,699 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,194 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 a term project using SQL programming language
Need help with a term project using SQL programming language strictly Focusing on the Use Cases 1-5 (10 in total). See attached--… read more
Raj
Raj
SAP ABAP Consultant
Master\u0027s Degree
27 satisfied customers
Logic Pro or ANY EXPERT, I have a programming project I need
Hello Logic Pro or ANY EXPERT, I have a programming project I need your help with. Is there a way I can message you the requirements privately? It will involve using VS 2012 express for web and SQL Se… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,894 satisfied customers
I need the programming code for a project I'm working on, but
I need the programming code for a project I'm working on, but the instructions for the project are too long to fit in this 5000 character text box. It is a basic HTML programming project similar to on… read more
The-PC-Guy
The-PC-Guy
Bachelor\u0027s Degree
630 satisfied customers
Hi,I need you to do Project 2 but first take a look at
Hi, I need you to do Project 2 but first take a look at project 1 below to make sure how the steps we do in class so you don't make big difference to avoid that my teacher will notice. http://wikisend… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
For logic pro... Here is a project I need by Sunday 16th
For logic pro... Here is a project I need by Sunday 16th please. I have some information I can send you what's the link to upload? Design a solution for your organization. Include the following: • A d… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,894 satisfied customers
I need help in creating a fictional website. The reason I need
I need help in creating a fictional website. The reason I need help in creating this website is because it is for a class and I have been without a laptop computer for the past month. by the time I go… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
For LogicPro Only, I have another program that require
For LogicPro Only, I have another program that require coding as you will see on the zip file that am going to sent to you LogiPro… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,894 satisfied customers
Hello I see that you have done several of these SQL homeworks. For
Hello I see that you have done several of these SQL homeworks. For the Advanced Relational Database Project 2- mail- order database. I was wondering if you had the answer saved. My requirements are ex… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
Hello, i am requiring some help with a C++ computer science
Hello, i am requiring some help with a C++ computer science question, I have all tine information on a word document which i can send once someone responds to my question. thanks… read more
John
John
Software Engineer
509 satisfied customers
Hello,How are you doing?Might you be having solutions
Hello, How are you doing? Might you be having solutions to Pennfoster's Advanced Database Technology Projects? They are; Database Concepts Exam Number 402589 Database Implementation Exam Number 402590… read more
Mr. Wilson
Mr. Wilson
Teacher
Master\u0027s Degree
200 satisfied customers
Create Oracle database tables using using a table given.
Project 2 Details: 1. Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in Project 1. Make sure that entity and referential integrity are enforced by declari… read more
ehabtutor
ehabtutor
C.E.O
Bachelor\u0027s Degree
12 satisfied customers
Hi Raj...Can you help me the following sections of my project.
Hi Raj...Can you help me the following sections of my project. Please let me know if you can. Thanks 1.3. Database Description What type of DB will you use for the application? 2.2. Data Flow In this … read more
Raj
Raj
SAP ABAP Consultant
Master\u0027s Degree
27 satisfied customers
Hello Doc, you helped me out over a month ago with some database
Hello Doc, you helped me out over a month ago with some database work and I was wondering if you would be able to help me out with some ASP.NET Web Application with Oracle this time around. I am using… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
I need an ASP.NET code for creating a log in page with username
I need an ASP.NET code for creating a log in page with username and password XXXXX a security feature that would lock the account after 3 unsuccessful attempts at logging in and give the user the opti… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
Project 2In this project you will perform the physical
Project 2 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 … read more
C.Martin
C.Martin
IT Consultant
Bachelor's Degree
453 satisfied customers
Hi, I have a project that I dont know how to do it. Anyone
Hi, I have a project that I don't know how to do it. Anyone can help me? Project 2 Details: 1. Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in Project 1… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
I need help with a Visual Basic final project. Can anyone
Attachment: 2013-02-19_211447_final_graded_project.docx I need help with a Visual Basic final project. Can anyone help me? file attached.… read more
R.R. Jha
R.R. Jha
Bachelor\u0027s Degree
150 satisfied customers
Hi, i need help with homework, this is programming in oracle
Hi, i need help with homework, this is programming in oracle SQL, in order to fully convey the problem i need an address to send the task too as it does involve some diagrams Regards Billy… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 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