INF201 Database Systems

Home
INF201 Database Systems

Unit Code

INF201

Level

Undergraduate

Campus

Brisbane | Sydney

Prerequisites

INF101

Credit Points

Overview

Database Systems (INF201) provides an opportunity for students to learn about several database models and, in particular, the relational database model. As part of hands-on learning, students will formulate entity relationship diagrams (ERD) for a given set of business requirements and learn to apply normalisation techniques to improve efficiency. Subsequently, these models will be mapped to a physical database and students will learn how to use structured query language (SQL) to import and export data from a functioning database. Students will learn about some of the regulatory and privacy issues pertaining to databases. Finally, students will gain an understanding of trends such as datamining and NoSQL databases.

Associated Degrees

Bachelor of Business (Information Systems)
Bachelor of Business (Marketing)

Duration | AQF Level

One Semester | Level 7

Core or elective Subject

☐ core subject
☐ elective subject
☒ other (please specify below): Core for BBIS and elective for BBM

Study Modes

√ Face to face on site
√ Full-time
√ Part-time

Learning Outcomes

Compare and contrast the relational database model with other models
Formulate entity relationship diagrams (ERD) to model real-life business requirements
Design and generate databases from basic ERD and apply normalisation techniques to improve efficiency
Import and extract data from a database using structured query language (SQL)
Evaluate the impacts of regulatory requirements such as privacy laws (e.g., APP, GDPR, CDR) and data security obligations on the design, management, and use of organisational databases.
Demonstrate an understanding of trends such as data mining and compare NoSQL technology with relational databases within the context of big data

Assessment

AIIHE uses a variety of assessment tools to guide and assess each student’s achievement of their learning outcomes. In this subject there will be in–class activities intended to support you to engage in and reflect on your learning journey and understanding of the subject. You will also undertake assessment tasks related to your skills development, your effective engagement in group work and delivery of collaborative outcomes, including a written report and an oral presentation.

Summary of Assessment

Assessment Task	Due Date	Weighting
Assessment 1: In-Class Reflection and Practical Activities	Week 3 - 12	10%
Assessment 2: Group Assessment (staged assignment where in Stage 1 and 2 students will be working in groups. Stage 3 is an individual)	Week 3	15%
Assessment 3: Group Assessment	Week 7	35%
Assessment 4: Individual Presentation and Report	Week 12	40%

Learning Resources

AIIHE will update the topic coverage of the subject and the available relevant learning resources at the time of subject delivery. In the interim, AIIHE provides the following indicative list of relevant reference material. AIIHE also subscribes to eLearning Resources through the Canvas portal, and where relevant material is available, AIIHE will seek to source reference material from this system for staff and student access.