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

Industrias del recambio india pvt ltd - Understanding the business side of healthcare - Copper chloride dihydrate and aluminum - Pip short film theme - Dulux kitchen paint problems - Middleboro casebook case 1 - Week 3 Project - The virtual body medtropolis - What does rtn mean penn foster - Reading summary - Angle of repose coal stockpile - Самая высокая точка польши - Sampling distribution of the mean worksheet with answers - Southwest airlines stanford case study solution - Pleasures of eating wendell berry - What lie did captain beatty tell montag - What are the four qualities of leadership that engender trust according to bennis and goldsmith? - Intervention specialist interview questions - Philosophy of special education essay - Why do organizations still have information deficiency problems - Bamboo reinforced concrete ppt - History extended essay structure - Learning intention and success criteria examples - Healthcare reimbursement - Calculating iv infusion time - Curtail me thrice i am a youth - Education planner learning style quiz - The pendulum consists of a uniform disk with radius - Weight Loss Program Evaluation Report - Military flexible deterrent options fdos - Peter lehmann princess moscato - Stitch fix commercial molly actress - Lab report example engineering - What counseling theory am i - What is the name of this compound - Week 6 Discussion 1 Physiology and Pathophysiology - Vertical analysis of balance sheet and income statement - Answer questions about arrays, functions, html, css and java. - A certain light bulb has a tungsten filament - Wbs of hospital management system - Brooke dalzell podiatry tamworth - What can you do to encourage collaboration and demonstrate stewardship - Literary devices much ado about nothing - The great hymn to the aten sparknotes - Duncan v louisiana case brief - Coca cola campaign case study - Naoh + caco3 reaction - Ni usb 6212 driver download - All around my hat ukulele chords - Flexibility matrix method for beams - Behold the dreamers discussion questions - Satya nadella at microsoft instilling a growth mindset - What is divisor and dividend and quotient - Marketing communication/ branding - Big fat liar movie - Write 2 - Aiu london student portal - Dmin project proposal sample - Marketing Management - Ernst mayr main findings - Nike supply and demand curve - Determine the height d of cable ab - Leeds trinity university evision - Bush house vets llandeilo - ¿qué dio origen al "lenguaje chat"? - Bsbitu102 - Topic 6 insolation and the seasons answers - Describe perplexity and wonderment as ways to god - Adventures of an it leader summary - Sentence starters for essay - America's bitter pill cliff notes - Harmonics harbor scraped oak stair nose - Describe one characteristic of a disaster recovery team member. - Article - Theory practice gap in nursing example - Economics - The vermont teddy bear company sells handmade teddy bears - Broadening and deepening security - 67 falie drive north haven - Www hoselink com au - Camshaft position sensor wiring diagram - How to calculate total torque - Discussion Question - Signature Assignment: United States’ Founding Influences - Journal - This is our story ashley elston read online - Coal seam gas gippsland - Dog registration moreton bay - The servant who buried his talent - The menstrual cycle depends on events within the female ovary - Dnr garmin windows 10 - Advanced pathophysiology practice questions - Center of pressure fluid mechanics lab report - Advantra z citrus aurantium - Needs assessment social work - Derive linear density expressions for - Donner company case study solution - Leadership essay - Essay Writing - Bsbdiv501a assessment