Centre for Software Engineering (CENSE)

short course: database implementation (7554x)

Purpose
The purpose of this short course is to provide an introduction to practical aspects of conceptual database design. This covers the implementation of databases in a software package where students learn the skills of creating databases, forms, reports, queries and maintaining databases.

Target group
The target group for this course people without any prior knowledge of databases, or persons who are end users of databases but have never been involved in designing a database, or lastly, persons who may have used 4GL tools to build database applications, but who lack the conceptual background on relational databases and knowledge as to how to optimise the design of relational tables for an application.

Admission requirements
Senior Certificate or an equivalent NQF level 4 qualification.
We assume that you have previously passed a computer literacy course or have end-user experience in using computers and the Microsoft Windows environment.

Duration
Semester course (offered during Semester 1 and Semester 2)  

Language medium
English

Registration periods
See http://cs-cert.unisa.ac.za/register.html

Tuition method
Distance learning only: The distance teaching model of Unisa will be used in offering this course. Students must have access to their own personal computer running Microsoft Windows and the Microsoft Access 2010 package (either as standalone version or as part of the Microsoft Office Professional package).
The practical examination is done ONLY in PRETORIA

Kind of assessment
Note: Formative assessment and examination admission will comply with UNISA’s formative assessment rules and policies.
Formative assessment: Students are expected to complete a total of practical assignments.
Summative assessment: The practical examination can be done in Pretoria only, at the Unisa computer laboratory.

Database Implementation (CSDB2D3)
HEQF Level of Module – 5
Credits of Module – 12

Syllabus/Course Content:
- Setting up relational databases
- Maintaining and querying databases
- SQL language
- Practical work using Microsoft Access
- Creating a user interface for a database

Course Fee
The fee for this course is R4200.00

Study package
The course fees include all study material: prescribed book and tutorial letters, but NOT the Microsoft Access 2010 software required for the practical work. The prescribed textbook is: Gary B Shelly, Thomas J Cashman, Philip J Pratt, Mary Z Last. Microsoft Office Access 2010: Comprehensive Concepts and Techniques. ISBN 9780538748636

Course leader
Prof E Mnkandla
School of Computing
Office: GJG 3-31, GJ Gerwel Building, UNISA Science Campus, Florida
E-mail: cense@unisa.ac.za

Programme administrator(s)

Ms Pertunia Masalesa
School of Computing
GJ Gerwel Building, Floor 3, Office 05
Tel: 011 670 9139/9189

Fax: 011 670 9174/9274
E-mail: cense@unisa.ac.za