E238 Information Systems 12
Databases: Outline & Links 2008
chaos
> Lawley > Information Systems > Year 12 > Databases
TEE Questions 1997-2000
TEE Answers 1997-2000
Information Systems 12 (E238)
Databases
(25 hours)

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.

Other Stuff
Interview about DBs and accuracy and privacy.
RDBMS Assignment 2007

| Computing | Information Systems | Interactive Media |
Contents 1998-2019 LXR Modified 5 January 2019