1. Define file organisation for:

• sequential files
• random files
• indexed sequential files (ISAM)

2. Apply relations, attributes, tuples, keys
(primary and foreign) and indexing.

3. Describe normalisation to the Third Normal Form (3NF).

4. Describe:

• data integrity
• data redundancy
• data duplication

5. Describe the role of the data dictionary in
systems analysis, design and development.

6. Apply entity-relationship diagrams.

7. Define database models:

• flat-file
• hierarchical
• network
• relational

Note: Students are expected to develop skills in using a
relational database and apply these skills to modify and
to build simple computer-based information systems.

Interview about DBs and accuracy and privacy.

• An article on voter tracking

RDBMS Assignment 2007