Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 13, Problem 1PE
Program Plan Intro
Figure 13.3:
record 0 | 10101 | Srinivasan | Comp.Sci | 65000 |
record 1 | 12121 | Wu | Finance | 90000 |
record 2 | 15151 | Mozart | Music | 40000 |
record 3 | 98345 | Kim | Elec.Eng | 80000 |
record 4 | 32343 | El Said | History | 60000 |
record 5 | 33456 | Gold | Physics | 87000 |
record 6 | 45565 | Katz | Comp.Sci | 75000 |
record 7 | 58583 | Califieri | History | 62000 |
record 8 | 76543 | Singh | Finance | 80000 |
record 9 | 76766 | Crick | Biology | 72000 |
record 10 | 83821 | Brandt | Comp.Sci | 92000 |
Expert Solution
Explanation of Solution
a.
Result of the action:
- If record 6 is moved to the place of record 5, an empty space is created at the record 6.
- The record 5 is completely discarded from the structure.
- Again record 7 is moved to the space of record 6. So the information in the record 7 is placed at record 6.
- The structure of file after the action is given below,
record 0 | 10101 | Srinivasan | Comp.Sci | 65000 |
record 1 | 12121 | Wu | Finance | 90000 |
record 2 | 15151 | Mozart | Music | 40000 |
record 3 | 98345 | Kim | Elec.Eng | 80000 |
record 4 | 32343 | El Said | History | 60000 |
record 5 | 45565 | Katz | Comp.Sci | 75000 |
record 6 | 58583 | Califieri | History | 62000 |
record 7 | ||||
record 8 | 76543 | Singh | Finance | 80000 |
record 9 | 76766 | Crick | Biology | 72000 |
record 10 | 83821 | Brandt | Comp.Sci | 92000 |
Explanation of Solution
b.
Result of the action:
- If record 7 is moved to the place of record 5, an empty space is created at the record 7.
- The record 5 is completely discarded from the structure.
- The structure of file after the action is given below,
record 0 | 10101 | Srinivasan | Comp.Sci | 65000 |
record 1 | 12121 | Wu | Finance | 90000 |
record 2 | 15151 | Mozart | Music | 40000 |
record 3 | 98345 | Kim | Elec.Eng | 80000 |
record 4 | 32343 | El Said | History | 60000 |
record 5 | 58583 | Califieri | History | 62000 |
record 6 | 45565 | Katz | Comp.Sci | 75000 |
record 7 | ||||
record 8 | 76543 | Singh | Finance | 80000 |
record 9 | 76766 | Crick | Biology | 72000 |
record 10 | 83821 | Brandt | Comp.Sci | 92000 |
Explanation of Solution
c.
Result of the action:
- The record 5 is completely discarded from the structure.
- The structure of file after the action is given below,
record 0 | 10101 | Srinivasan | Comp.Sci | 65000 |
record 1 | 12121 | Wu | Finance | 90000 |
record 2 | 15151 | Mozart | Music | 40000 |
record 3 | 98345 | Kim | Elec.Eng | 80000 |
record 4 | 32343 | El Said | History | 60000 |
record 5 | ||||
record 6 | 45565 | Katz | Comp.Sci | 75000 |
record 7 | 58583 | Califieri | History | 62000 |
record 8 | 76543 | Singh | Finance | 80000 |
record 9 | 76766 | Crick | Biology | 72000 |
record 10 | 83821 | Brandt | Comp.Sci | 92000 |
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education