Working and processing files, Database Management System

1.  Define each of the following IN YOUR OWN WORDS:

(a)   File:

(b)   Record:

(c)   Field:

(d)   Primary Key:

(e)   Secondary Key:

2.  A travel agency wants to track the prices of its various packages. Package pricing differs by season (high and low). The input record should include package code, package description, vendor number, low season cost, low season dates (beginning and ending), high season cost, high season dates (beginning and ending), package markup percentage. Design the input record.

Field

No.

Item

Description

Field Name

Field

Length

Data

Type

# of

Decimal

Places

Comments

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Posted Date: 3/12/2013 3:52:21 AM | Location : United States







Related Discussions:- Working and processing files, Assignment Help, Ask Question on Working and processing files, Get Answer, Expert's Help, Working and processing files Discussions

Write discussion on Working and processing files
Your posts are moderated
Related Questions
What is a shadow copy scheme? It is simple, but efficient, scheme known as the shadow copy schemes. It is based on making copies of the database called shadow copies that singl


What is a disjoint less constraint? Ans: It needs that an entity belongs to no much more than one level entity set.  Disjoint less constraint needs that an entity belongs to

Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

Explain the difference between the three storage types - volatile, non volatile and stable.             Ans: Volatile storage: if storage media loses data while power goes off,

Explain the two constraints, check and foreign key in SQL along with an example for each. Give the syntax. CHECK constraint - CHECK constraint specifies an expression which

What is a data dictionary? Data Dictionary is a main source of data in a data management system.  Its major function is to carry the creation and management of data definition

What is known as a search key? An attribute or set of attributes used to look up records in a file is known as a search key.

An important first step to the statistical analysis of data is to "get to know your data".  The following tasks should contribute to this. (a)   To the right of the dataset cons