Skip to Main Content
Catalogue Link
<a href="/ords/r/dev/fed_occ/home" class="t-Header-logo-link"><span class="apex-logo-text">Handbook</span></a>
Hidden Page Items
New
5
New
HE Unit Template
New
Data Modelling
New
ITECH2004 - Data Modelling
New
20250600
New
New
New
New
Course
New
Unit
New
New
4.1
New
New
2026-06-16
New
2026-06-16
New
Information Technology
New
New
New
New
Institute of Innovation, Science & Sustainability
New
Information Technology
New
Undergraduate
New
15
New
New
.125
New
020303
New
Database Management
New
<a href="http://www.federation.edu.au/locate/unit/itech2004">020303 - Database Management</a>
New
Graded (e.g. HD, D, C, etc)
New
7
New
Bachelor Degree
New
Intermediate
New
New
New
New
1
New
New
New
New
New
false
New
New
New
<p>This unit expands upon the capabilities and advantages of modern database systems. Students will explore the different types of systems designed for storing, manipulating, and retrieving various types of data, and use them to design solutions to practical problems.</p>
New
New
<p>Topics may include:<br>
1. Introduction to database management systems, advantages of the database approach, data modelling, schemas, access and security provisions for multi-user databases.<br>
2. The relational model, primary and foreign keys, referential integrity, relational algebra, structured query language and normalisation.<br>
3. Entity relationship models.<br>
4. Different types of databases, including relational, spatial, NoSQL, graph etc.</p>
New
true
New
<p>Where supplementary assessment is available a student must have failed overall in the Unit but gained a final mark of 45 per cent or above, has completed all major assessment tasks (including all sub-components where a task has multiple parts) as specified in the Unit Description and is not eligible for any other form of supplementary assessment.</p>
New
true
Hidden Page Items
Semester
Semester
0200
Year
Year
2026
Current Year
2026
Breadcrumb Positioning
Handbook
ITECH2004 - Data Modelling
Pseudo Breadcrumb
ITECH2004 - Data Modelling
Breadcrumb Type
Unit
Catalogue Term and Year
Version Text
You are viewing a version for
Semester
Semester 1
Semester 2
Summer Semester
Year
2026
Download PDF
RDS Holder
Overview
Key information
Requisites
Learning outcomes
Assessment
FedTASK
Parent Region
Overview
Unit description
<p>This unit expands upon the capabilities and advantages of modern database systems. Students will explore the different types of systems designed for storing, manipulating, and retrieving various types of data, and use them to design solutions to practical problems.</p>
Unit content
<p>Topics may include:<br> 1. Introduction to database management systems, advantages of the database approach, data modelling, schemas, access and security provisions for multi-user databases.<br> 2. The relational model, primary and foreign keys, referential integrity, relational algebra, structured query language and normalisation.<br> 3. Entity relationship models.<br> 4. Different types of databases, including relational, spatial, NoSQL, graph etc.</p>
Key information
Institute / school:
Institute of Innovation, Science & Sustainability
Discipline:
Information Technology
Study level:
Undergraduate
Credit points:
15
EFTSL:
0.125
Field of education:
<a href="http://www.federation.edu.au/locate/unit/itech2004">020303 - Database Management</a>
Offering:
<p><strong>Northern Hemisphere Semester 1</strong><p>HUST-Federation IT Institute (HE Partner)</p></p> <p><strong>Semester 2</strong><p>Ballarat - Mt Helen (On Campus)</p><p>Berwick (On Campus)</p><p>On-line Learning (Online)</p></p>
Grade scheme:
Graded (e.g. HD, D, C, etc)
Placement component:
No
Requisites
Prerequisite
<p> must have completed 1 of <a href="/ords/r/dev/fed_occ/course?p6_code=ITECH1103" target="_blank">ITECH1103</a>/ITECH1503/ITECH5103</p>
Corequisite
None
Exclusion
None
Learning outcomes
Learning outcomes
<p>On successful completion of this unit, students are expected to gain the following [K]nowledge, [S]kills and [A]pplication of knowledge & skills</p>
Learning Outcomes
Ref
Outcome
K1
<p>Illustrate the components of a Relational Database Management System.</p>
K2
<p>Explain the motivation for emerging trends in database technology, and the impact of database technology on organizations.</p>
K3
<p>Discriminate between different types of database systems (e.g. relational, spatial, NoSQL, hierarchical, graph, object);</p>
S1
<p>Interpret conceptual level diagrams (e.g. entity relationship) to implement a database.</p>
S2
<p>Use a database language for data definition, manipulation and control.</p>
A1
<p>Design and build a database application using database development tools to solve a realistic business problem.</p>
A2
<p>Utilise query language tools and techniques to retrieve data from a database.</p>
Assessment
Learning Tasks and Assessment
Ref
Learning task
Assessment type
Weighting
Learning outcomes assessed
1
<p>Students will interpret conceptual level diagrams (e.g. entity relationship) to implement a database.</p>
<p>Assignment(s)</p>
<p>10% - 20%</p>
K1, S1
2
<p>Students will apply database tools and techniques to solve real-world problems. This assessment will focus on the design, implementation and theoretical underpinnings of Relational Database Management Systems and their extensions.</p>
<p>Assignment(s)</p>
<p>30% - 50%</p>
K1, K3, S2, A1, A2
3
<p>Students will apply database tools and techniques to solve real-world problems. This assessment will focus on the implementation and reflection on database technologies used for contemporary data modelling challenges.</p>
<p>Assignment(s)</p>
<p>30% - 50%</p>
K2, K3, S2, A1, A2
4
<p>Tests and/or examinations covering a range of taught data modelling topics.</p>
<p>Oral / Written Test(s)</p>
<p>0% - 30%</p>
K1, K2, K3, S1
5
<p>Complete laboratory activities and engage in in-class discussions synchronously or asynchronously as appropriate</p>
<p>Participation in laboratories</p>
<p>5%-10%</p>
K1, K3, S2, A2
Supplementary assessment available:
Yes
Supplimentary assessment information:
<p>Where supplementary assessment is available a student must have failed overall in the Unit but gained a final mark of 45 per cent or above, has completed all major assessment tasks (including all sub-components where a task has multiple parts) as specified in the Unit Description and is not eligible for any other form of supplementary assessment.</p>
FedTASK
FedTASK
<p>Federation University recognises that students require key transferable employability skills to prepare them for their future workplace and society. FedTASKs (<strong>T</strong>ransferable <strong>A</strong>ttributes <strong>S</strong>kills and <strong>K</strong>nowledge) provide a targeted focus on five key, transferable Attributes, Skills, and Knowledge that are embedded within curriculum, developed gradually towards successful measures and interlinked with cross-discipline and co-operative learning opportunities.</p>
FedTASK
Description of FedTASK outcome
Level
FedTASK 1: Interpersonal
The ability to effectively communicate, interact and work with others both individually and in groups.
FedTASK 2: Leadership
The ability to apply professional skills and behaviours in leading others.
FedTASK 3: Critical Thinking and Creativity
The ability to work in complexity and ambiguity using imagination to create new ideas.
<p>Level 2 - Student demonstrates some independence within provided guidelines</p>
FedTASK 4: Digital Literacy
The ability to work fluently across a range of tools and applications to achieve a range of skills.
<p>Level 2 - Student demonstrates some independence within provided guidelines</p>
FedTASK 5: Sustainable and Ethical Mindset
The ability to consider and assess the consequences and impact of ideas and actions in enacting ethical and sustainable decisions.
Key information
Institute / school:
Institute of Innovation, Science & Sustainability
Discipline:
Information Technology
Study level:
Undergraduate
Credit points:
15
EFTSL:
0.125
Field of education:
<a href="http://www.federation.edu.au/locate/unit/itech2004">020303 - Database Management</a>
Offering:
<p><strong>Northern Hemisphere Semester 1</strong><p>HUST-Federation IT Institute (HE Partner)</p></p> <p><strong>Semester 2</strong><p>Ballarat - Mt Helen (On Campus)</p><p>Berwick (On Campus)</p><p>On-line Learning (Online)</p></p>
Grade scheme:
Graded (e.g. HD, D, C, etc)
Placement component:
No
Disclaimer
<em>Information in the Federation Handbook is correct at the time of publication. The University reserves the right to alter any course, unit, procedure or fee.</em>
Additional information
Add Info Static Text
Internal reference: ITECH2004 - U4.1