Overview

This unit introduces students to database design and database systems development and the fundamentals of the relational database model. Students will learn how to write SQL to define, query and manipulate databases and use conceptual data analysis to produce and document a logical data model. A range of database management system (DBMS) tools will be used to design and generate a simple inquiry and update systems.

Requisites

Prerequisites
INF10002 Database, Analysis and Design
Teaching periods
Location
Start and end dates
Last self-enrolment date
Census date
Last withdraw without fail date
Results released date

Learning outcomes

Students who successfully complete this unit will be able to:

  • Explain the concepts of structured, semi-structured and unstructured data and how they are used by organisations
  • Use data analysis methods to produce and document a logical data model
  • Explain and demonstrate the key principles involved in good database design
  • Design and use simple database systems using a commercial relational database and management system tools
  • Work collaboratively in diverse groups

Teaching methods

Hawthorn

Type Hours per week Number of weeks Total (number of hours)
Face to Face Contact (Phasing out)
Lecture		2.00 12 weeks 24
Face to Face Contact (Phasing out)
Laboratory		2.00 12 weeks 24
Face to Face Contact (Phasing out)
Laboratory		2.00 12 weeks 24
Unspecified Learning Activities (Phasing out)
Independent Learning		6.50 12 weeks 78
TOTAL150

Assessment

Type Task Weighting ULO's
AssignmentGroup 15 - 25% 1,3,4,5 
Case StudyGroup 15 - 25% 1,2,3,4,5 
Online TestsIndividual 40 - 60% 1,2,3 
Oral PresentationIndividual 10 - 20% 1,2,5 

Content

  • Relational data model
  • Relational database management systems
  • Structured Query Language (SQL)
  • Entity relationship diagrams (ERD)s
  • Network diagram
  • Reading / interpreting a business narrative and/or business rules
  • Function dependency diagrams (FDD)
  • Normalisation Testing

Study resources

Reading materials

A list of reading materials and/or required textbooks will be available in the Unit Outline on Canvas.