| 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 and optimise complex SQL queries to retrieve, manipulate, and manage 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.
- Formulate and implement complex backup and recovery strategies in database environments.
Enrolment requirements
| Requisites: |
Nil |
|---|---|
| Restrictions: |
Nil |