TASKS 1. Using your ER Diagram from Assessment 1, build the application using Access to: (a) CREATE TABLE for every table (entity) represented on the ER Diagram 12 marks (b) Insert one record from the...

TASKS
1. Using your ER Diagram from Assessment 1, build the application using Access to:
(a) CREATE TABLE for every table (entity) represented on the ER Diagram
12 marks
(b) Insert one record from the table above into the table (entity) represented on the ER
Diagram
4 marks
2. Manipulate the data with the database you have created and perform the following
queries:
PART A
(a) Retrieve all the data in the Project table
(b) Retrieve all the data from the Job Class table
(c) Retrieve the charge hour for the Database Designer
(d) List all the employees in alphabetical order (ASC)
(e) List the charge hours that are greater than $75 per hour and the Job Classes
(f) List all the Job Classes (do not show duplicates if they exist)
3 marks
PART B
(a) List all the Job Class in the Charge Hour range of $45 and $85
(b) Find all projects with “’t” in their name
(c) Show all the employees who work on the Amber Wave Project
(d) Show which employee is a Database Designer
(e) Show which projects bill hours between 37 and 55 hours
(f) How many employees are associated with each project
(g) What is the smallest and largest individual for Charge Hour for Job Class (2 marks)
8 marks
PART C
(a) How many projects do John New and Alice Johnson work on
(b) Which Job Class is the second highest Charge Hour in the table
(c) Which Project does not utilise a Application Designer
(d) Identify the employees who are General Support and which project have they been
associated with?
8 marks