Lecture | Information Systems

INFT1040 Databases & Information Management


On successful completion of the course students will be able to:

1. Understand data modelling and normalization

2. Evaluate the role of database management systems

3. Recognise and use contemporary logical design methods and tools for databases

4. Comprehend database languages (e.g. SQL)

5. Implement a database solution to a computing problem

6. Develop sophisticated queries to extract information from large datasets.

7. Understand data security and data quality management

Learning outcomes

1. Data Modelling (ER Model and Conceptual Design)

2. Relational Algebra and Relational Calculus

3. SQL

4. Transaction Management and Concurrency Control

5. Schema Refinement, Functional Dependencies, Normalisation

6. Securty and Authorisation

7. Database Administration

Number of credit hours per week 4
Course eligibility Compulsory
Presence of students On-campus