| Type: | Postgraduate Subject |
|---|---|
| Code: | ENAI71-202 |
| Faculty: | Bond Business School |
| Credit: | 10 |
| Study areas: |
|
Description
This subject introduces students to the principles and practices of managing data effectively in modern computing environments. It covers foundational topics such as database design, relational models, and the use of SQL for querying and manipulating data. Students will learn to construct Entity-Relationship diagrams, apply normalisation techniques to optimise database structure, and explore strategies for ensuring data reliability through backup and recovery. The subject also examines the evolution of data systems by introducing NoSQL and non-relational databases, highlighting their applications in handling large-scale, unstructured data. Through practical exercises and conceptual analysis, students will gain the skills to design, implement, and maintain robust data management solutions, using AI to support the learning of the syntax for specific database management software.
Subject details
Learning outcomes
- Critically evaluate data management paradigms, including relational and non-relational models, to determine their suitability for diverse applications.
- Design complex SQL to retrieve, manipulate, manage, backup and recover data in relational databases.
- Develop and refine data models using Entity-Relationship (ER) diagrams to model real-world data scenarios and create the corresponding tables using SQL.
- Assess and improve database designs for redundancy, efficiency, and reliability using normalisation techniques.
- Design an ethical governance framework for data management in AI-powered business systems.
- Deliver structured presentations on the design and maintenance of a complex data management systems.
Enrolment requirements
| Requisites: |
Nil |
|---|---|
| Restrictions: |
Nil |