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 store database

21/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:

Unique Academic Solutions
Smart Tutor
Professional Accountant
Online Assignment Help
Engineering Exam Guru
Solution Provider
Writer Writer Name Offer Chat
Unique Academic Solutions

ONLINE

Unique Academic Solutions

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

$33 Chat With Writer
Smart Tutor

ONLINE

Smart Tutor

I have read your project details. I can do this within your deadline.

$18 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

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

$46 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

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

$24 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

I have read your project details. I can do this within your deadline.

$36 Chat With Writer
Solution Provider

ONLINE

Solution Provider

Give me a chance, i will do this with my best efforts

$21 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

ESSAY - Imogene king nursing theory - Ecomap key symbols - Middle range nursing theories and evidence based practice - Healthcare Financial Management FINAL PROJECT - Tennis ireland tournament software ie - Hist Blog - 3.47 km in miles - A clean well lighted place mla citation - Apple watch series 5 target market - Search lrn of students - Discussion - Compare the population range to the mean of the sample ranges. choose the correct answer below. - Automatic room light control upon human presence - Culturally encapsulated counselors would be most likely to - Economics is best described as the - Lucy sabre rmu manual - Social work case studies foundation year 2013 pdf - Johnny can spell phonograms - Resource Assignment - Work energy theorem reviewed mastering physics - 226 arthur street fairfield - What is 10 times as much as 700 - Avarice poem yusef komunyakaa meaning - Star wars ccg players committee - Essay - How to calculate density of ozone - Mealy machine moore machine - Caterpillar accounting fraud - Nursing Theory - Plato's allegory of the cave essay - Three comparable job descriptions - Understanding china's urban pollution dynamics - Owasp secure coding practices quick reference guide 2017 - Using revenue management to set orlando magic ticket prices - Real time physics lab 2 homework answers - What do ladybugs eat besides aphids - Le lai de bisclavret marie de france - Bhp employee share scheme - The managerial grid shows how much leaders emphasize - APA Paper on Data Mining related to workplace - Acord data model download - Cites article 10 certificate - SOCW 6103 Week 3 Discussion post responses - Discussion: Team Approach to Addiction Treatment - Why was cyrus considered a fair ruler - Untdebitcard - Acid perm before and after - Credit card size in pixels photoshop - 4 methylcyclohexene lab - Virtualization - Phi 445 week 2 quiz - Informative speech topics about disney world - Dust by charles grayson questions and answers - Unsw masters geotechnical engineering - Unnatural deeds do breed unnatural troubles technique - Ucl economics entry requirements - Loose boots monica on rel - Health related informative speech topics - Ipac core competencies answers - Interview with an Entrepreneur Essay - Steps to writing a grant proposal hsm 270 - Capricorn monkey suzanne white - Assignment 3 - Keynes expressed doubts that that the economy would - What safeguards are included in patient portals and phrs - Lateral force resisting system definition - Seven areas of responsibility for health educators - You are cordially invited to attend a dinner - Francis spends $380 on candy crush - University of bath engage - Bunce fantastic mr fox - Principles of flight quiz - Synteko classic 35 review - Margin call fire sale scene - StrategicHumanResourcesManagement_Assessment3 - Thomas hill green might agree with which of the following? - Contract type - EVM - In the figure particle 1 of charge q1 - Vce biology unit 3 and 4 exam - The money demand curve has a negative slope because - Stop googling let's talk summary - City of smithville chapter 4 solutions - Show me how cengage accounting - Seismic load calculation excel as per is 1893 - Fuzz dog pedals decoded - 6 consecutive numbers add to 99 - English 2020 paper 2 - Discussion Board Questions - Homework - Fundamental concepts of organizational behavior ppt - Access to cashier secondlife com was denied - Work breakdown structure for a birthday party - Human cheek cell experiment - Jk flip flop binary counter - 10-12 pages - Carina bus depot lost property - Surveillance of Bioterrorism in Other Nations Discussion Topic - Getting to know your amp flexible super - Wire gauze science definition - Wembley lumberjack stress relief ball