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

Convert the erd into its relevant relational schema, Question: Describe...

Question: Describe briefly the three parts of the Relational Model. (a) The term integrity refers to the accuracy or correctness of the data in the database. Define the fol

What are the object-oriented approaches, What are the object-oriented appro...

What are the object-oriented approaches Software systems which are designed with structured design methodology never support some of desired quality attributes for example reus

Normalise data to third normal form, A software contract and consultancy fi...

A software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. These details comprise: Employee Numbe

What is meant by heuristic optimisation, What is meant by heuristic optimis...

What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.

MYSQL, write an SQL statement to create the database in MYSQL server

write an SQL statement to create the database in MYSQL server

Logical entity relationship diagrams, How can i turn a conceptual entity re...

How can i turn a conceptual entity relationship diagram into a logical entity relationship diagram? what do i have to do with "mandetory or" and "optional or" relationships?

What is alternate key, What is Alternate Key Alternate Key: This is t...

What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the

What are the features of embedded sql explain, What are the features of emb...

What are the features of embedded SQL? Explain. Embedded SQL - SQL could be implemented within two ways. It can be used interactively or embedded in a host language or throu

Sequences-data control, Sequences Sequences: Automatically produ...

Sequences Sequences: Automatically produce unique numbers Are sharable Are typically used to make a primary key value Replace application code Speed up t

Research in Concurency Control Protocols, Performance of Various Concurrenc...

Performance of Various Concurrency Control Mechanisms

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