Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Working in teams of two, create queries for a small Computer Consulting Company. The database is called Consulting.accdb The employees of the company are consultants.

image text in transcribed
Working in teams of two, create queries for a small Computer Consulting Company. The database is called "Consulting.accdb" The employees of the company are consultants. The company sells their services to a number of customers. - Each consultant has an hourly billing rate that can vary by consultant over time, which is why each work session record carries the hourly rate in effect when the work was performed. - Each work session is charged against a contract so customers can attribute costs to their internal projects. Multiple consultants could be assigned to work on the same contract. Work cannot be billed outside of a contract's start and end dates. Write the following queries: 1. List all work session records with their contract's start/end dates. a. Show the consultant's full name (lastName, firstName), date worked and the contract's start & end dates and the Company Name. Format dates as 23 Jun 2020. 2. Create a query that calculates the totalChargeBeforeTax and the totalRetailTax for each work session record. a. Show the consultant's full name, date worked (23 lun 2020), hours worked, hourly rate at the time, and your calculated totals. b. Tax hint: the work session references the contract, which references the customer. which references the province, which holds the provincial tax rate. Don't worry about the federal tax rate... we 'ill use that on an exam

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

Step: 3

blur-text-image

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

Semantics In Databases Second International Workshop Dagstuhl Castle Germany January 2001 Revised Papers Lncs 2582

Authors: Leopoldo Bertossi ,Gyula O.H. Katona ,Klaus-Dieter Schewe ,Bernhard Thalheim

2003rd Edition

3540009574, 978-3540009573

More Books

Students also viewed these Databases questions