| Effective Term: | 2025/05 |
| Institute / School : | Institute of Innovation, Science & Sustainability |
| Unit Title: | Data Modelling |
| Unit ID: | ITECH2004 |
| Credit Points: | 15.00 |
| Prerequisite(s): | (ITECH1103 or ITECH1503 or ITECH5103) |
| Co-requisite(s): | Nil |
| Exclusion(s): | Nil |
| ASCED: | 020303 |
| Other Change: | |
| Brief description of the Unit |
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.
|
| Grade Scheme: | Graded (HD, D, C, P, MF, F, XF) |
| Work Experience Indicator: |
| No work experience |
| Placement Component: No |
| Supplementary Assessment: |
| 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 |
| Course Level: |
| Level of Unit in Course | AQF Level(s) of Course | | 5 | 6 | 7 | 8 | 9 | 10 | | Introductory | | | | | | | | Intermediate | | |  | | | | | Advanced | | | | | | |
|
| Learning Outcomes: |
| Knowledge: |
| K1. | Illustrate the components of a Relational Database Management System. |
|
| K2. | Explain the motivation for emerging trends in database technology, and the impact of database technology on organizations. |
|
| K3. | Discriminate between different types of database systems (e.g. relational, spatial, NoSQL, hierarchical, graph, object); |
|
| Skills: |
| S1. | Interpret conceptual level diagrams (e.g. entity relationship) to implement a database. |
|
| S2. | Use a database language for data definition, manipulation and control. |
|
| Application of knowledge and skills: |
| A1. | Design and build a database application using database development tools to solve a realistic business problem. |
|
| A2. | Utilise query language tools and techniques to retrieve data from a database. |
|
| Unit Content: |
Topics may include:
1. Introduction to database management systems, advantages of the database approach, data modelling, schemas, access and security provisions for multi-user databases.
2. The relational model, primary and foreign keys, referential integrity, relational algebra, structured query language and normalisation.
3. Entity relationship models.
4. Different types of databases, including relational, spatial, NoSQL, graph etc. |
| Graduate Attributes: |
| Federation University recognises that students require key transferable employability skills to prepare them for their future workplace and society. FEDTASKS (Transferable Attributes Skills and Knowledge) provide a targeted focus on five key transferable Attributes, Skills, and Knowledge that are be embedded within curriculum, developed gradually towards successful measures and interlinked with cross-discipline and Co-operative Learning opportunities. One or more FEDTASK, transferable Attributes, Skills or Knowledge must be evident in the specified learning outcomes and assessment for each FedUni Unit, and all must be directly assessed in each Course.
|
| FED TASK and descriptor | Development and acquisition of FEDTASKS in the Unit | Learning outcomes
(KSA) | Assessment task
(AT#) | FEDTASK 1
Interpersonal | Students will demonstrate the ability to effectively communicate, inter-act and work with others both individually and in groups. Students will be required to display skills in-person and/or online in: • Using effective verbal and non-verbal communication • Listening for meaning and influencing via active listening • Showing empathy for others • Negotiating and demonstrating conflict resolution skills • Working respectfully in cross-cultural and diverse teams. | Not applicable | Not applicable | FEDTASK 2
Leadership | Students will demonstrate the ability to apply professional skills and behaviours in leading others. Students will be required to display skills in: • Creating a collegial environment • Showing self -awareness and the ability to self-reflect • Inspiring and convincing others • Making informed decisions • Displaying initiative | Not applicable | Not applicable | FEDTASK 3
Critical Thinking and Creativity | Students will demonstrate an ability to work in complexity and ambiguity using the imagination to create new ideas. Students will be required to display skills in: • Reflecting critically • Evaluating ideas, concepts and information • Considering alternative perspectives to refine ideas • Challenging conventional thinking to clarify concepts • Forming creative solutions in problem solving. | A1 | AT1 | FEDTASK 4
Digital Literacy | Students will demonstrate the ability to work fluently across a range of tools, platforms and applications to achieve a range of tasks. Students will be required to display skills in: • Finding, evaluating, managing, curating, organising and sharing digital information • Collating, managing, accessing and using digital data securely • Receiving and responding to messages in a range of digital media • Contributing actively to digital teams and working groups • Participating in and benefiting from digital learning opportunities. | S2, A1, A2. | AT1 | FEDTASK 5
Sustainable and Ethical Mindset | Students will demonstrate the ability to consider and assess the consequences and impact of ideas and actions in enacting ethical and sustainable decisions. Students will be required to display skills in: • Making informed judgments that consider the impact of devising solutions in global economic environmental and societal contexts • Committing to social responsibility as a professional and a citizen • Evaluating ethical, socially responsible and/or sustainable challenges and generating and articulating responses • Embracing lifelong, life-wide and life-deep learning to be open to diverse others • Implementing required actions to foster sustainability in their professional and personal life. | Not applicable | Not applicable |
|
| Learning Task and Assessment: |
Participation in lectures, and tutorials/ laboratory classes. Students are expected to spend time regularly out of scheduled classes, reading reference material as required, reviewing topics already covered in lectures and preparing for forthcoming topics and laboratory classes and completing assessment tasks. Assessment for this unit will be based on a number of tasks. These may include written assignments, programming tasks and laboratory exercises covering the systems development and programming design. An end of semester test/examination is based on all aspects of the unit.
|
| | Learning Outcomes Assessed | Assessment Tasks | Assessment Type | Weighting | | 1. | K1, S1 | Students will interpret conceptual level diagrams (e.g. entity relationship) to implement a database. | Lab work and/or Assignment(s) | 10% - 20% | | 2. | K1, K3, S2, A1, A2 | 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. | Lab work and/or Assignment(s) | 30% - 50% | | 3. | K2, K3, S2, A1, A2 | 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. | Lab work and/or Assignment(s) | 30% - 50% | | 4. | K1, K2, K3, S1 | Tests and/or examinations covering a range of taught data modelling topics. | Oral / Written Test(s) | 0% - 30% |
|
Professional Standards / Competencies: |
| | Standard / Competency | | 1. | Skills Framework for the Information Age (SFIA): Version 8 |
|
| Attribute | Assessed | Level | | Development and implementation | | Data and analytics | | | DTAN Data modelling and design (Levels 2 - 5) Developing models and diagrams to represent and communicate data requirements and data assets. | | Yes | 2 | | | DBDS Database design (Levels 3 - 5) Specifying, designing and maintaining mechanisms for storing and accessing data. | | Yes | 3 | | | DATS Data science (Levels 2 - 7) Applying mathematics, statistics, data mining and predictive modelling techniques to gain insights, predict behaviours and generate value from data. | | Yes | 1 | | Content management | | | KNOW Knowledge management (Levels 2 - 7) Managing vital knowledge to create value for the organisation. | | Yes | 2 |
| | 2. | Australian Computer Society - Core Body of Knowledge: 2023 accreditation |
|
| Attribute | Assessed | Level | | Core ICT Knowledge | |
ICT Fundamentals
| | |
Design thinking: methods and tools that are used for handling abstraction could vary a great deal with the branch of ICT, from circuit diagrams to data modelling tools to business process modelling
| | Yes | Intermediate | |
Information & Data Science and Engineering
| | |
Nature of data, information and knowledge, meta-data, abstraction and representational quality
| | Yes | Intermediate | | |
Data modelling and semantics, relational data engineering processes
| | Yes | Advanced | | |
Database Management Systems and SQL, non-relational systems (blockchain, NoSQL, files)
| | Yes | Intermediate | | Professionalism as it applied in ICT | |
Impacts of ICT
| | |
Impacts of ICT on organisations, workplaces, jobs and skills
| | Yes | Intermediate |
|
|