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 Trigger? A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are kept in and managed by the DBMS. Triggers a


Describe relational model? Structure of relational data base Basic structure Database schema Keys Schema diagram Query languages

Write short notes on Schema diagram. A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema diagram. Every relation appears

Views in relational algebra:   1. Basic expression contains either  a) A relation in the database. b) A constant relation. 2.  General expressions are madde out of sma

What is Hierarchical DBMS In HDBMS, data is structured in a tree like manner. There is a parent-child relationship between data items and the data model is very suitable for re

External failure : A failure can also result because of an external cause, such as earthquakes, fire, floods, etc. The database must be duly backed up to avoid troubles occurring d

Record based Logical Models: Use records as the key data representation components Examples: Relational Model: It shows data as well as relationship between data in the form

What is Multivalued Attribute? Multivalued Attribute - Multivalued attribute might have more than one value for an entity. For instance, PreviousDegrees of a STUDENT.

i need to submit in this topic.