3. Laramie Park District has files of participants in its summer and winter prog

Question

3. Laramie Park District has files of participants in its summer and winter programs

this year. Each file is in participant ID number order and contains additional fields

for first name, last name, age, and class taken (for example, Beginning Swimming).

a. Design the logic for a program that merges the files for summer and winter

programs to create a list of the first and last names of all participants for the

year in ID number order.

b. Modify the program so that if a participant has more than one record, the

participant

Explanation / Answer

We can use MySql Database for storing the information. The table that containing information can have following tuples
table swimmers {
   unique string ID;
   string first name;
   string last name;
   int age;
   string class taken;
   int period;
}

where period refering to summer or winter for a user.

Modify the program so that if a participant has more than one record, the participant

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.