Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 6. Give employee_id of employees not servicing any properties 7. Give the name of owner who employs employee whose last name is CORY. 8. Give the maximum, average and minimum working hours of each employee 9. Give name of employees who work for more than 2 properties

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DB2 11 The Database For Big Data And Analytics

Authors: Cristian Molaro, Surekha Parekh, Terry Purcell, Julian Stuhler

1st Edition

1583473858, 978-1583473856

More Books

Students also viewed these Databases questions

Question

Complexity of linear search is O ( n ) . Your answer: True False

Answered: 1 week ago