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
Section A:  Use the following tables to create a database called College.  Use SQL commands. Student stuid(primary) lastName firstName

Question: AirwaysCentre, an international airline booking company currently uses a relational database system for their operations, which includes the following relations: P

SELECT Statement This statement is used for retrieving information from the databases. It can be coupled with many clauses. Let us talk about these clauses in more detail:

waht is a repeating group?

List the Armstrong's axioms for functional dependencies.  What do you understand by soundness and completeness of these axioms?      Ans: The Armstrong's axioms are: F1:

File Organisation And Its Types  Just as arrays, trees, lists and other data structures are used to execute data Organisation in main memory, a number of planning's are used to

Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

FDs in Relationships:  Enrols Relationship: None as it is many to many Teaches Relationship : Course code → Instructor Instructor → Course code The next question is:

Define Query by Example QBE is a query language relies upon domain calculus and has two dimensional syntax. The queries are written in the horizontal and vertical dimensions of