| Time |
Expanded Outcomes |
Learning Strategies |
Summative Assessment |
| 1 week |
- Element 1: DBMS STRUCTURES
- Examples are relational, hierarchical, network, object oriented.
|
Lectures |
Test |
| 3 week |
- Element 2: DBMS ISSUES
- Advantages include:
- data independence,
- data integrity,
- distributed database,
- centralised database,
- handling of security,
- recovery processes.
- Activities include:
- management of data such as audit, backup & archiving, maintenance and support,
- definition of schema/sub-schema,
- insertion, amendment, deletion and retrieval of data.
|
Lectures
Practicals |
Test
Project |
| 5 weeks |
- Element 3: DATABASE DESIGN AND IMPLEMENTATION
- Design an appropriate database structure for a given business situation using methods such as
- entity relationship diagrams,
- schema depiction and
- normalisation to 3rd normal form.
- Implement an appropriately designed database structure using a commercial database management system such as Access, Interbase, Informix, Oracle, SQL Server.
- Perform functions such as data entry, queries and reports including linking from two or more tables.
|
Lectures
Practicals |
Project |