Question: 3. DATABASE DESIGN Design a relational database for a video rental store. The store, which rents only DVDs and has no sales other than DVD

3. DATABASE DESIGN Design a relational database for a video rental store. The store, which rents only DVDs and has no sales other than DVD rentals, has approximately 5,000 customers and approximately 1,200 DVD titles. There are 25 suppliers of DVDs. Business rules include: (1) each DVD title may have many copies; (2) customers use their telephone numbers to uniquely identify themselves for video rentals; (3) a telephone number may apply to anyone in the household; (4) customers may rent more than one copy of any title, but, obviously, a copy of a title can only be rented by one customer at a time; and (5) suppliers may provide many titles and a DVD may be acquired from several different suppliers. Design the necessary database tables. State the primary key for each table as well as all other necessary attributes. Make certain the tables are in third normal form. Mark the attribute you have selected as the primary key (PK) as well as the attributes that serve as foreign keys (FK)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Design a relational database for a video rental store. The store, which rents only DVDs and has no sales other than DVD rentals, has approximately 5,000 customers and approximately 1200 DVD titles....

Report Format: Your report should include: II. Executive Summary (1 page in length). The Executive Summary is a concise overview of the report. The Case Study Report should be written from the...

CASE 11 Netflix in 2012: Can It Recover from Its Strategy Missteps? Arthur A. Thompson The University of Alabama hroughout 2010 and the first six months of 2011, Netflix was on a roll. Movie...

Netflix: Will content be enough? We named our company Netflix in 1998 because we believed Internet-based movie rental represented the future, first as a means of improving service and selection, and...

Q3 - TO BE SOLVED I am unable to solve question 3 (asks for ue case description ).The questions is done using the client requirment document from 1.2 and question .Kindly solve this question with...

the traditional video rental store where customers become members, come into the video rental store to rent a video, and return the video. With his new business plan, he hopes to increase his profit...

1) What are Netflix's resources, capabilities, and core competencies in this case based on the VRIO framework? 2) Conduct a SWOT analysis based on the case. It's not Netflix that's making the...

4. Games By MailiDatabase Development MARKS) DSI has spent more than $425,000 to date researching and developing a patented database used to track orders and returns of video games from the Games by...

1. Get microsection of the thymus gland. Identify and label the following structures A. capsule B. lobule C. cortex D. medulla E. Hassall's corpuscles Thymus (LPO) Thymus (HPO)

Select a five-star hotel Ritz-Carlton Hotel New York, and write a paper in which you need to address the following: a) A brief overview of the corporation. b) Write about the Financial Outlook of...

Transaction - processing systems are used by retail stores to collect data about the transaction taking place. True False

3. Eugene Gates, Marketing Director of Mansfield Motors Manufacturers, Inc.'s Electrical Division, is leading a study to assess the relative importance of product features. An item on a survey...

1. Maintain my own perspective and my opinions

2. See things from the other persons perspective (1 is oriented towards an inner source of inspiration, while 2 is oriented towards an outer source of motivation). d. Reflection style: When I really...

2. What do the others in the network want to achieve?