ENAI12-202: Data Management

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

Type: Undergraduate Subject
Code: ENAI12-202
Faculty: Bond Business School
Credit: 10
Study areas:
  • Business, Commerce, and Entrepreneurship

Learning outcomes

  1. Analyse the fundamental concepts of data management, including the differences between relational and non-relational databases.
  2. Apply SQL queries to retrieve, manipulate, manage, backup and recover data in relational databases.
  3. Construct Entity-Relationship (ER) diagrams to model real-world data scenarios and create the corresponding tables using SQL.
  4. Analyse database designs for redundancy, efficiency, and reliability using normalisation techniques.
  5. Analyse the ethical and governance implications of data management decisions in AI-powered business systems.
  6. Deliver a structured presentation on the design and maintenance of a specified data management system to a technical audience.

Enrolment requirements

Requisites:

Nil
Restrictions:

Nil