Database Concepts and Modelling

INF20004 12.5 Credit Points Online

Duration

  • 1 Study Period

Contact hours

  • 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.

Prerequisites

OR
Information Systems and Fundamentals (INF10006)

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.

Courses with unit

This unit is offered as part of Swinburne Online programs.