Question: Training session signed for is the same as Course ID in COURSE table Following sample data is available: COURSE Sample data Course ID Price ($)

Training session signed for is the same as Course ID in COURSE table

Following sample data is available:

COURSE Sample data

Course ID	Price ($)	Instructor Name	Instructor Address
S111	2850	Harry	UB
S121	3200	Polly	UB
S155	1200	Smith	Loyola
H111	500	Morton	JHU
H123	2200	David	JHU
H125	1200	Polly	UB
H221	800	Lionel	UB
H225	1450	Lionel	UB

TRAINEE sample data

Trainee ID	CourseID	Trainee Name	Date of training
A101	H111	Sam Paper	10/02/2016
A101	H123	Sam paper	10/03/2016
A110	S111	Mary Poppins	11/01/2016
B112	S111	Alex Johnson	11/01/2016
B112	S121	Alex Johnson	11/02/2016
B112	S155	Alex Johnson	11/06/2016
B222	H123	John Watt	10/03/2016
B222	H111	John Watt	10/01/2016
B222	S111	John Watt	11/06/2016
B222	S121	John Watt	11/02/2016
B222	S155	John Watt	10/05/2016
C111	H123	Jong Chu	10/03/2016
C111	H111	Jong Chu	10/02/2016
F456	S111	Jerry Long	11/08/2016
F555	S111	Willy Polk	11/08/2016
F555	S155	Willy Polk	11/06/2016
F555	H111	Willy Polk	02/11/2016
X123	H123	Shirley Dent	10/03/2016
X123	S111	Shirley Dent	11/06/2016
X123	H125	Shirley dent	02/11/2016
X123	H225	Shirley dent	10/02/2016

PART B:

Develop the following queries in ACCESS and run (execute) them Q 1-13

List the Course IDs and their price.

Give the names of students taking course H111.

Give the ID of classes offered on November 1, 2016 (11/1/2016)

How many courses each student is taking?

Give the training sessions and their dates (make sure there is no repetition of session and corresponding date).

How many classes Shirley Dent is taking?

How many courses are offered at UB campus?

Give the number of classes taught by each instructor

Give the total amount paid by Alex Johnson

How many classes Instructor Polly is teaching?

Give the total revenue generated by course H123. Hint: count number of times H123 repeats in trainee table; adds price for those occurrences for course H123 from course table. Ex:

If 5 students take course S145 and price is 1200 each, the their revenue will be 1200*5 = 6000 (or 1200 added 5 times)

Give the total number of students taking classes in November. Hint: use between to get November count, i.e., between date 1 AND date 2

Give the total salary of each instructor.

Ex: If an instructor taught 5 students in course H221 and 2 students in H111, then their salary would be

5*800(price of H221)+2*500(price of H111)= $5000

Enrollment Report for TrainingrUs.com

Date Number of students taking classes

10/02/2016 --

etc

Total number taking on 10/02/2016 __________________

10/3/2016 ---

---

Total number taking on 10/03/2016 _________________________________

etc..

Overall Total Number of Students: xxxx

Create an Enrollment report of Dates and Overall total number of students taking classes on those dates, i.e., 10/02/2016; 10/03/2016. see the template below:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Training session signed for is the same as Course ID in COURSE table Following sample data is available: COURSE Sample data Course ID Price ($) Instructor Name Instructor Address S111 2850 Harry UB...

Following sample data is available: COURSE Sample data Course ID Price ($) Instructor Name Instructor Address S111 2850 Harry UB S121 3200 Polly UB S155 1200 Smith Loyola H111 500 Morton JHU H123...

Experiment 3 Acceleration Due To Gravity Questions How do you compute an object's velocity from its position? How do you measure the acceleration of a mass as it falls under the influence of gravity?...

Use the data in table below to answer Questions 5-8. Date Weld Defects Date Weld Defects 12-May-20 19 22-May-20 13 13-May-20 12 23-May-20 3 14-May-20 10 24-May-20 18 15-May-20 19 25-May-20 7...

Q1: Identify Classes and design UML Class diagram for the following case studies. a) A medical institution wishes to computerize its patient records system. They have asked you to create a...

I need some help with both Case 1 and Case 2 of this assignment. See attached document for full assignment. Here is an excerpt from each. Case 1: Purchase Point Media Corporation (PPMC) Media...

Can u solve question 2 the first question has already been answered here i only need solution for question 2 training cost management. thank you 1. Hotel W C Medical the de relating de Analysis...

CERTIFICATE IV IN FINANCE AND MORTGAGE BROKING - FN540820 Page 1 UNIT 3 - COMPLY WITH FINANCIAL SERVICES REGULATION AND INDUSTRY CODES OF PRACTICE Unit Code: FNSFMK515 This unit describes the skills...

School of Computing and Information Technology Session: Spring 2023 University of Wollongong Lecturer: Janusz R. Getta ISIT912 Big Data Management Assignment 2 Published on 21 August 2023 Scope The...

A random sample of 100 consumers is selected to help determine consumer preferences for two proposed new soft drink flavors. Results from the sample appear below: Use a chi square test of...

Consider a. system of 3 non-interacting particles that are confined to move in a 1-dim infinite pot well of length a " defined as V(x) = { 0 , ocka otherwise 4 Determine the energy & Wifeee" of the...

When seeking information about fixed assets, payroll, regulatory and tax reporting, and accounts payable, an administrator will access what information management system? a . Physician practice...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

1. Development roles: Managers, mentors, development staff, and other roles in the development process.

2. How can competencies be used in employee development?

3. Collaborative Learning: The learner can connect via the company intranet with tutors, team members, customers, or other learners to discuss problems, issues, and approaches and to share what has...