Professor Bieber - CIS365

Merge Exercise

Merge the following two files, where records are sorted by Product ID (the key field).

COMPUTER PRODUCTS

PRODUCT ID / PRODUCT NAME / PRICE
11111 / Flying Ducks Screen Saver / 10.00
22222 / Norton Utilities / 50.00
33333 / Mighty Mouse Action Game / 30.00

SUPPLES PRODUCTS

PRODUCT ID / PRODUCT NAME / PRICE
00055 / President Bush Pencil / 00.99
20000 / CIS Calendar / 00.25
20088 / Double Caffeine Soda / 03.00

Join Exercise

Join the following two files.

PRODUCT FILE

PRODUCT ID / COMPANY / PRODUCT NAME / PRICE
11111 / ABC Inc. / Flying Ducks Screen Saver / 10.00
22222 / XYZ Co. / Norton Utilities / 50.00
33333 / ABC Inc. / Mighty Mouse Action Game / 30.00

COMPANY FILE

COMPANY / SALES REP
ABC Inc. / Francis Dunn (215) 222-3333
RFQ Inc. / Matilda Aussie (973) 444-5555
XYZ Co. / Nan Drum (732) 666-7777