Question 1:

Submit for marking a printout of the results of joining STUDREC to CARS with:

1: INNER JOIN

2: LEFT JOIN

3: RIGHT JOIN

Ensure that you mark your papers clearly with the words "INNER JOIN", "LEFT JOIN" and "RIGHT JOIN" as appropriate.

 

Question 2:

Consider the following report (CAR PARK DETAILS). Produce a similar report (it will be based on LEFT JOIN).

Save your report as "CAR PARK DETAILS"

Please keep in mind that the aim of the exercise is to test if you can independently produce a report that is based on a query that is in turn based on a relationship.

 

 

Note: Page 2 of this report is omitted to conserve space - no students who are listed on page two own a car.

 

The Car Park Details Report

CAR PARK DETAILS

SREF INIT SNAME REGNO OID COLOUR MODEL

1

TJ OSMAN

 

     

 

   

CUA 579

1 WHITE CAVALIER
     

F 28 CWE

1 WHITE HONDA ACCORD
     

N 609

1 MERCURY CARINA
     

TJO 1

1 RED FERRARI
      TJO 2 1 GREEN RANGE ROVER

2

S LANGLEY        
      GXN 732 2 BLUE ESCORT

3

H WILSON        
      ABC 123 3 WHITE ESCORT

4

J CARTER        
     

D 111

4 RED GOLF
      H 123 4 YELLOW 2CV

5

A JONES        
      G 123 NC 5 BLACK FIESTA

6

S ISHEMO        

7

K ARNOTT        

8

B ARNOTT        

9

N GREEN        

10

H JACKSON        
      UWJ 189 10 RED MAZDA

11

A ARNOTT        

12

N HEY        

13

K WILSON        

14

J BROWN        

15

A ARNOTT        
             
             

24 August 2004

Page 1 of 3

Figure 6.23: Results of Exercise 6.2