Topics may include:
1. Different types of data (e.g. structured, semi-structured, unstructured)
2. Sources of data (e.g. sensors, medical, business, social data)
3. Database life cycle (e.g., requirements analysis, design, implementation, maintenance)
4. Database design principles: normalization, entity-relationship modelling.
5. Relational database concepts: tables, rows, columns, keys, relationships.
6. SQL (Structured Query Language): basic queries, data manipulation, data definition, joins.
7. Definition, scope and components of Information Systems.
8. Representation and use of data in Information System (Master Data, Transactional Data)
9. Components of an Information System (e.g., hardware, software, data, procedures, and people)
10. Types of Information Systems: transaction processing systems, management information systems, decision support systems, executive support systems, etc. |
| | Learning Outcomes Assessed | Assessment Tasks | Assessment Type | Weighting | Professional Standards |
| 1. |
K1 |
Students will describe different types of data and their sources. |
Lab work and/or Assignment(s) |
10-15% |
|
| 2. |
K1, K2, S1, A1 |
Students will choose and/or implement an appropriate data management solution for a chosen specific problem and describe the components of the process. The assessment also includes theoretical questions to provide context and opportunities for reflection on the analytical tasks undertaken. |
Lab work and/or Assignment(s) |
30%-55% |
|
| 3. |
K3, K4, S1, A1 |
Students will select an appropriate information systems solution for a chosen specific problem and describe the components of the process. The assessment also includes theoretical questions to provide context and opportunities for reflection on the analytical tasks undertaken. |
Lab work and/or Assignment(s) |
30%-60% |
|
|