Can I please get help on these questions.

There are 4 problems about conversion of an ERD to a table design and ERD errors. For each conversion problem, you can use an abbreviated table design with table name, columns, and designation of the primary key and foreign keys. For each foreign key, indicate if it allows null values. You do not need to write CREATE TABLE statements or indicate data types

1. Convert the ERD shown in Figure 1 into a table design using the four basic conversion rules. Physician PhyNo PhyFirstName PhyLastName PhyEMail PhyHospital PhyCertification Nurse NurseNo NurseFirstName Nursel astName NurseEmail NurseTitle Treats Provides Patient VisitDetail --------Attends--- PatNo PatFirstName PatLastName PatCity PatState PatZip PatHealthPlan Visit VisitNo VisitDate VisitPay Method VisitCharge VisitDetailNo Contains-04 DetailCharge Usedin Item Item No Item Desc Item Type ItemPrice Figure 1: ERD for Problem 1 2. Convert the ERD shown in Figure 2 into a table design using the four basic conversion rules. Customer Custid CustFirstName CustLastName CustStreet CustCity CustState CustZip Code CustPhone CustEmail Employee Empld EmpFirst Name EmpLastName EmpPhone EmpEmail Payment InvoiceNo PayMethod PayCredit CardNo PayExpDate PayCardName PayAmount PayDesc Income of 7 Sold = MakesSae Account Acctld AcctName AcctDesc Expense of Purchases --- & Vehicle Vehld VinNo Veh Make Veh Model Veh Year Veh Mileage VehintColor Veh ExtColor VehNumCyl Veh Status Expense Expld ExpType + ExpDesc ExpAmount ExpDate ExpPaid Date -- Has Figure 2: ERD for Problem 2 3. Convert the ERD shown in Figure 3 into a table design using the four basic conversion rules. Manages Employee EmpNo EmpFirstName EmpLastName EmpPhone EmpEMail EmpDeptName EmpCommRate HO Takes Customer Order --- Product Prod No ProdName ---Contains-------- ProdQOH ProdPrice ProdNextShipDate CustNo CustFirstName CustLastName CustCity CustState CustZip CustBal -Places OrdNo OrdDate OrdName OrdCity OrdState OrdZip Qty Figure 3: ERD for Problem 3 Show 4. For the Entertainment Viewing ERD shown in Figure 4, identify and resolve errors and note incompleteness in the specifications. Your solution should include a list of errors and a revised ERD. For each error, identify the type of error (diagram or design) and the specific Showld ShowName ShowTitle ShowDuration ShowNetwork ShowNumSeasons ShowDay ShowStart Time User Userld UsrFirstName UsrLastName UsrAge Group UsrSex UsrPostalCode UsrCountry Movie Movied Mov Name Mov Duration Mov Studio Mov RelDate Mov Director Mov Subtitles Mov Genre error within each error type. Note that the ERD may have both diagram and design errors. You should use the following specifications in your analysis. Views 5 ViewedShow The Entertainment Viewing database supports entry of the viewing habits of users Actor and queries about movies, television shows, actors, and user preferences for actors. 9 ViewEvent O Showld Userld od Movield Actorld ViewDate Time ViewMethod 11 Adsin Viewed Movie Actorld ActFirstName ActLastName ActAge ActSex ActAwards For movies, the database should record the unique movie identifier, unique title, genre, list of noteworthy actors, director, format, studio, duration, date released to theaters, and list of subtitle languages. Figure 4: ERD for the Entertainment Viewing Database For shows, the database should record the unique show identifier, unique title, duration, list of noteworthy actors, network, optional scheduled time (day and start time), date of first viewing, and number of seasons of shows. For actors, the database should record the unique actor identifier, first name, last name, age, sex, and list of awards. An actor can appear in many shows and movies. . For users, the database records the unique user identifier, unique email address, first name, last name, postal code, sex, country, and age group. For viewing habits, the database should record the user, show or movie viewed, date/time viewed, and method of viewing (broadcast time or recorded). 1. Convert the ERD shown in Figure 1 into a table design using the four basic conversion rules. Physician PhyNo PhyFirstName PhyLastName PhyEMail PhyHospital PhyCertification Nurse NurseNo NurseFirstName Nursel astName NurseEmail NurseTitle Treats Provides Patient VisitDetail --------Attends--- PatNo PatFirstName PatLastName PatCity PatState PatZip PatHealthPlan Visit VisitNo VisitDate VisitPay Method VisitCharge VisitDetailNo Contains-04 DetailCharge Usedin Item Item No Item Desc Item Type ItemPrice Figure 1: ERD for Problem 1 2. Convert the ERD shown in Figure 2 into a table design using the four basic conversion rules. Customer Custid CustFirstName CustLastName CustStreet CustCity CustState CustZip Code CustPhone CustEmail Employee Empld EmpFirst Name EmpLastName EmpPhone EmpEmail Payment InvoiceNo PayMethod PayCredit CardNo PayExpDate PayCardName PayAmount PayDesc Income of 7 Sold = MakesSae Account Acctld AcctName AcctDesc Expense of Purchases --- & Vehicle Vehld VinNo Veh Make Veh Model Veh Year Veh Mileage VehintColor Veh ExtColor VehNumCyl Veh Status Expense Expld ExpType + ExpDesc ExpAmount ExpDate ExpPaid Date -- Has Figure 2: ERD for Problem 2 3. Convert the ERD shown in Figure 3 into a table design using the four basic conversion rules. Manages Employee EmpNo EmpFirstName EmpLastName EmpPhone EmpEMail EmpDeptName EmpCommRate HO Takes Customer Order --- Product Prod No ProdName ---Contains-------- ProdQOH ProdPrice ProdNextShipDate CustNo CustFirstName CustLastName CustCity CustState CustZip CustBal -Places OrdNo OrdDate OrdName OrdCity OrdState OrdZip Qty Figure 3: ERD for Problem 3 Show 4. For the Entertainment Viewing ERD shown in Figure 4, identify and resolve errors and note incompleteness in the specifications. Your solution should include a list of errors and a revised ERD. For each error, identify the type of error (diagram or design) and the specific Showld ShowName ShowTitle ShowDuration ShowNetwork ShowNumSeasons ShowDay ShowStart Time User Userld UsrFirstName UsrLastName UsrAge Group UsrSex UsrPostalCode UsrCountry Movie Movied Mov Name Mov Duration Mov Studio Mov RelDate Mov Director Mov Subtitles Mov Genre error within each error type. Note that the ERD may have both diagram and design errors. You should use the following specifications in your analysis. Views 5 ViewedShow The Entertainment Viewing database supports entry of the viewing habits of users Actor and queries about movies, television shows, actors, and user preferences for actors. 9 ViewEvent O Showld Userld od Movield Actorld ViewDate Time ViewMethod 11 Adsin Viewed Movie Actorld ActFirstName ActLastName ActAge ActSex ActAwards For movies, the database should record the unique movie identifier, unique title, genre, list of noteworthy actors, director, format, studio, duration, date released to theaters, and list of subtitle languages. Figure 4: ERD for the Entertainment Viewing Database For shows, the database should record the unique show identifier, unique title, duration, list of noteworthy actors, network, optional scheduled time (day and start time), date of first viewing, and number of seasons of shows. For actors, the database should record the unique actor identifier, first name, last name, age, sex, and list of awards. An actor can appear in many shows and movies. . For users, the database records the unique user identifier, unique email address, first name, last name, postal code, sex, country, and age group. For viewing habits, the database should record the user, show or movie viewed, date/time viewed, and method of viewing (broadcast time or recorded)