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
Explain the Recoverable Schedule A recoverable schedule is one in which for each pair of transactions Ti and Tj such that Tj reads a data item formerly written by Ti, the comm

In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.

examples of fields in a database


Define- relational algebra. The relational algebra is a procedural query language. It having of a set of operations that take one or two relation as input and make a new relati

State the Steps of Object Design Object design is a very iterative process in which various classes, relationships among objects are added when you move from one level to

Consider a relation s over the attributes A and B with the following characteristics: 5,000 tuples with 10 tuples per page A 2-level B+ tree index on attribute

lock and types of lock

Use a Set operator to create a list of academics who have written or co-written less than 5 papers and also have greater than 3 interests. List their academic number in the output.

project on dbms