Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

100

VIEWS: 4 PAGES: 6

									                                                   Exercise

Manual Joins

Here are two sets of data presented in the following tables.

Fruit Master List    (A)

 Product         Description        Unit Cost
   Code


  AP2010              Apple           3.60


  BA2010             Banana           2.50


  MA2010             Mango            12.50


  RA2010            Raspberry         2.00


  OR2010             Orange           4.00


  ST2010          Strawberry          2.00


  GR2010             Grape            15.00


  LE2010             Lemon            6.00


  LI2010              Lime            6.00


  PI2010            Pineapple         4.00


  CH2010             Cherry           7.50
Fruit Transaction List    (B)

 Product                             Customer   Period
   Code     Quantity     Amount       Code      Code


  AP2010      200        £720.00       102             1


  AP2010      400        £1,440.00     104             1


 MA2010       100        £1,250.00     103             1


 BA2010        50        £125.00       100             1


 RA2010       300        £600.00       103             1


  AP2010      150        £540.00       104             1


  ST2010      225        £450.00       105             1


 MA2010       600        £7,500.00     104             1


 OR2010        25        £100.00       102             1


  LE2010      125        £750.00       104             1


 MA2010       100        £1,250.00     103             1


 MA2010       500        £6,250.00     105             1


  PI2010      300        £1,200.00     105             1


  AP2010      325        £1,170.00     104             1


 RA2010       475        £950.00       100             1


 CH2010       125        £937.50       105             1


 BA2010       375        £937.50       102             1


  ST2010      200        £400.00       105             1


  ST2010      600        £1,200.00     102             1
     A series of joins have been carried out, using the product
     code as the key, and the results are shown on the next
     page. Using the instructions below, enter your answers in
     the boxes beneath each result.

     Instructions

1.   Identify the type of join using one of the following codes.



     1    Matches only

     2    All records in primary file

     3    Records with no secondary match

     4    All records in both files

     5    Records with no primary match




2.   Identify the primary and secondary files using one of the
     following codes.



     A    Fruit Master List

     B    Fruit Transaction Llist




3.   Can you explain the logic behind each result?
Join 1




Join type   Primary File   Secondary File




Join 2




Join type   Primary File   Secondary File




Join 3




Join type   Primary File   Secondary File
Join 4




Join type   Primary File   Secondary File


Join 5




Join type   Primary File   Secondary File


Join 6




Join type   Primary File   Secondary File

								
To top