NEED ANSWER ASAP

QUESTION 2 (10 marks) Consider the conceptual schema given below. CUSTOMER phone 10 BRANCH YOU D2 Die non OWNER SELLER POTENTIAL BUYER ty HEAL ESTATE PROPERTY Number of real estate property EMPLOYEE fire charged 1 PROPERTY OFF MARKET PROPERTY ON MARKET ADMIN AGENT bussen JUNOR-AGENT TRAINING COURSE designer cedido Scope - e 1 SENOR AGENT promotionale Your task is to perform the steps of logical database design, i.e. to transform a conceptual schema given above into a collection of relational schemas. Before transforming add the attributes 'date-built and builder' to the REAL_ESTATE-PROPERTY class. Add training provider to the TRAINING-COURSE class. Draw the resulting conceptual schema adding your name, student number and the date to the drawing. Use UMLet and paste images of your drawings into your Microsoft Word document using the template provided. List the names of attributes, primary key, candidate keys (if any), and foreign keys (if any) for each class in the relational schema. Assume that an association method is used to implement the generalization. Show your working and explain as you step through the transformation process. Convert your Microsoft Word document based on the template provided into a pdf and submit your answer as a file question2.pdf CUSTOMER phone ID first name lastame BRANCH name 101 cly 2 Street 102 bid# 102 offco 102 phone fas employee OWNER-SELLER POTENTIAL BUYER 104 1 Employes 101 REALESTATE PROPERTY number of real estate property ID city street Bildg Rat..11 Currentius when status changed. owns EMPLOYEE Erst name come date of birth employment-date Bay PROPERTY OFP-MARKET PROPERTY-ON MARKET Assigned to ADMIN AGENT business-phone ID dow-when-isted price asked Participates in TRAINING COURSE dosigner-selected D datered date completed objectives 1.1 JUNIOR AGENT SENIOR AGENT promotion-date QUESTION 2 (10 marks) Consider the conceptual schema given below. CUSTOMER phone 10 BRANCH YOU D2 Die non OWNER SELLER POTENTIAL BUYER ty HEAL ESTATE PROPERTY Number of real estate property EMPLOYEE fire charged 1 PROPERTY OFF MARKET PROPERTY ON MARKET ADMIN AGENT bussen JUNOR-AGENT TRAINING COURSE designer cedido Scope - e 1 SENOR AGENT promotionale Your task is to perform the steps of logical database design, i.e. to transform a conceptual schema given above into a collection of relational schemas. Before transforming add the attributes 'date-built and builder' to the REAL_ESTATE-PROPERTY class. Add training provider to the TRAINING-COURSE class. Draw the resulting conceptual schema adding your name, student number and the date to the drawing. Use UMLet and paste images of your drawings into your Microsoft Word document using the template provided. List the names of attributes, primary key, candidate keys (if any), and foreign keys (if any) for each class in the relational schema. Assume that an association method is used to implement the generalization. Show your working and explain as you step through the transformation process. Convert your Microsoft Word document based on the template provided into a pdf and submit your answer as a file question2.pdf CUSTOMER phone ID first name lastame BRANCH name 101 cly 2 Street 102 bid# 102 offco 102 phone fas employee OWNER-SELLER POTENTIAL BUYER 104 1 Employes 101 REALESTATE PROPERTY number of real estate property ID city street Bildg Rat..11 Currentius when status changed. owns EMPLOYEE Erst name come date of birth employment-date Bay PROPERTY OFP-MARKET PROPERTY-ON MARKET Assigned to ADMIN AGENT business-phone ID dow-when-isted price asked Participates in TRAINING COURSE dosigner-selected D datered date completed objectives 1.1 JUNIOR AGENT SENIOR AGENT promotion-date