SQL (Oracle)

MySQL

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 the name of the owner

Owner_email is the e-mail of the owner

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

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

Where

EMPLOYEE_ID is the ID of the employee

Last_name is the last name of the employee

First_name is the first name of the employee

The cellPhone is the cell number of an employee

ExperienceLevel is based on the 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 the property was serviced

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

Write SQL statements to create Mservice, Memployee, and MProperty tables ONLY.

Make sure to identify primary and foreign keys of both tables (Mproperty and Mservice)

Assume data type