Expert answer:Database technology , assignment

Expert answer:please follow the instructions carefully and use access to do the work . thanks see attach . there is two files , let me know if non of them is working
2017120304103120171202101203it310_assignment4_1.doc

Unformatted Attachment Preview

IT310 Assignment 4 SQL: DML
Queries on the Garden Glory database
Due Monday, Nov. 27th, 2017
Downlod the Garden Glory database from the Assignment 4 link. Garden Glory designs
a database with the following tables:
OWNER ( OwnerID, OwnerName, OwnerEmail, OwnerType)
PROPERTY ( PropertyID, PropertyName, Street, City, State, Zip, OwnerID)
EMPLOYEE ( EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel)
SERVICE ( PropertyID, EmployeeID, SeviceDate, HoursWorked)
The referential integrity constraints are:
OwnerID in PROPERTY must exist in OwnerID in OWNER
PropertyID in SERVICE must exist in PropertyID in PROPERTY
EmployeeID in SERVICE must exist in EmployeeID in EMPLOYEE
Write SQL statements (queries) to answer the following questions:
1. Write an SQL statement to list all columns and all rows for the table Service. Save
the query results as XXXQ1.
2. Write an SQL statement to list LastName, FirstName, and CellPhone for all
employees having an experience level of Master. Save the query results as
XXXQ2
3. Write an SQL statement to list the names of employees who have worked on a
property in New York. Use a subquery. Save the query results as XXXQ3.
4. Answer question 3 but use a join. Save the query results as XXXQ4.
5. Write an SQL statement to list the names of employees who have worked on a
property owned by a corporation. You can use either subquery or join for this
question. Save the query results as XXXQ5.
6. Write an SQL statement to show the first name and sum of hours worked for each
employee. Save the query results as XXXQ6.
7. Write an SQL statement to show the sum of hours worked for each
ExperienceLevel of EMPLOYEE. Sort the results by ExperienceLevel, in
descending order. Save the query results as XXXQ7.
8. Write an SQL statement to show the sum of HoursWorked for each type of
OWNER but exclude services of employees who have ExperienceLevel of Junior.
Save the query results as XXXQ8.
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades