SQL Queries - Century Engineering Job System Database - Engineering Assignment Help

Assignment Task :

Introduction

Students must complete all the following parts of this assessment tasks:

1. SQL Queries

2. Form 

3. Report 

Century Engineering Job System database 

The database, Century Engineering Job system.accdb, contains tables the following tables:

• Customer – this table lists customers of Century Engineering, including prospective customers who have not yet requested a job

• Job – this table lists jobs that have been requested by customers.  The Customer ID indicates the customer who requested the job.  

• Employee – this table lists employees of Century Engineering.

• JobAssignment – this table lists which employees have been assigned to which job.  It also specifies how many hours to date each employee has spent on that job.

• Invoice – this table lists invoices for jobs.  One invoice is generated for each job some time after the job is marked as completed.  A job may be completed on one day but the invoice might not be generated until a few days later.  At this stage, an invoice only covers one job. Jobs that are not complete will not have an invoice.  

• Payment – this table lists payments that have been made against invoices (if any).

Part A – SQL Queries

Using your database, write SQL queries to answer all the questions in this part. Each of the following questions has an information request followed by the expected results when your database has the given sample data.

Please note: 

• Where a column has been renamed in the expected result, you must reproduce that name in your results.  For example, if JobID appears as JobNbr in the expected result, then you must make this column name appear as JobNbr in your output.

• Simple queries are preferred.  You may lose marks if your query is overly complex.

• You are not required to enforce row order on your queries unless specified.  

• Be careful of duplicates; remove duplicates if necessary.  

• You are not required to use one type of clause or construct (e.g. you are not required to use an explicit join over an implicit join) unless specifically instructed to do so in the question.  

Your SQL must continue to produce the correct answer even if the data changes.  As an example, if asked to list employees over the age of 18, your query must always list employees who are over the age of 18 at the time that the query is executed.  As time passes, the actual results would change as more employees age past 18 years.

Part B – Form

Using the Century Engineering Job System database, develop a form which can be used for data entry for jobs.  You are allowed to use any number of tables and any suitable layout for developing that form.  Name the form as “Job management”.

Part C – Report

Using Century Engineering Job System database, create a report that lists jobs and all assignments to those jobs.  A sample report for this part is shown below. Your report should 

• Include a title, date, column headings and page numbering, 

• closely resemble the sample report below; you may choose different colours/fonts, but the meaning of the report must be the same and it must be professional in appearance. 

• Have column headings/names named appropriately; for example, do NOT leave your column headings as Employee.ID or QuotedCost; this would not be professional in appearance.

This Engineering Assignment has been solved by our Engineering Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.