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)

do not show me an answer already in the app because I already seen them they are not answered as that example shows

the answer should be As for the following example

(

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

this is only an EX

now the Q2 is

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)