Question: The Execution Results of your program will demonstrate you can use all the operations above to create/process/display (like input/processing/output) of the files (tables). Fig.1.7 for
- The Execution Results of your program will demonstrate you can use all the operations above to create/process/display (like input/processing/output) of the files (tables).
- Fig.1.7 for Customer table in a file named Customer.txt
| C_NAME | C_PHONE | C_ADDRESS | C_ZIP | A_NAME | A_PHONE | TP | AMT | REN |
| Alfred A. Ramas | 615-844-2573 | 218 Fork Rd., Babs, TN | 36123 | Leah F. Hahn | 615-882-1244 | T1 | 100 | 4/5/2018 |
| Leona K. Dunne | 713-894-1238 | Box 12A, Fox, KY | 25246 | Alex B. Alby | 713-228-1249 | T1 | 250 | 6/16/2018 |
| Kathy W. Smith | 615-894-2285 | 125 Oak Ln, Babs, TN | 36123 | Leah F. Hahn | 615-882-2144 | S2 | 150 | 1/29/2019 |
| Paul F. Olowski | 615-894-2180 | 217 Lee Ln., Babs, TN | 36123 | Leah F. Hahn | 615-882-1244 | S1 | 300 | 10/14/2018 |
| Myron Orlando | 615-222-1672 | Box 111, New, TN | 36155 | Alex B. Alby | 713-228-1249 | T1 | 100 | 12/28/2018 |
| Amy B. O'Brian | 713-442-3381 | 387 Troll Dr., Fox, KY | 25246 | John T. Okon | 615-123-5589 | T2 | 850 | 9/22/2018 |
| James G. Brown | 615-297-1228 | 21 Tye Rd., Nash, TN | 37118 | Leah F. Hahn | 615-882-1244 | S1 | 120 | 3/25/2019 |
| George Williams | 615-290-2556 | 155 Maple, Nash, TN | 37119 | John T. Okon | 615-123-5589 | S1 | 250 | 7/17/2018 |
| Anne G. Farriss | 713-382-7185 | 2119 Elm, Crew, KY | 25432 | Alex B. Alby | 713-228-1249 | T2 | 100 | 12/3/2018 |
| Olette K. Smith | 615-297-3809 | 2782 Main, Nash, TN | 37118 | John T. Okon | 615-123-5589 | S2 | 500 | 3/14/2019 |
- Fig.1.8 for Agent table in a file named Agent.txt
| A_NAME | A_PHONE | A_ADDRESS | ZIP | HIRED | YTD_PAY | YTD_FIT | YTD_FICA | YTD_SLS | DEP |
| Alex B. Alby | 713-228-1249 | 123 Toll, Nash, TN | 37119 | 11/1/2000 | 26566.24023 | 6641.560059 | 2125.300049 | 132737.75 | 3 |
| Leah F. Hahn | 615-882-1244 | 334 Main, Fox, KY | 25246 | 5/23/1986 | 32213.7793 | 8053.439941 | 2577.100098 | 138967.35 | 0 |
| John T. Okon | 615-123-5589 | 452 Elm, New, TN | 36155 | 6/15/2005 | 23198.28906 | 5799.569824 | 1855.859985 | 127093.45 | 2 |
- For purpose of simplification of the records:
Write the program in C++or Java or Python) data recording and processing in Figure 1.7 Contents of the CUSTOMER file and Figure 1.8 Contents of the AGENT file
1) In the initial version of this project, we want to simplify the records but contain ONLY (at least) information about
C_NAME, C_PHONE, A_NAME, A_PHONE, and AMT in Fig.1.7 for Customer table in a file named Customer.txt; and
A_NAME and A_PHONE in Fig.1.8 for Agent table in a file named Agent.txt
2) Replace or add CID# for each C_NAME and AID# for each A_NAME; such as #1 - #10 for all customers, which are easier than the names.
NB: Write the program in C++or Java or Python) data recording and processing in Figure 1.7 Contents of the CUSTOMER file and Figure 1.8 Contents of the AGENT file
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
