| Effective Term: | 2025/17 |
| 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: | |
| Supplementary Assessment:Yes |
| 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 | | Level | 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. | N/A - 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 | N/A - 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. | Level 2 - Student demonstrates some independence within provided guidelines | 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. | Level 2 - Student demonstrates some independence within provided guidelines | 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. | N/A - Not Applicable |
|
| | 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. | 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. | 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. | 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% | | 5. | K1, K3, S2, A2 | Complete laboratory activities and engage in in-class discussions synchronously or asynchronously as appropriate | Participation in laboratories | 5%-10% |
|