INFS1200 Course Recap & examples

My classes are:

Session Type Building Day Time
Practical 24-S302 Mc Elwain Building Tuesday 6:00pm

Notes and summaries list

Week Summary Worked Example
1 Module 0: Introduction to DBMS
2 Module 1: Entity-relationship (ER) modelling University ERD
3 Module 2 part 1: The Relational Data Model
4 Module 2 part 2: Relation to ER mapping
5 Module 3 part 1: Introduction to SQL, DDL and basic syntax
6 Module 3 part 2: Aggregation and Grouping
7 Module 3 part 3: Multiple relation SQL queries
8 Module 3 part 4: Subqueries and division
9 Mid Semester Break
10 Module 4: Database design theory and Normalisation, part 1
11 Module 4: Normalisation, BCNF decomposition and 3NF synthesis
12 Module 5: Database Security

Past exams:

Go to UQ library - select 'Past Exams' from the dropdown menu and type in INFS1200

UQ attic

Follow this link

Something even better than UQ attic:

All solutions from past exams, tutor verified