Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

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: For answer Please follow the question.

Implement (in C++or Java/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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Main Memory Database Systems

Authors: Frans Faerber, Alfons Kemper, Per-Åke Alfons

1st Edition

1680833243, 978-1680833249

More Books

Students also viewed these Databases questions