Chapter 5. Exercise 3

Open the AA Enterprises CUSTOMERS table and type in the following records

Customer 1001Customer 1002JD WholesalersSutton Suppliers1 Loop Street2 Buitenkant StreetCape TownCape Town80018001Tel: 021 408 9999Tel: 407 8888Fax: 021 408 9998Fax: 407 8887Customer 1003Customer 1004Price StoresWinwise Solutions4 Durham Ave6 Smith StreetSalt RiverPort Elizabeth80014001Tel: 021 447 3456Tel: 041 666 8979Fax: 021 447 3458Fax: 041 666 8990Customer 1005Customer 1006Ajay StoresMichaelis2 Main Road44 West StreetEast LondonGauteng50022001Tel: 051 345 8976Tel: 011 345 1236Fax: 051 345 8990Fax: 011 345 8796Customer 1007Customer 1008JD WholesalersPrice Stores25 Old Kent Road23 Vereeniging StreetGautengPretoria20010001Tel: 011 453 6678Tel: 012 897 4536Fax: 011 453 6699Fax: 012 897 3453Customer 1009Customer 1010Tweedie WholesalersBusiness Stores55 King Street43 Short StreetCape TownPretoria80000012Tel: 021 564 8790Tel: 012 234 8976Fax: 021 564 8976Fax: 012 234 8796Customer 1011Customer 1012SevenoaksSharpes22 Link Road54 2nd AvePort ElizabethEast London40015001Tel: 041 789 6543Tel: 051 456 2349Fax: 041 789 1234Fax: 051 456 2341

Save the table

Open the ORDERS table and type in the following records

121001100115 April 200515 April 2005243.65435.89341005100623 April 200523 April 2005222.50988.30561002100323 April 200523 April 2005345.5555.6781002100525 April 200525 April 2005444.3350.59101026 April 2005450.3

Save the table and close the database