Need help for database quesiton

Consider the following partial EERD. Each entity, but not a subtype, has two attributes: XXXID, where xxx stands for the entity name in which the attribute appears - it is unique . tp, which is a regular attribute. Translate the EERD into a set of DB tables such that for each one you state its attributes and for each one also if it is a part of the primary and/or foreign key and whether it is unique or not NULL. Notes: MNGR is a subtype of EMP and has an additional attribute called bonus. PILOT is a subtype of EMP and has an additional attribute called licenceNo. The relationship between DEP and EMP has attributes startDate and percentSalary. EERD DIV Div has Mngr HO MNGR PILOT DEP EMP -ot CAR supervises Consider the following partial EERD. Each entity, but not a subtype, has two attributes: XXXID, where xxx stands for the entity name in which the attribute appears - it is unique . tp, which is a regular attribute. Translate the EERD into a set of DB tables such that for each one you state its attributes and for each one also if it is a part of the primary and/or foreign key and whether it is unique or not NULL. Notes: MNGR is a subtype of EMP and has an additional attribute called bonus. PILOT is a subtype of EMP and has an additional attribute called licenceNo. The relationship between DEP and EMP has attributes startDate and percentSalary. EERD DIV Div has Mngr HO MNGR PILOT DEP EMP -ot CAR supervises