Welcome to ITRW 311 - Databases presented by Mr. AR Botes in the School of Information Technology.

Please use this site to orientate yourself throughout this semester and to be informed on whats happening.

Class Times:

Monday: 8:00 - 11:00 - Building 3-103 (Practical + Theory classes will be on Mondays, due to the heat in other venues)

Tuesday: 12:30 - 14:00 - Building 25 - G08 (Extra class, notice will be given if used)

Thursday: 12:30 - 14:00 - Building 25 - G08 (Extra class, notice will be given if used)

About this module:

At the end of this module you should have insight and a basic knowledge of the difference between filing systems and databases; the relational database model opposite hierarchical and object-oriented database models; entity relationship modelling; normalization of database models; database design, SQL and can by means of a practical project display the skills to create a conceptual design, do verification of the model, logically design and implement the database.

The successful execution of the practical project will be proof that you can apply the insight and knowledge acquired in problem-solving in the subject area and its fields of application.

Outcomes of this module:

•Discuss the definition and components of the different types of databases.

•Apply a rounded and systematically knowledge and insight of entity relation modelling.

•Normalization of database tables.

•Write SQL and PL/SQL statements.
 
•Apply procedures to design databases and retrieve information to solve known and abstract computer problems within the database environment.
 
•Gain an understanding of new NoSQL data models and their implementations.