O2 Assignment Data Winter, 2000 -------------------------------------------------------------------------------- Here is the data for O2 assignment. You are required to appropriately enter the data into your base according to the structure for each class specified in the assignment. PLEASE IGNORE THOSE (remaining) ^M characters!! ******************************************************************************** Table I. Person Data Name Phone_Numbers -------- ------------- Allen 626-4820 453-2207 Baden 571-6329 Carl 279-7424 Hanna 234-8929 442-8939 298-5398 Jacob 581-9844 273-1662 King 276-8943 Marks 234-1572 Roden 587-9215 262-3340 Smith 765-2530 Tom 442-3905 ******************************************************************************* Table II. Customer Portfolio Data Uninvested Fund Investment Current Name Amount($) fund-name type Amount($) Value($) -------- ---------- ----------------- ---------- -------- Baden 500 MS stock 5000 1000 FDGX bond 4500 5000 Jacob 1000 DW mm* 2000 2200 King 500 CNN stock 1000 1000 Marks 3000 MS stock 7500 1500 LU stock 1000 6500 USE mm* 5000 5300 Roden 1500 WB stock 7500 9000 Tom 1000 CNN stock 5000 5000 DW mm* 5000 5500 * note: "mm" stands for "money market fund." ******************************************************************************** Table III. Employee Wages Name Wage($) ---- ------- Hanna 2500 Jacob 2500 Roden 5000 Smith 3000 Tom 3000 ******************************************************************************** Table IV. Employee-Customers Investment Distribution Name Fund Percentage(%) ---- ---- --------- Jacob DW 20 Roden WB 10 Tom CNN 5 DW 15 ******************************************************************************** Please Note: ----------- 1. All persons in Table II, III, or IV, must also appear in Table I. 2. There are some persons who are neither customers nor employees.