International
Advanced Diploma in Computer Studies (IADCS)
Syllabus - IAD204 - Database Design
& Development
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.
|
# |
Topic Area |
|
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.
Copyright © 2006 Institute for Information Technology (IIT)
 |
Detailed Syllabus & Course Structure |
| |
Assessment & Weighting |
| |
Entry Requirements |
| |
Course Duration, Timings & Intakes |