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

Determine the benefits of object oriented design, Determine the benefits of...

Determine the benefits of Object oriented design OOD also gives reusability, which saves time, costs and productivity gains through direct mapping to properties of Object-Orie

For known, What are the function of DBA?

What are the function of DBA?

Explain the utilities which help the dba to manage database, Explain the ut...

Explain the utilities which help the DBA to manage the database? Every DBA uses database utilities to maintain and control their databases. But there is a lot of confusion wit

Explain domain calculus, Explain Domain calculus Domain calculus is one...

Explain Domain calculus Domain calculus is one of the types of the relational calculus. The formal specification of the domain calculus was planned after the development of the

Create table employee and enter employee data in sql, Create table employee...

Create table employee and enter employee data in SQL? Consider the following relational schemas: EMPLOYEE (EMPLOYEE_NAME, STREET, CITY) WORKS (EMPLOYEE_NAME, COMPANYNAME, SAL

What is data defination language, What is DDL? Make a list of commands with...

What is DDL? Make a list of commands with short description used in DDL Ans: Data Definition Language that is abbreviated as DDL is a computer language for defining data struct

Explain the steps for reduction of e-r model, Explain the steps for reducti...

Explain the steps for reduction of E-R model into relational model. Ans:(a) Entity set in E-R model will be considered as table name in relational Model. (b) Attributes of e

Partial relation emp-get the details people with min salary, Let consider t...

Let consider the given partial relation EMP. Let us make some sub-queries for them EMPNO ENAME JOB SAL DEPTNO 7566

Keys - relational database integrity, Candidate Key:  In a relation R, a ca...

Candidate Key:  In a relation R, a candidate key for R is a subset of the set of attributes of R, which have the differnt two properties: (1)        Uniqueness:                N

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