database course

please solve question number 2

( there is a solved question as an example )(I want you to solve the question number 2 as shown in the example)

2. Use the reduction to relational schemas techniques you learned in chapters 12 and 13 to translate the following EER diagram to a collection of relational schemas. (5 points) Staff(staffNo, name,position, salary, branchNo) branchNo inserted to represent the one-to-many relationship Has Manager(staffNo, mgrStartDate, bonus, branchNo) branchNo inserted to represent the one-to-one relationship Manages. Because Branch \& Manager have both total participation, an alternative would be to include staffNo (PK for Manager) as a foreign key in Branch as follows: Branch(branchNo, street, city,postcode,mgrNo) where mgrNo is a foreign key that corresponds to staffNo in Staff SalesPersonnel(staffNo, salesArea, carAllowance) Secretary(staffNo,typingSpeed) FullTimePermanent(staffNo, salaryScale, holidayAllowance) PartTimeTemporary(staffNo, hourlyRate) Branch(branchNo, street, city,postcode) Assuming that we did not use the alternative solution mentioned above