What are the purpose for having variable length records, Database Management System

Assignment Help:

What are the purpose for having variable length records? What kinds of separator characters are required for each?

Variable-Length Records - Variable-length records are those records that are of various sizes. A file may holds variable-length records in any of the subsequent situations:

• Records having variable length fields - In this case, the end-of-field symbol along with end-of-record symbol could be used as the separator characters.

• Records having repeating fields - In this case, the number of repetitions of repeating area can be used along with end-of-record symbol as the separator characters.

• Records having optional fields - In this case, the end-of-field symbol along with end-of-record symbol could be used as the separator characters.

• File containing records of various record types - In this case, a special field (or control field) can be prefixed with every record and end-of-record symbol could be used as the separator characters.

In each of the above situations either we can use end-of-record symbol or the length of every record can be prefixed at the starting of the record for the separation of the variable-length records.


Related Discussions:- What are the purpose for having variable length records

What are the different types of interfaces provided by dbms, Question 1 Su...

Question 1 Suppose the employee employee id, name, designation, salary, attendance and address of any employee has to be stored in a database. You can store these data in a sequen

The structured query language, The Structured Query Language INTRODUCT...

The Structured Query Language INTRODUCTION Database is an organised set of information about an entity having controlled redundancy and serves numerous applications. DBMS

BOGUS VS GENUINE EMPOWERMENT, what is bogus empowerment. And what is genuin...

what is bogus empowerment. And what is genuine empowerment

Explain differance between primary and secondary storage, Explain differanc...

Explain differance between Primary and secondary storage ? Primary and secondary storage Computer storage is classified within primary(main) memory and secondary(per

Generalization and specialization, design a generalization specialization h...

design a generalization specialization hierarchy for a motor vehicle sales company. the company sells motorcycles, passenger cars, vens and buses.

Database problem in wordpress, Project Description: I am having a random...

Project Description: I am having a random problem with my Wordpress site. If I click on "Publish" and "Add new", it takes me to a 404 page not found of /wp-admin/post.php (th

State the terms designing the database and normalization, State the terms D...

State the terms Designing the database and Normalization Designing the database: Out of the ERD we have formed, it is very easy to verify the tables, the attributes which the

Explain the concept of qbe, Explain the concept of QBE? Query-by-exampl...

Explain the concept of QBE? Query-by-example represents a visual/graphical approach for accessing information in a database by the use of query templates called as skeleton tab

Design and prototype, This assignment is worth 45% of your final grade for ...

This assignment is worth 45% of your final grade for this module.  Marks will be awarded as follows: Prototypes (wireframe and web based prototype) You are expected

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