Course Title: Design databases
Part B: Course Detail
Teaching Period: Term1 2024
Course Code: ISYS7590C
Course Title: Design databases
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.
School: 520T Future Technologies
Campus: City Campus
Program: C5402 - Diploma of Information Technology
Course Contact: Trevor Stone
Course Contact Phone: +61 3 9925 4448
Course Contact Email: trevor.stone@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
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.
Pre-requisites and Co-requisites
Mone
Course Description
In this course you will gain skills and knowledge required to establish client needs and technical requirements and to design a database that meets identified requirements.
Is delivered and assessed with the following course ICTWEB451 Apply structured query language in relational databases
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
ICTDBS506 Design databases |
|
Element: |
1. Determine database requirements |
|
Performance Criteria: |
|
|
Element: |
2. Develop logical data model |
|
Performance Criteria: |
|
|
Element: |
3. Design data structures |
|
Performance Criteria: |
|
|
Element: |
4. Design queries, screens and reports |
|
Performance Criteria: |
4.1 Design database according to organisational requirements 4.2 Design required queries and output reports 4.3 Compare physical design against conceptual model and user-needs analysis 4.4 Incorporate all required changes into database design |
|
Element: |
5. Design access and security systems |
|
Performance Criteria: |
|
|
Element: |
6. Confirm database design |
|
Performance Criteria: |
6.1 Determine database backup and recovery requirements 6.2 Develop and document database backup and restore procedures 6.3 Submit database and documentation to required personnel 6.4 Seek and respond to feedback from required personnel 6.5 Obtain final task sign off from required personnel |
Learning Outcomes
On successful completion of this course you will have developed and applied the skills and knowledge required to demonstrate competency in the above elements
Details of Learning Activities
A range of learning activities are planned for this course including self-paced and collaborative classroom based activities.
The collaborative classroom based activities will include theory sessions, practical lab sessions, tutorial sessions, and out-of-class research and homework. We expect you to participate and contribute in all scheduled learning activities
Teaching Schedule
Teaching Schedule Note - this course is Cluster with:
| COSC7395C | Apply structured query language in relational databases |
The nominal hours associated with this are a guide only and represent the total teaching time and student effort required to successfully complete the course. This may include not only scheduled classes but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.
| Week 1 | 1. Determine database requirements |
1.1 Conduct user-needs analysis with required personnel and determine database functionality requirements 1.2 Determine user-needs analysis technical requirements |
| Week 2 | 1. Determine database requirements |
1.3 Develop conceptual model of database according to organisational requirements 1.4 Submit conceptual model to required personnel 1.5 Seek and respond to feedback and make required changes |
| Week 3 | 2. Develop logical data model |
2.1 Identify attributes and determine data types 2.2 Undertake normalisation of attributes |
| Week 4 | 2. Develop logical data model |
2.3 Develop entity-relationship (ER) diagram and clarify cardinality of relationships 2.4 Document attributes, normalised data and ER diagram 2.5 Submit documentation to required personnel and seek and respond to feedback |
| Week 5 | 3. Design data structures |
3.1 Confirm primary and foreign keys according to technical requirements 3.2 Identify referential integrity constraints and organisational business rules |
| Week 6 | 3. Design data structures |
3.3 Establish database management system constraints and incorporate into database design 3.4 Design and develop data validation rules, indexes and data dictionary 3.5 Document database design according to organisational policies and procedures |
| Week 7 | 4. Design queries, screens and reports |
4.1 Design database according to organisational requirements 4.2 Design required queries and output reports |
| Week 8 | 4. Design queries, screens and reports |
4.3 Compare physical design against conceptual model and user-needs analysis 4.4 Incorporate all required changes into database design |
| Week 9 | 5. Design access and security systems |
5.1 Review existing business security plan and use as design base 5.2 Design database password and access system |
| Week 10 | 5. Design access and security systems |
5.3 Identify multiple-user requirements 5.4 Develop required organisational access profiles |
| Week 11 | 6. Confirm database design |
6.1 Determine database backup and recovery requirements 6.2 Develop and document database backup and restore procedures |
| Week 12 | 6. Confirm database design |
6.3 Submit database and documentation to required personnel 6.4 Seek and respond to feedback from required personnel 6.5 Obtain final task sign off from required personnel |
Learning Resources
Prescribed Texts
References
Other Resources
You will need laptop with charger for each class
- Windows laptops we do recommend an i5 or better machine with a minimum 4 GB of RAM.
- Macs you will need 8 GB of RAM to run a virtual machine
You may also refer to various media, websites, textbooks and e-books as indicated in Canvas such as
- USB or external hard drive for backup
- Text editor such as Visual Studio Code
Overview of Assessment
Assessment for this course is ongoing throughout the semester. Your knowledge and understanding of course content is assessed through participation in class exercises, oral presentations and through the application of learned skills and insights to your written tasks. Full assessment briefs will be provided and can be found on CANVAS
Assessment Tasks
Task 1 Case Study
Stage 1
Stage 2
Stage 3
Task 2 Practical Assessment
Assessment Matrix
Element |
Performance criteria |
|
|
|
|
Assessment 1: Product - Case Study (Database Design & Implementation) - Stage1-3 |
Assessment 2: Practical -SQL Relates to clustered unit COSC7395C* |
1. Determine database requirements |
1.1 Conduct user-needs analysis with required personnel and determine database functionality requirements |
STAGE 1 (2) |
|
1.2 Determine user-needs analysis technical requirements |
STAGE 1 (3,4) |
|
|
1.3 Develop conceptual model of database according to organisational requirements |
STAGE 2 (1) |
|
|
1.4 Submit conceptual model to required personnel |
STAGE 2 (2) |
|
|
1.5 Seek and respond to feedback and make required changes |
STAGE 1 (4,5) |
|
|
2. Develop logical data model |
2.1 Identify attributes and determine data types |
STAGE 2 (4c) |
|
2.2 Undertake normalisation of attributes |
STAGE 2 (4b) |
|
|
2.3 Develop entity-relationship (ER) diagram and clarify cardinality of relationships |
STAGE 2 (1) |
|
|
2.4 Document attributes, normalised data and ER diagram |
STAGE 2 (4) |
|
|
2.5 Submit documentation to required personnel and seek and respond to feedback |
STAGE 2 (3,4) |
|
|
3. Design data structures |
3.1 Confirm primary and foreign keys according to technical requirements |
STAGE 3 (2c) |
|
3.2 Identify referential integrity constraints and organisational business rules |
STAGE 2 (4d) |
|
|
3.3 Establish database management system constraints and incorporate into database design |
STAGE 2 (4a) |
|
|
3.4 Design and develop data validation rules, indexes and data dictionary |
STAGE 2 (4c) |
|
|
3.5 Document database design according to organisational policies and procedures |
STAGE 2 (4g) |
|
|
4. Design queries, screens and reports |
4.1 Design database according to organisational requirements |
STAGE 3 (1,2,3) |
Task 1 |
4.2 Design required queries and output reports |
|
Task 3 |
|
4.3 Compare physical design against conceptual model and user-needs analysis |
STAGE 2 (4e) |
|
|
4.4 Incorporate all required changes into database design |
STAGE 2 (4g) |
|
|
5. Design access and security systems |
5.1 Review existing business security plan and use as design base |
STAGE 1 (2,3) |
|
5.2 Design database password and access system |
STAGE 3 (6) |
|
|
5.3 Identify multiple-user requirements |
STAGE 1 (2,3) |
|
|
5.4 Develop required organisational access profiles |
STAGE 1 (4c) |
|
|
6. Confirm database design |
6.1 Determine database backup and recovery requirements |
STAGE 3 (5a,5b) |
|
6.2 Develop and document database backup and restore procedures |
STAGE 3 (5c) |
|
|
6.3 Submit database and documentation to required personnel |
STAGE 3 (5c, 6) |
|
|
6.4 Seek and respond to feedback from required personnel |
STAGE 2 (2) STAGE 2 (3) |
|
|
6.5 Obtain final task sign off from required personnel |
STAGE 3 (7, 8) |
|
Other Information
GENERAL SUBMISSION INFORMATION
Ensure that you submit assessments on or before the due date.
Always retain a copy of your assessment tasks.
For submissions you have to read, understand and agree to the content and expectations of the Assessment declaration.
Late Submission Procedures
- You are required to submit assessment items and/or ensure performance-based assessment is completed by the due dates.
Submit your assessment by the due date as any further submission will close unless extension or special consideration is granted - Apply for an extension of ONE WEEK
- By emailing the filled document Application-for-extension-of-time-to-submit-work.pdf to your teacher at least one business day before the due date and wait for approval. e.g. by Friday if due date is Sunday.
- Submit this approved form along with your assessment.
- If you need an extension of time BEYOND the one week, apply online for special consideration using this link
- You will be given ONE more opportunity to RESUBMIT the ASSESSMENT TASK
- This will be open in week 16
- No further re-submission will be available
- A satisfactory result for all assessments will result in a CA - Competency Achieved for this course.
- An unsatisfactory result for any assessment will result in a NYC - Not Yet Competent for this course
Software Requirements:
Microsoft Office (Word, Access)
Microsoft Visio (To Create ER Diagrams)
XAMPP (MySQL & Web Server) - Open Source Software
Virtual Box- Open Source Software
Course Overview: Access Course Overview