Question: PROBLEM 1. [100 POINTS] Consider the following ERD about the database requirements of Great Plains Video Club where MMonth, MY ear represent the month, year
![PROBLEM 1. [100 POINTS] Consider the following ERD about the database](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f30ee97d35b_09666f30ee8edd02.jpg)
PROBLEM 1. [100 POINTS] Consider the following ERD about the database requirements of Great Plains Video Club where MMonth, MY ear represent the month, year of membership. Member Name O,M MMonth MYear rents Supplier O.M O.M Address Video Tape/DVDD 1M Copy SACopyof ID Movie Catalog Tdle Rating A) ?na WORD document, give Step 1 tables in the conversion of the ERD into equivalent relat ional tables (schema). Make sure to underline the primary key column(s). B) Give Step 2 tables in the conversion ofthe ERD into equivalent relational tables (schema) Make sure to include implicit attributes of the relationships. Make sure to underline the primary key column(s). C) Identify the tables that can be combined if any. Which tables can be eliminated? What would the combined tables look like? D) Give the FINAL Relational Schema (i.e., relational tables)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
