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

Ask an Expert

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

Write your message here..

Related Questions

Explain trigger, What is Trigger? A trigger is a SQL procedure that ini... 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

What is a transaction? and how does it differs from update, wh wh

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

Write short notes on schema diagram, Write short notes on Schema diagram. ... 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

Define views in relational algebra, Views in relational algebra:   1. B... 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, What is Hierarchical DBMS In HDBMS, data is ... 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-database recovery and security, External failure : A failu... 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, Record based Logical Models: Use records as th... 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, What is Multivalued Attribute? Multival... What is Multivalued Attribute? Multivalued Attribute - Multivalued attribute might have more than one value for an entity. For instance, PreviousDegrees of a STUDENT.

Client dbms, i need to submit in this topic. i need to submit in this topic.