Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Video database program

23/04/2021 Client: muhammad11 Deadline: 2 Day

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.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Essay Writing Help
Homework Tutor
Homework Master
Solutions Store
Study Master
Innovative Writer
Writer Writer Name Offer Chat
Essay Writing Help

ONLINE

Essay Writing Help

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$17 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$18 Chat With Writer
Homework Master

ONLINE

Homework Master

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$40 Chat With Writer
Solutions Store

ONLINE

Solutions Store

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$37 Chat With Writer
Study Master

ONLINE

Study Master

I will cover all the points which you have mentioned in your project details.

$37 Chat With Writer
Innovative Writer

ONLINE

Innovative Writer

I will cover all the points which you have mentioned in your project details.

$20 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Professor carol pollock bio - Internet Research - Wk 11 - Bulk micromachining in mems fabrication process - Preparation of methyl salicylate lab report - What does the dagger symbolise in macbeth - Essay- Need done in 12 hours or less - Marketing mix of horlicks - Is predation a biotic factor - East of eden setting - Am i blue by beth henley summary - Week 8 - Sociology powerpoint outline - Zoneff v the queen - Mcq on human values and professional ethics - Teacher aide requirements qld - MBA - Main - Dis 5 - Dassault systemes financial calendar - Burrito bandito gift card balance - Marriage out of community of property in namibia - Malware Techniques - What is ecomap in social work - Executive Practical Connection Assignment - Heart of darkness themes and symbols - Fundamentals of Nursing - Quantitative Methods - 2 pages and 1 page - Snap on solus ultra - Annotated bibliography $15 - Reaction of metals and acids - My choice children's homes ltd - Samsung 64 inch plasma tv price - Welch allyn eye examiner - Westpac future leader scholarship - Toothpaste and toothbrushes are substitute goods. - Clinical robotic surgery association - Structural deficiency in organizations - Capstone Project Change Proposal Presentation (TOPIC FALL PREVENTION STRATERGIES IN HOSPITALS). - Ol 125 personal development plan swot analysis milestone two - City of thieves map - Bombs away video games corporation - David james and partners - Property Crime and Typologies Performance Task - Marketers don t create needs needs preexist marketers - Research paper - Loreto grammar school staff list - Answer questions use the resources I gave - Ap calculus bc 2015 - Essay - Eldredge boundary shiraz 2017 - Difference between microeconomics and macroeconomics in table - Occupational psychology stage 2 - Business Ethic Questions 100 words needed each - Aloe - Barbara ehrenreich serving in florida questions - How corries are formed - Fired heaters in refineries - Health and physical assessment reviews and rationales - The danger of a single story analysis essay - Asap fresh al tweet mp3 download - How long to fill pool with hose - Dental hygiene bags - Algebra - Gen 201 week 2 homework answer key - Biology lab variation in cell structure - Is your study score already scaled - Aac participation model explained - Size of a1 in cm - Sponge plowed guitar lesson - Advantages and disadvantages of an endoskeleton - Assignment: Performance Appraisal Applications and Implementation (5pages) - The most important person in my life essay father - What does sic mean in grammar - Lección 7 grammar quiz - Vocabulary in context exercises - Jobvite social recruiting survey 2015 - Michael young institute of education - Case-3 - Bosnian grill food truck san diego - What is the competitive advantage of smoothie king - Trophic cascade and keystone species worksheet answers - I need 1500 words on Research competitive company websites and social media to see what type of postings are done - Singapore airlines customer service innovation case study analysis - Ml w164 rear sam - Uber Strategies and Challenges globally and in China - Diversity factor in electrical - Circulant matrix matlab - Aisi 1018 material properties - Dna fingerprinting lesson plan - S 3 methyl 2 butanol - Dau ask a professor - Aftercare advice for facial electrical treatments - Chaos theory management ppt - 8/2 - The two major problems that transcription solves for the cell are - Blackmores conceive well gold woolworths - CLA2 - CLO 1, CLO 2, CLO 3, CLO 4, CLO 5 - Life perpetuates itself at the cellular level - Aldinga recycling lacey drive - John donne no man is an island poem analysis - Jazz often follows aba form