SIT772 - Database Fundamentals

Unit details

Year:

2024 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: Jihong Park
Trimester 2: Iynkaran Natgunanathan
Trimester 3: Jianxin Li
Prerequisite:

Nil

Corequisite:

SIT771

Incompatible with:

SIT103

Typical study commitment:

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

This will include educator guided online learning activities within the unit site.

Educator-facilitated (scheduled) learning activities - on-campus unit enrolment:

1 x 2 hour online lecture per week, 1 x 2 hour practical experience (workshop) per week, weekly meetings.

Educator-facilitated (scheduled) learning activities - online unit enrolment:

Online independent and collaborative learning including 1 x 2 hour online practical experience (workshop) per week, weekly meetings.

Note:

Students enrolled in S406, S408, S434, S464, S470, S479, S506, S507, S508, S536, S538, S735, S737, S739, S770, S779, are not eligible to enrol in the following units:

SIT771 Object-Orientated Development
SIT772 Database and Information Retrieval
SIT773 Software Requirements Analysis and Modelling
SIT774 Web Technologies and Development

Content

This unit covers the fundamentals of designing, implementing, and managing relational database systems in industry-standard IT applications. It introduces data modelling, with a specific focus on entity-relationship (ER) modelling. Students will learn how to construct ER diagrams, ensuring that the model's semantics match those of the real-world object it represent. It also teaches how to construct, maintain, and retrieve information relational databases using SQL. Through real-world business case scenarios and project-based learning, students will gain skills to design, implement and manage databases.

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

Conduct research on and critically evaluate tools and technologies used in contemporary business information systems to manage and analyse data.

GLO1: Discipline-specific knowledge and capabilities
GLO4: Critical thinking

ULO5

Analyse and critique the 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 and Morris, 2022, Database Systems Design Implementation Management, 14th edition, Cengage Learning.

The texts and reading list for the unit can be found on the University Library via the link below: SIT772 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

Fees and charges vary depending on the type of fee place you hold, your course, your commencement year, the units you choose to study and their study discipline, and your study load.

Tuition fees increase at the beginning of each calendar year and all fees quoted are in Australian dollars ($AUD). Tuition fees do not include textbooks, computer equipment or software, other equipment or costs such as mandatory checks, travel and stationery.

Use the Fee estimator to see course and unit fees applicable to your course and type of place.

For further information regarding tuition fees, other fees and charges, invoice due dates, withdrawal dates, payment methods visit our Current Students website.