1 Study Period
- Recommended 8 hours of study per week
On-campus unit delivery combines face-to-face and digital learning. For Online unit delivery, learning is conducted exclusively online.
Aims and objectives
This unit extends the basic information technology skills gained in LAI100 (CIS13) OR LEB111 to the development of a simple automated personal database update and retrieval system to solve a problem. This unit provides an understanding of the development and management of relational databases with emphasis on data modeling and conceptual database knowledge. The student acquires the foundation knowledge necessary to evaluating database management systems. Within this framework data information and corporate knowledge are distinguished. Highlighted are the importance of database security and recovery and the integral role of the Database Administrator (DBA). Advanced database concepts are explored, covering Distributed Database Management Systems (DDBMS), Object-Oriented DBMS and databases in electronic commerce.
After you have successfully completed this unit you should be able to:
1. Analyse and explain the basic goals and functions of databases, their applications and social impact.
2. Explain the significance of each stage of the database life cycle (DBLC).
3. Apply relational database modelling techniques and principles for conversion and application into physical designs.
4. Develop a working relational database prototype using a specified DBMS tool.
5. Explain the role of database administration and the importance of database security, backup and recovery.
6. Demonstrate a basic knowledge of contemporary and evolving trends such as distributed database management systems (DDBMS), data warehouses and object-oriented DBMS.