SIT103 - Database Fundamentals

Unit details

Note: You are seeing the 2023 view of this unit information. These details may no longer be current. [Go to the current version]
Year:

2023 unit information

Enrolment modes:Trimester 1: Burwood (Melbourne), Waurn Ponds (Geelong), Online
Trimester 2: Burwood (Melbourne), Waurn Ponds (Geelong), Online
Trimester 3: Burwood (Melbourne), Waurn Ponds (Geelong), Online
Credit point(s):1
EFTSL value:0.125
Unit Chair:Trimester 1: Sunil Aryal
Trimester 2: Shamsul Huda
Trimester 3: Jianxin Li
Prerequisite:

Nil

Corequisite:Nil
Incompatible with:

SIT772

Typical study commitment:

Students will on average spend 150 hours over the teaching period undertaking the teaching, learning and assessment activities for this unit.

Scheduled learning activities - campus:

1 x 2 hour online class per week, 1 x 2 hour workshop per week, weekly drop-in sessions.

Scheduled learning activities - online:

Online independent and collaborative learning 1 x 2 hour online class per week (recordings provided), 1 x 2 hour online workshop per week, weekly drop-in sessions.

Content

This unit will provide a solid foundation for the design, implementation and management of relational database systems. Data modelling is introduced, focusing on entity-relationship (ER) modelling. The skills required to construct such ER diagrams will be explored, with a focus on ensuring that the semantics of the model match those of the real-world it is representing. The relational data model will be presented and the functionality it affords will be explored. The process of constructing, maintaining and retrieving information from the database using SQL will be a focus of this unit. 

ULO These are the Learning Outcomes (ULO) for this unit. At the completion of this unit, successful students can: Deakin Graduate Learning Outcomes
ULO1 Interpret and explain fundamental concepts of data, information, and knowledge and demonstrate an understanding of differences between traditional file systems and databases. GLO1: Discipline-specific knowledge and capabilities

ULO2

Analyse real-world problems to identify data requirements and apply data modelling concepts to design and develop Entity Relationship Diagrams for efficient data representation and storage.

GLO1: Discipline-specific knowledge and capabilities
GLO4: Critical thinking
GLO5: Problem solving

ULO3

Design, implement, evaluate and maintain relational database systems using SQL and Database Management Systems and explain the purpose of various SQL commands and operations.

GLO1: Discipline-specific knowledge and capabilities
GLO3: Digital Literacy
GLO4: Critical thinking

ULO4

Analyse and critique achievements of learning outcomes and justify meeting specified outcomes through providing relevant evidence and evaluating the quality of that evidence against given criteria.

GLO4: Critical thinking
GLO6: Self-management

Assessment

Assessment Description Student output Grading and weighting
(% total mark for unit)
Indicative due week
Learning Portfolio Portfolio consisting of research reports, online quizzes, completion reports, database design documents and SQL scripts, learning summary report. 100% Week 12

The assessment due weeks provided may change. The Unit Chair will clarify the exact assessment requirements, including the due date, at the start of the teaching period.

Hurdle requirement

To be eligible to obtain a pass in this unit, students must meet certain milestones as part of the portfolio.

Learning Resource

Prescribed text(s): Coronel, 2018, Database Systems Design Implementation Management, 13th edition, Cengage Learning.

The texts and reading list for the unit can be found on the University Library via the link below: SIT103 Note: Select the relevant trimester reading list. Please note that a future teaching period's reading list may not be available until a month prior to the start of that teaching period so you may wish to use the relevant trimester's prior year reading list as a guide only.

Unit Fee Information

Click on the fee link below which describes you: