Retrieve all of the records of the file logically

This preview shows page 2 - 3 out of 3 pages.

Retrieve all of the records of the file logically sequentially based on the Player Number field. 1209 Steve Marks 24 Catcher 294 1254 Roscoe Gomez 19 Pitcher 422 1536 Mark Norton 32 First Baseman 368 1953 Alan Randall 24 Pitcher 137 2753 John Harbor 22 Shortstop 294 2843 John Yancy 27 Center Fielder 137 3002 Stuart Clark 20 Catcher 422 3274 Lefty Smith 31 Third Baseman 137 3388 Kevin Taylor 25 Shortstop 294 3740 Juan Vidora 25 Catcher 368 iv. Retrieve all of the records of the file logically sequentially based on the Team Number field. 137 Eagles Orlando Smith 275 Cowboys San Jose Jones
Image of page 2

Subscribe to view the full document.

Megan Shuttlesworth - 983210898 294 Statesmen Springfield Edwards 368 Pandas El Paso Adams 422 Sharks Jackson Vega v. Perform a direct retrieval of the records with a Player Number field value of 3388. 3388 Kevin Taylor 25 Shortstop 294 vi. Perform a direct retrieval of the records with a Team Number field value of 275. 275 Cowboys San Jose Jones vii. Perform a direct retrieval of the records with an Age field value of 24. 1209 Steve Marks 24 Catcher 294 1953 Alan Randall 24 Pitcher 137 c. The value 294 appears as a team number once in the TEAM table and three times in the PLAYER table. Does this constitute data redundancy? Explain. Yes, because the same fact about the business environment is stored more than once within an information system. d. Merge the TEAM and PLAYER tables based on the common Team Number field (in a manner similar to Figure 3.8 for the General Hardware database.) Is the merged table an improvement
Image of page 3
You've reached the end of this preview.
  • Fall '17
  • The Land, Baseball positions, Lefty Smith, Kevin Taylor, Steve Marks, Alan Randall

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern