You are given a file called “std” and composed of “Number, Name, Address” fields/attributes. Write an algorithm that makes “insert, delete, update and retrieve”, processes on the records in the file. “Number” field is the key of each record.please write an ALGORITHM no code needed.you can refer to the picture to see how it should look like. Algorithm ThreeDimensionArrayApplication// this algorithm defines a three dimension array called "std" and keep the point of 5 student.Each student takes 4 courses and 3 points from each course. Here are the index will be used;"crsnum:keeps the course numbers", “stdnum:keeps the student numbers", "“exnum:keeps theexam numbers" and “points:keeps the student exam points"Steps action1.[initilization]Std[1:5,1:4,1:3] integerstdnum-02.[check student number]Crsnum-0stdnum- stdnum+1If stdnum> then goto step 63.[Check the course number]exnum-0Crsnum-crsnum+1If crsnum>4 goto step 24.[check exnum]exnum- exnum+1If exnum>3 then goto step3[read the points]Read(point)Std[stdnum.crsnum,exnum]-pointGoto step 4|

In this question we have given a file in which there are some information fields. We have to write a…

Answered: You are given a file called “std” and…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

You are given a file called “std” and composed of “Number, Name, Address”
fields/attributes. Write an algorithm that makes “insert, delete, update and retrieve”, processes on the records in the file. “Number” field is the key of each record.

please write an ALGORITHM no code needed.

you can refer to the picture to see how it should look like.

Algorithm ThreeDimensionArrayApplication
// this algorithm defines a three dimension array called "std" and keep the point of 5 student.
Each student takes 4 courses and 3 points from each course. Here are the index will be used;
"crsnum:keeps the course numbers", “stdnum:keeps the student numbers", "“exnum:keeps the
exam numbers" and “points:keeps the student exam points"
Steps action
1.
[initilization]
Std[1:5,1:4,1:3] integer
stdnum-0
2.
[check student number]
Crsnum-0
stdnum- stdnum+1
If stdnum> then goto step 6
3.
[Check the course number]
exnum-0
Crsnum-crsnum+1
If crsnum>4 goto step 2
4.
[check exnum]
exnum- exnum+1
If exnum>3 then goto step3
[read the points]
Read(point)
Std[stdnum.crsnum,exnum]-point
Goto step 4
|<Finish
5.
6.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions