Programming

Programming Questions? Ask a Programmer for Answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Programming

You are a database consultant with Ace Software, Inc. and have

Customer Question
been assigned to develop a...
You are a database consultant with Ace Software, Inc. and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database.
You sit down with Mom and Pop to discuss their business, and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent; therefore there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices to them are based on the quantity of their shipment and the past business they have done with each company.

The price of a DVD for a movie might be different than the price of a video for the same movie, even from the same distributor. Each distributor provides different types of movies (e.g., suspense, horror, mystery, comedy, etc.). A single distributor may provide several different types of movies in both video and DVD format. It is possible to obtain the same movie from multiple distributors, and at different wholesale prices.

Each video and DVD has a unique identification number that Mom and Pop assign in their inventory, in addition to the distributor's serial number for the item. Each movie also has a unique identification number Mom and Pop assign in addition to the title, and any movie IDs the distributors use in their electronic catalogs. Distributors provide electronic catalogs to Mom and Pop and the information from these catalogs must be included in the database.

Mom and Pop need to record when a video or DVD is rented, when a video or DVD is returned, and all customer charges such as late and damaged fees, failure to rewind fees, and taxes. They need a report of which videos are returned late because there are standard and late charges. On occasion there are discount prices for certain movies or types of movies. Customers want to rent movies based on actors or actresses, running length, type of movie, rating, year released, the director, and the academy awards won (by the movie, the actors, the actresses and/or the directors). Customers also want to know how many videos they have rented in the last month, year, and so forth. Mom and Pop need to keep only basic information on customers in their database, such as name, address, telephone numbers, etc.

There must be no limit to the number of video and/or DVD copies of a movie that Mom and Pop can have in their inventory. Video/DVD ID numbers, movie ID numbers, and distributor ID numbers for videos, DVDs, and movies are all different. Also, each movie must be able to have an unlimited number of actors, actresses, directors, and academy awards (i.e., Oscars). Other types of awards (e.g., Golden Globe, People's Choice, etc.) are not of interest for this application. The rental of equipment, sale of videos, DVDs, popcorn, etc., is not to be kept in the database.

Using this information, you should:
1. Determine and list your entities. Then describe fully the relationships between entities via pairs of sentences that indicate the two components of the total relationship in both directions between the entities. Relationships may be unary, binary, or ternary with respect to entities. You should not have any many-to-many relationships.
2. Begin the database logical design by identifying the entities, relationships between entities, and entities' attributes as we have done in this course. Use the same entity/relationship diagram (ERD) notation as used in class for entities, attributes, and relationships. Sketch your ERD by hand or a drawing program (e.g., Visio, PPT, SQL Modeler …) on one single 8-1/2" x 11" page (8-1/2" x 14" maximum), labeled "Mom and Pop Johnson Video Store Database E/R Diagram." Your ERD should not have any many-to-many relationships between entities. Make sure that all relationships between entities are one-to-many to facilitate the construction of relational database tables.
3. Complete the logical database design and start the physical database design by creating metadata (i.e. documentation) that describes the table(s) created from each entity and the column(s) created from each attribute in the ERD. Attributes should be self-describing. Particular attention will be given to the proper specification of all primary key (via "PK") and foreign key (via "FK") columns in the table layouts. These should match your ERD exactly. Begin these descriptions on a page labeled "Proposed Database Tables and Columns based on E/R Diagram." All tables must be 3rd Normal Form. Indicate any and all assumptions that were made.

4. Make sure your work is neat and legible.
Submitted: 5 years ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 21 minutes by:
2/12/2012
Programmer: Eljon, Consultant replied 5 years ago
Eljon
Eljon, Consultant
Category: Programming
Satisfied Customers: 595
Experience: Founder of StockCanvas.com
Verified
Hi my name isXXXXX for using JustAnswer.

When do you need this?
Ask Your Own Programming Question
Customer reply replied 5 years ago

I need it as soon as feasibly possible.

Programmer: Eljon, Consultant replied 5 years ago
OK I'll have it done by tonight.
Ask Your Own Programming Question
Customer reply replied 5 years ago

Okay...thanks so much...if I can have it tonight that would be great...as its due tonite.

So what time should I check back with you?

Programmer: Eljon, Consultant replied 5 years ago
10 PM EST
Ask Your Own Programming Question
Customer reply replied 5 years ago

Awesome thanks Eljon!!!!

And you saw the part regarding drawing an ER Diagram as well?

Programmer: Eljon, Consultant replied 5 years ago
Yes
Ask Your Own Programming Question
Customer reply replied 5 years ago
ok
Programmer: Eljon, Consultant replied 5 years ago
Ask Your Own Programming Question
Customer reply replied 5 years ago
Hi Just returned...taking a look into
Customer reply replied 5 years ago
My question dealt specifically with Videos and DVDs for Mom and Pop Video store...it didnt include info regarding a credit card or method of payment
Programmer: Eljon, Consultant replied 5 years ago
That's fine. Just tell me what you want taken out.
Ask Your Own Programming Question
Customer reply replied 5 years ago

Can you take another look at the specific parameters of the requirements below and taylor the responses to reflect the specificities...thanks in advance

 

 

 

You are a database consultant with Ace Software, Inc. and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database.

You sit down with Mom and Pop to discuss their business, and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent; therefore there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices to them are based on the quantity of their shipment and the past business they have done with each company.

 

The price of a DVD for a movie might be different than the price of a video for the same movie, even from the same distributor. Each distributor provides different types of movies (e.g., suspense, horror, mystery, comedy, etc.). A single distributor may provide several different types of movies in both video and DVD format. It is possible to obtain the same movie from multiple distributors, and at different wholesale prices.

 

Each video and DVD has a unique identification number that Mom and Pop assign in their inventory, in addition to the distributor's serial number for the item. Each movie also has a unique identification number Mom and Pop assign in addition to the title, and any movie IDs the distributors use in their electronic catalogs. Distributors provide electronic catalogs to Mom and Pop and the information from these catalogs must be included in the database.

 

Mom and Pop need to record when a video or DVD is rented, when a video or DVD is returned, and all customer charges such as late and damaged fees, failure to rewind fees, and taxes. They need a report of which videos are returned late because there are standard and late charges. On occasion there are discount prices for certain movies or types of movies. Customers want to rent movies based on actors or actresses, running length, type of movie, rating, year released, the director, and the academy awards won (by the movie, the actors, the actresses and/or the directors). Customers also want to know how many videos they have rented in the last month, year, and so forth. Mom and Pop need to keep only basic information on customers in their database, such as name, address, telephone numbers, etc.

 

There must be no limit to the number of video and/or DVD copies of a movie that Mom and Pop can have in their inventory. Video/DVD ID numbers, movie ID numbers, and distributor ID numbers for videos, DVDs, and movies are all different. Also, each movie must be able to have an unlimited number of actors, actresses, directors, and academy awards (i.e., Oscars). Other types of awards (e.g., Golden Globe, People's Choice, etc.) are not of interest for this application. The rental of equipment, sale of videos, DVDs, popcorn, etc., is not to be kept in the database.

 

Using this information, you should:

1. Determine and list your entities. Then describe fully the relationships between entities via pairs of sentences that indicate the two components of the total relationship in both directions between the entities. Relationships may be unary, binary, or ternary with respect to entities. You should not have any many-to-many relationships.

2. Begin the database logical design by identifying the entities, relationships between entities, and entities' attributes as we have done in this course. Use the same entity/relationship diagram (ERD) notation as used in class for entities, attributes, and relationships. Sketch your ERD by hand or a drawing program (e.g., Visio, PPT, SQL Modeler ...) on one single 8-1/2" x 11" page (8-1/2" x 14" maximum), labeled "Mom and Pop Johnson Video Store Database E/R Diagram." Your ERD should not have any many-to-many relationships between entities. Make sure that all relationships between entities are one-to-many to facilitate the construction of relational database tables.

3. Complete the logical database design and start the physical database design by creating metadata (i.e. documentation) that describes the table(s) created from each entity and the column(s) created from each attribute in the ERD. Attributes should be self-describing. Particular attention will be given to the proper specification of all primary key (via "PK") and foreign key (via "FK") columns in the table layouts. These should match your ERD exactly. Begin these descriptions on a page labeled "Proposed Database Tables and Columns based on E/R Diagram." All tables must be 3rd Normal Form. Indicate any and all assumptions that were made.

 

4. Make sure your work is neat and legible.

Customer reply replied 5 years ago
Good morning did you get a chance to relook at it?
Programmer: Eljon, Consultant replied 5 years ago
Please provide details on what you want me to remove since I provided a full database system to be used by the video store.

Here are the files created to meet the requirement.

1. Entity Relationship Details.docx
2. ERR.pdf
3. Table_Definitions.pdf

I think we are not on the same page at this point and I need clear direction of what changes you want as I have spent quite amount of time on this already.
Ask Your Own Programming Question
Customer reply replied 5 years ago

Well it appears that I was sent info that was not "specific" to the requirements.

 

If you read thru the requirements...alot of the required portions seem to be omitted.

 

For instance,

Entities...DVD and Videos are a part of the Movie store...not Video Games, Credit Card info etc.

Programmer: Eljon, Consultant replied 5 years ago
I will take out those parts later. I am at work and do not have the source programs that created the ERD diagrams and table/column information.
Ask Your Own Programming Question
Customer reply replied 5 years ago
Okay thanks so much!
Programmer: Eljon, Consultant replied 5 years ago
Sure thing. I'll let you know if I have any more questions.
Ask Your Own Programming Question
Customer reply replied 5 years ago

ok thanks! Question are you using Microsoft Visio or what UML software are you using?Smile

Customer reply replied 5 years ago
Please take a look at what I started and modifed....

Attachment: 2012-02-14_011311_project_1_-sample.docx

Attachment: 2012-02-14_011347_project_1_-sample.docx

Customer reply replied 5 years ago

How's it going?

 

Customer reply replied 5 years ago
Did you get the opportunity to make the revisions? Additionally I do plan on making payment upon receiving the revisions...thanks
Programmer: Eljon, Consultant replied 5 years ago
Here are the updated files. For the sake of good design I consolidated DVD and Video into Movie with Formats storing the movie type. This allows the store to support another format like BluRay discs without having to create a new entity/table.

http://www.wikisend.com/download/792408/Access_DVD2.zip
Eljon
Eljon, Consultant
Category: Programming
Satisfied Customers: 595
Experience: Founder of StockCanvas.com
Verified
Eljon and 87 other Programming Specialists are ready to help you
Ask your own question now
Customer reply replied 5 years ago
I will be at my computer in an hour...I'll open file shortly
Ask Eljon Your Own Question
Eljon
Eljon
Eljon, Consultant
Category: Programming
Satisfied Customers: 595
595 Satisfied Customers
Experience: Founder of StockCanvas.com

Eljon 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:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

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

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,109 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

789 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
Evening. I just need help in writing down a pseudo code for
I just need help in writing down a pseudo code for a self-service checkout system for a supermarket Java Scrip *Java Script … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
789 satisfied customers
I'm having trouble installing a small python package in
Hi there, I'm having trouble installing a small python package in winpython … read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
I have to set user firstname, middle name and last name in
i have to set user firstname, middle name and last name in class B and then set it eventually to the class a … read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
7,109 satisfied customers
We were running a php web application on an old xp web
We were running a php web application on an old xp web server and the motherboard died. We've upgraded the computer to Window 10, but now the php scripts don't seem to work, except for the index. … read more
Jinsmn
Jinsmn
Systems Administrator
Diplom
1,260 satisfied customers
I need to edit my bank statement numbers how to do it? i
I need to edit my bank statement numbers how to do it ? … read more
Cabletech
Cabletech
High School or GED
139 satisfied customers
I can't open an existing excel spread sheet from the file
I can't open an existing excel spread sheet from the file itself. I have to open excel first then select the file to see the data. I'm unable to do a mail merge to word by selecting the data file. I h… read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
How do I write this formula correctly in excel? Excel 2010
Hello Pearl How do I write this formula correctly in excel? … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
789 satisfied customers
I was hoping for some advice on a machine problem I have
I was hoping for some advice on a machine problem I have been working on. … read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
7,109 satisfied customers
I just uploaded a new site in Dreamweaver. My problem is
I just uploaded a new site in Dreamweaver. My problem is that it displays fine in Safari on a Mac but in IE on a PC there is a large space to the right of the agent picture and info. I've tried everyt… read more
lifesaver
lifesaver
Computer Software Engineer
Bachelor's Degree
950 satisfied customers
1. A software company sells a package that retails for $99.
1. A software company sells a package that retails for $99. Quantity discounts are given according to the following table: Quantity Discount 10-19 20% 20-49 30% 50-99 40% 100 or more 50% Design a prog… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,211 satisfied customers
I am trying to find a way to put in a birthdate and then
I am trying to find a way to put in a birthdate and then calculate when the child will turn 18 … read more
Kris R
Kris R
IT Manager
Computing
2,296 satisfied customers
I need to uninstall roblox studio. 0 now. To solve this to
to solve this to me just uninstall the program the bad image said to uninstall the program … read more
Bryan
Bryan
IT Consultant
8,745 satisfied customers
How could I make a program in raptor that user inputs a
How could I make a program in raptor that user inputs a number between 3 and 10 and I tell him what shape it is? … read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
7,109 satisfied customers
Question for LogicPro Language: Java Dukes Bookstore Upgrade
Question for LogicProLanguage: Java Dukes Bookstore Upgrade Tax and Shipping The Duke's Bookstore website is missing functionality for calculating proper tax and shipping for orders. Add the functiona… read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
7,109 satisfied customers
Syseng, *due-sunday*length-250words Look for an example in
Syseng, *due-sunday*length-250words Look for an example in every day life of the following: A one-to-one relationship A one-to-many relationship A many-to-many relationship in a newspaper For each exa… read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
I am working on an excel spreadsheet and I have several
I am working on an excel spreadsheet and I have several columns with letter grades. I need to assign a number value to each grade and then have the numbers average in a column. For instance i need A=4… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
789 satisfied customers
I have excel 2013. and I'm trying to load the solver add-in.
I have excel 2013. and I'm trying to load the solver add-in. That seems to have been successful, but I don't have and 'analysis group' in the data tab. What's the problem? Cheers, … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
789 satisfied customers
Ammmaaaazing. Excel for mac 2011, version 14.2.0. I need a
Ammmaaaazing. JA: What programs and versions are you using? Customer: excel for mac 2011, version 14.2.0 JA: What is your ideal outcome? How can we solve this for you? Customer: I need a formula writt… read more
Jason Jones
Jason Jones
AAS Information Technology
6,316 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