On completion of this course students will be able to:

1. Understand and evaluate the role of database management systems in information technology applications within organisations;
2. Recognise and use various conceptual models, logical design methods and tools for developing databases;
3. Derive a physical design for a database from its logical design;
4. Implement a database solution to an information technology problem using a commercial RDBMS.
5. Program using the SQL data definition and SQL query languages.
6. Recognise the value of and understand the problems associated with the use of procedural language extensions to SQL.
7. Understand contemporary emerging technologies such as On-Line Analytical Processing (OLAP) and Data Warehouses.

1. The role of databases and database management systems.
2. Database models.
3. Conceptual modelling with EER
4. Logical design of databases.
5. Physical design of databases.
6. SQL query language.
7. Procedural language extensions to SQL.
8. Contemporary issues and emerging technologies such as On-Line Analytical Processing (OLAP) and Data Warehouses.

0

INFO6001

External Mode
Internal Mode

Email Discussion Group
Lecture
Self Directed Learning
Computer Lab

Computer Lab: for 2 hour(s) per Week for Full Term
Lecture: for 2 hour(s) per Week for Full Term
Self Directed Learning: for 10 hour(s) per Week for Full Term