| Type: | Undergraduate Subject |
|---|---|
| Code: | ENAI12-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
- Explain the fundamental concepts of data management, including the differences between relational and non-relational databases.
- Apply SQL queries to retrieve, manipulate, and manage data in relational databases.
- Construct Entity-Relationship (ER) diagrams to model real-world data scenarios and create the corresponding tables using SQL.
- Analyse database designs for redundancy, efficiency, and reliability using normalisation techniques.
- Demonstrate practical skills in implementing backup and recovery strategies in database environments.
Enrolment requirements
| Requisites: |
Nil |
|---|---|
| Restrictions: |
Nil |