Question: Please complete these two exercises: Exercise 1 : a ) In Example 7 . 9 , how many data records result from the inner join

Please complete these two exercises:
Exercise 1:
a) In Example 7.9, how many data records result from the inner join of four tables in Example 7.9?
1)5 data records with PR1, PR2, PR3, PR4, PR5.
2)6 data records with PR1, PR2, PR3, PR4, PR5, PR6.
3)4 data records with PR1, PR2, PR3, PR4.
b) In Example 7.9, how many data records result from after selecting data records with Disease1 from the result of the inner join?
1)4 data records with PR1, PR2, PR3, PR4.
2)5 data records with PR1, PR2, PR3, PR4, PR5.
3)6 data records with PR1, PR2, PR3, PR4, PR5, PR6.
c) In Example 7.9, how many groups of data records after GroupBy MedicineName is applied?
1)3 groups with M1, M2, and M3.
2)2 groups with M1 and M3.
(Example 7.9 are the first two pictures)
Exercise 2: In Example 7.12, write an expression for the Field row and an expression for the Criteria row to select data records with the value of DateOfVisit in the current month.
1) Field Row: Month(DateOfVisit)| Criteria Row: Month(Date())
2) Field Row: Month(Date())| Criteria Row: Month(DateOfVisit)
(Example 7.12 is the last picture)
Please complete these two exercises: Exercise 1 :

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 Programming Questions!