Describe sequential file organization, Database Management System

Assignment Help:

Describe sequential file organization.  Explain the rules for

(i)  Inserting a new record.

(ii)  Deleting an existing record.       

 Ans:A sequential file consists of records organized by the order in which they were entered. The order of the records is fixed.

Records in sequential files can be written or read just sequentially.

After you placed a record into a sequential file, you cannot lengthen, shorten, or delete the record. Though, you can update (REWRITE) a record if the length does not alter. New records are added at the end of the file.

If the order in which you maintain records in a file is not significant, sequential organization is a good choice if there are many records or only a few. Sequential output is as well useful for printing reports.

(i) Inserting a new record:  Insertion poses problems if no space in which new record should go. If space, use it, if not then put new record in an overflow block.

(ii) Deleting an existing record: Deletion can be managed along with the pointer chains


Related Discussions:- Describe sequential file organization

Estimate the transaction states, Suppose an instruction takes 1 nanosecond ...

Suppose an instruction takes 1 nanosecond to execute (on average), a page fault takes 20 microseconds of processor time, and it takes 300 microseconds of disk time to read or write

What is rigorous two phase locking protocol, Differentiate strict two phase...

Differentiate strict two phase locking protocol and rigorous two phase locking protocol. In strict two phase locking protocol all exclusive mode locks taken by a transaction is

Compute natural join and outer join, For the relations R and S given below:...

For the relations R and S given below: R                      S A B C 1 4 7 2 5 8 3 6 9

Describe five main functions of a database administrator, Describe five mai...

Describe five main functions of a database administrator. Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Genera

Write short notes on domain relational calculus, Write short notes on domai...

Write short notes on domain relational calculus   The domain relational calculus uses domain variables that take on values from an attribute domain rather than values for whole

What is system r?what are its two major subsystems?, System R was develop...

System R was developed and designed over a period of 1974-79 at IBM San Jose Research Company. Its purpose was to illustrate that it is possible to create a Relational System tha

What is the use of group by clause, What is the use of group by clause? ...

What is the use of group by clause? Group by clause is used to be relevant aggregate functions to a set of tuples. The attributes given in the group by clause are used to shape

Reasons for the growing popularity of data mining, Question: Data Minin...

Question: Data Mining is the process of extracting knowledge hidden from large volumes of raw data. (a) Using a suitable example, illustrate how Data Mining can be useful t

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd