Course Title: Design a database
Part A: Course Overview
Program: C5395 Diploma of Information Technology
Course Title: Design a database
Portfolio: Vocational Education
Nominal Hours: 50
Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.Important Information:
Please note that this course may have compulsory in-person attendance requirements for some teaching activities.
To participate in any RMIT course in-person activities or assessment, you will need to comply with RMIT vaccination requirements which are applicable during the duration of the course. This RMIT requirement includes being vaccinated against COVID-19 or holding a valid medical exemption.
Please read this RMIT Enrolment Procedure as it has important information regarding COVID vaccination and your study at RMIT: https://policies.rmit.edu.au/document/view.php?id=209.
Please read the Student website for additional requirements of in-person attendance: https://www.rmit.edu.au/covid/coming-to-campus
Please check your Canvas course shell closer to when the course starts to see if this course requires mandatory in-person attendance. The delivery method of the course might have to change quickly in response to changes in the local state/national directive regarding in-person course attendance.
Terms
Course Code |
Campus |
Career |
School |
Learning Mode |
Teaching Period(s) |
COSC7371C |
City Campus |
TAFE |
650T Vocational Business Education |
Face-to-Face or Internet |
Term2 2019, Term1 2020, Term2 2020, Term2 2021 |
Course Contact: Luke Eberbach
Course Contact Phone: +61 3 9925 4381
Course Contact Email: luke.eberbach@rmit.edu.au
Course Description
This unit describes the skills and knowledge required to establish client needs and technical requirements and to design a database that meets those requirements.
It applies to individuals employed as database administrators and designers who are required to design databases.
Pre-requisite Courses and Assumed Knowledge and Capabilities
None
National Competency Codes and Titles
National Element Code & Title: |
ICTDBS502 Design a database |
Elements: |
1. Determine database requirements 2. Develop a logical data model 3. Design the data structures 4. Design queries, screens and reports 5. Design access and security systems 6. Confirm the database design |
Learning Outcomes
Overview of Assessment
In order to achieve competency in this unit, you must provide:
Performance Evidence
Evidence of the ability to:
- identify and confirm client requirements for a database application
- design database elements including:
- structure
- indexes
- queries
- screens
- reports
- design secure access to the database
- confirm final database design with the client.
Knowledge Evidence
To complete the unit requirements safely and effectively, you must:
- explain the process of data analysis, particularly in determining data types and data structures, query and report design
- describe the data modelling related to developing the conceptual data model
- explain how data redundancy is identified
- describe database management system (DBMS) fundamentals, particularly during the design phase
- explain encryption and authentication as these apply to database security features
- outline the functions and features of data types, and data structures
- describe the functions, and features, of databases
- describe logical design concepts, particularly those related to designing data structures, queries screens and reports
- outline the object model design concepts, particularly those related to designing data structures, queries, screens and reports
- explain the term ‘scalability’ as it applies to databases.
Assessment Conditions
Assessment must be conducted in a safe environment where evidence gathered demonstrates consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the database field of work, and include access to:
- equipment and materials
- current industry accepted database software
- network or other system for remote or multi-user access
- business requirements
- computer-aided software engineering (CASE) or diagramming software.
You are advised that you are likely to be asked to personally demonstrate your assessment work to your teacher to ensure that the relevant competency standards are being met.
Feedback
Feedback will be provided throughout the semester in class and/or online discussions. You are encouraged to ask and answer questions during class time and online sessions so that you can obtain feedback on your understanding of the concepts and issues being discussed. Finally, you can email or arrange an appointment with your teacher to gain more feedback on your progress.
You should take note of all feedback received and use this information to improve your learning outcomes and final performance in the course.