E-R model HWBasically you will be completeing several ER Models.the entire textbook, and powerpoint slides from the class. It can be however long you want, just saitisfy the questions. 4 questions in length.The questions involve a picture and the attached PDF shows the questions and models1. Chapter 6, Exercise 52. Chapter 6, Exercise 73. Chapter 6, Exercise 84. Chapter 6, Exercise 10106 Developing Windows-Based and Web-Enabled Information Systems5. The Buy relationship in the following E-R model is transformed into a relationalmodel as follows. Is there any problem with this transformation? If so, discuss theproblem(s) and make corrections.EmployeeID Name AddressPhone EmailDateOfHire EmHistory SalaryContactCustomerTicketBuyTicketNoPriceBuyDateMemberLoginName PasswordPersonOTypeCustomerID Type TicketNo BuyDateTicketTicketNo Price6. Transform the E-R model in Exercise 5 to a relational model.7. The transformation of an E-R model to a relational model is shown in the following.Is this transformation correct? If not, explain what is incorrect and why it isincorrect, and make a correction.DependentIDStudentIDStudentNameAddressStudent Has DependentDateOfBirthLogical Database Design 107StudentStudentID StudentName AddressDependentDependentID DateOfBirth StudentID8. Transform the E-R model of the movie theater database from Exercise 8 inChapter 5 to the relational model of the movie theater database.9. Transform the following E-R model to a relational model.CustomerPhone Name AddressRoomRoomNo Type Size View Smoking FloorMake ReservationAssign| | |
