Read the on-line tutorial (an Overview of the Relational Model) and answer these questions:
** Some of these answers are not in the tutorial, but were discussed in class.

1. ASCII data, which is meant for databases, is often stored in two forms: Flat File and Free Form. Show an example of these two file formats, use at least 3 rows and 3 columns of data in your example.
 
 
 
 
 
 
 
 
 
 

2. Data stored in a Relational Database is stored in Tables. These Tables are made up of rows and columns of data.

What is another name for rows of a Table?

What is another name for Columns of a Table?

3. Answer the following questions as TRUE or FALSE: (These questions pertain to Relational Tables)

a) Values are atomic (T/F)
b) A Primary key is required (T/F)
c) Each Row is Unique (T/F)
d) The Primary Key need not be Unique (T/F)
e) The Sequence of Columns is Insignificant (T/F)
f) The Sequence of Rows is Insignificant (T/F)
g) Each Column has a Unique Name (T/F)

The following table is called "orders":

Onum	Amount	Odate	Cnum	Snum
3001	18.69	10/03/06	2028	1007
3003	721.11	10/03/06	2001	1001
3002	900.10	10/04/06	2007	1004
3004	309.95	10/04/06	2018	1002
3005	18.69	10/04/06	2028	1007

4. Which field of the "Orders Table" is the Primary key?
 
 
 

5. What is the name of the data stored in column 4 of the "Orders Table".
 
 
 

6. Why can you not ask to see the first three rows of a table?
 
 
 
 

Helps: There is always help, if you get stuck send me email or ask questions in class