|
Introduction
The
purpose of this module is to provide the students with an essential
introduction to modern database technology and the development of database
systems. Focusing on the
practicalities of using database systems in the ongoing development of
information systems.
Syllabus
| A |
Data,
information, storage structures, data types, databases, data
dictionaries, data models, DBMS, database administration |
| B |
Data
integration, integrity, independence, concurrency |
| C |
Data
models – conceptual, physical, relational, hierarchical, network, OO |
| D |
DBMS
features, SQL interface, relational algebra, commercial databases (e.g..
ORACLE, Informix) |
| E |
Distributed
databases, intelligent databases, decision support, data warehousing,
data mining |
| F |
Development
– normalisation, E-R diagrams, tables, relational schemes physical
design |
| G |
Data
security management - physical and logical
data control, encryption, DBMS control features |
Weighting
Each
syllabus topic listed above carries equal weighting within the module.
|
