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. Definition, scope and components of Information Systems (e.g., hardware, software, data, procedures, and people)
4. Types of Information Systems: transaction processing systems, management information systems, decision support systems, executive support systems, etc.
5. Representation and use of data in Information System
6. Database life cycle (e.g., requirements analysis, design, implementation, maintenance)
7. Database design principles: normalisation, entity-relationship modelling.
8. Relational database concepts: tables, rows, columns, keys, relationships.
9. SQL (Structured Query Language): basic queries, data manipulation, data definition, joins. |
| | Learning Outcomes Assessed | Assessment Tasks | Assessment Type | Weighting | Professional Standards |
| 1. |
1, 2, 3, 4 |
Students complete a series of practical laboratory activities throughout the semester and compile a portfolio of selected artefacts, outputs, and short professional explanations. Students then participate in an individual live demonstration where they explain concepts, perform practical tasks, and justify decisions related to data, information systems, and data management activities completed during the laboratories. |
Laboratory Portfolio and Demonstration |
10-30% |
1.3, 1.5 |
| 2. |
1, 2, 3, 4 |
Working in teams, students analyse a real-world organisational problem and design an information system solution that addresses business and information requirements. The project includes analysis of data sources, system components, information flows, technology selection, and data management strategies. |
Organisational Information System Design Project |
30-40% |
1.3, 1.5 |
| 3. |
1, 2, 4, 5 |
Students individually design and implement a data management solution for a given organisational scenario. The project includes requirements analysis, database design, relational schema development, SQL implementation, and data quality considerations. Students complete a validation exercise where they explain their design decisions and demonstrate the functionality of their solution. |
Data Management Solution Project |
30-40% |
1.3, 1.5 |
|