MPROPERTY (Property_ID, Owner_ID, Owner_Name, Owner_email, Owner_type)

Where

Property_ID is the id of property owned by an owner (assume one property can be owned by one owner only)

Owner_ID is the ID of Owner

Owner_name is name of the owner

Owner_email is the e-mail of the owner

Owner_type is type of owner (individual, corporate or Partnership)

MEMPLOYEE (Employee_ID, Last_name, First_Name, CellPhone, ExperienceLevel)

Where

EMPLOYEE_ID is the ID of employee

Last_name is last name of the employee

First_name is the first name of employee

CellPhone is cell number of employee

ExperienceLevel is based on number of years of experience and is classified as Master, Junior or Senior

MSERVICE (Property_ID, Employee_ID, Service_Date, Hours_worked)

Where

Service_date is the date that property was serviced

Hours_worked is the number of hours that employee worked on that project

Write following queries in SQL for q1-q15

11. Give total hours worked by employee Cory (last name)

12. Danny, manager, wants to see the impact of 12% salary increase. Increase all workers salary by 12%

13. Give the Ids of employees with experience level of senior that are servicing properties

Q 13. Employee Darwin (employee id E19) has been assigned to property P10 on December 15, 2020. Add his assignment (just give SQL for this)