Course Title: Create basic relational databases
Part B: Course Detail
Teaching Period: Term1 2025
Course Code: ISYS7594C
Course Title: Create basic relational databases
Important Information:
Please note that this course may have compulsory in-person attendance requirements for some teaching activities.
Please check your Canvas course shell closer to the course start date 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 course requirements. It is advisable for students to keep in contact with their teachers regarding in-person course attendance.
School: 520T Future Technologies
Campus: City Campus
Program: C4410 - Certificate IV in Information Technology
Course Contact: Chandra Nannegari
Course Contact Phone: +61 3 9925 4612
Course Contact Email: chandra.nannegari@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
Nominal Hours: 40
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
None
Course Description
In this course you will gain the skills and knowledge required to design, develop and test relational databases to meet specifications.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
ICTDBS416 Create basic relational databases |
Element: |
1. Prepare to create relational database |
Performance Criteria: |
1.1 Determine organisational database functionality requirements. 1.2 Document organisational database requirements. 1.3 Gather required data according to task requirements. 1.4 Submit document to required personnel and according to organisational policies and procedures. 1.5 Seek and respond to documentation feedback according to organisational policies and procedures. |
Element: |
2. Design relational database |
Performance Criteria: |
2.1 Design entity-relationship (ER) diagram to model relationships between entities, including entity attributes according to functionality requirements. 2.2 Define primary and foreign keys and implement relationships. 2.3 Normalise database model. 2.4 Develop data dictionary and detail entity attributes according to functionality requirements.2.5 Document ER diagram and data dictionary, including data model, and submit to required personnel. 2.6 Seek feedback from required personnel, and update data model according to feedback. |
Element: |
3. Create relational database |
Performance Criteria: |
3.1 Use required language on web and database server to create relational database according to confirmed task design. 3.2 Create tables according to required language and ER diagram. 3.3 Populate database fields according to task requirements. 3.4 Test and fix database problems on web and database server. |
Element: |
4. Finalise relational database and required documentation |
Performance Criteria: |
4.1 Determine alignment between represented information and task requirements 4.2 Confirm and submit all task documentation to required personnel 4.3 Seek and respond to feedback on task delivery and documentation 4.4 Save changes and obtain final task signoff 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 tasks outlined in the elements, performance criteria and foundation skills of this unit.
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 and practical sessions.
Out-of-class activities will include reading online learning materials and competing out-of class assessment tasks.
We expect you to participate and contribute in all scheduled learning activities.
Teaching Schedule
Teaching Schedule:
Semester 1: 2025
The study program is outlined below. Every effort will be made to adhere to this outline, but the school reserves the right to make changes as appropriate.
| Week | Date | Topic | Learning Activity | Assessment / Learning activities |
| Week 1 | 10/02/2025 - 16/02/2025
|
Course Overview Introduction: General Database Concepts |
|
|
| Week 2 | 17/02/2025-23/02/2025 |
Course Overview (Continued) Introduction: General Database Concepts ( Continued) |
|
Week 2: Pre-Assessment (Non-assessed) |
| Week 3 | 24/02/2025-2/03/2025 |
Part 1: Prepare to Create Relational Databases 1.1 Determine organisational database functionality requirements. 1.2 Document organisational database requirements. 1.3 Gather required data according to task requirements. 1.4 Submit document to required personnel and according to organisational policies and procedures. 1.5 Seek and respond to documentation feedback according to organisational policies and procedures. |
Learning Activity 3: Business Requirements Document (Template) |
Week 3: Assessment Task 1: Online Quiz 1 Released. Due: Week 5, Friday, 5:30 PM |
| Week 4 | 3/03/2025-9/03/2025 |
Part 2: Design Relational Databases 2.1 Design entity-relationship (ER) diagram to model relationships between entities, including entity attributes according to functionality requirements. 2.2 Define primary and foreign keys and implement relationships. 2.3 Normalise database model. 2.4 Develop data dictionary and detail entity attributes according to functionality requirements. 2.5 Document ER diagram and data dictionary, including data model, and submit to required personnel. 2.6 Seek feedback from required personnel, and update data model according to feedback. |
Learning Activity 4: Creating Entity Relation Diagram (Using MS Visio)
Learning Activity 5: Introduction to XAMPP (Database and Web Server) |
|
| Week 5 |
10/03/2025-16/03/2025
|
Part 3A: Create Relational Databases - Using Design Tools Part 3A: Create Relational Databases - Using Design Tools 3.1 Use required language on web and database server to create relational database according to confirmed task design. 3.2 Create tables according to required language and ER diagram. 3.3 Populate database fields according to task requirements. 3.4 Test and fix database problems on web and database server. |
Learning Activity 6: Application of Business Rules to Relationships
Work on Assessment Task 2 (Part A): Prepare to Create and Design Relational Database
|
Week 5: Assessment Task 1: Online Quiz 1 Due
Week 5: Assessment Task 2: Prepare to Create and Design Relational Database Released (Part A). Due (Part A) : Week 9, Friday, 5:30 PM
|
| Week 6 | 17/03/2025-23/03/2025 |
Part 3A: Create Relational Databases - Using Design Tools (Continued)
Part 3A: Create Relational Databases - Using Design Tools 3.1 Use required language on web and database server to create relational database according to confirmed task design. 3.2 Create tables according to required language and ER diagram. 3.3 Populate database fields according to task requirements. 3.4 Test and fix database problems on web and database server. |
Learning Activity 7: Creating, Testing, Debugging, and Searching a Database (Using Design Tools in XAMPP) | Week 6: Assessment Task 1: Online Quiz 2 Released. Due: Week 8, Friday, 5:30 PM |
| Week 7 | 24/03/2025-30/03/2025 | Assessment Task 2 (Part A): Prepare to Create and Design Relational Database | Interviews: Week 7 | |
| Week 8 |
31/03/2025 - 6/04/2025
|
Part 3A: Create Relational Databases - Using Design Tools (Cont.) Part 3A: Create Relational Databases - Using Design Tools 3.1 Use required language on web and database server to create relational database according to confirmed task design. 3.2 Create tables according to required language and ER diagram. 3.3 Populate database fields according to task requirements. 3.4 Test and fix database problems on web and database server. |
Learning Activity 7: Creating, Testing, Debugging, and Searching a Database (Using Design Tools in XAMPP) |
Week 8: Assessment Task 1: Online Quiz 2 Due
|
| Week 9 | 7/04/2025-13/04/2025 |
Part 3A: Create Relational Databases - Using Design Tools (Cont.) Part 3A: Create Relational Databases - Using Design Tools 3.1 Use required language on web and database server to create relational database according to confirmed task design. 3.2 Create tables according to required language and ER diagram. 3.3 Populate database fields according to task requirements. 3.4 Test and fix database problems on web and database server. |
Learning Activity 7: Creating, Testing, Debugging, and Searching a Database (Using Design Tools in XAMPP) |
Week 9: Assessment Task 2 (Part A): Prepare to Create and Design Relational Database Due
Week 9: Assessment Task 2 (Part B): Prepare to Create and Design Relational Database Released. Due (Part B) : Week 12, Friday, 5:30 PM |
| Week 10 | 14/04/2025-20/04/2025 |
Part 3B: Create Relational Databases - Using SQL Scripts 3.1 Use required language on web and database server to create relational database according to confirmed task design. 3.2 Create tables according to required language and ER diagram. 3.3 Populate database fields according to task requirements. 3.4 Test and fix database problems on web and database server. |
Learning Activity 8: Creating, Testing, Debugging, and Searching a Database (Using SQL Scripts)
Work on Assignment Task 2. |
Week 12: Assessment Task 2 (Part B): Prepare to Create and Design Relational Database Due
Week 12: Assessment Task 3: Create and Test Relational Database Released. Due: Week 16, Friday, 5:30 PM
|
| Mid-Semester Break 18/04/2025 -25/04/2025 | ||||
| Week 11 | 30/04/2025- 6/05/2025 |
Part 3B: Create Relational Databases - Using SQL Scripts (cont.) 3.1 Use required language on web and database server to create relational database according to confirmed task design. 3.2 Create tables according to required language and ER diagram. 3.3 Populate database fields according to task requirements. 3.4 Test and fix database problems on web and database server. |
Learning Activity 8: Creating, Testing, Debugging, and Searching a Database (Using SQL Scripts)
Work on Assignment Task 2. |
|
| Week 12 | 5/05/2025-11/05/2025 |
Part 3B: Create Relational Databases - Using SQL Scripts (cont.) 3.1 Use required language on web and database server to create relational database according to confirmed task design. 3.2 Create tables according to required language and ER diagram. 3.3 Populate database fields according to task requirements. 3.4 Test and fix database problems on web and database server. |
Learning Activity 8: Creating, Testing, Debugging, and Searching a Database (Using SQL Scripts)
Work on Assignment Task 2. |
Week 12: Assessment Task 2 (Part B): Prepare to Create and Design Relational Database Due
Week 12: Assessment Task 3: Create and Test Relational Database Released. Due: Week 16, Friday, 5:30 PM |
| Week 13 | 12/05/2025-18/05/2025 | Assessment Task 3: Developing | ||
| Week 14 | 19/05/2025-25/05/2025 |
Part 4: Finalise Relational Databases and Required Documentation 4.1 Determine alignment between represented information and task requirements. 4.2 Confirm and submit all task documentation to required personnel. 4.3 Seek and respond to feedback on task delivery and documentation. 4.4 Save changes and obtain final task sign off from required personnel. |
||
| Week 15 | 26/05/2025 - 1/06/2025 | Assessment Task 3: Finalising | ||
| Week 16 | 2/06/2025-8/06/2025 | Assessment Task 3: Finalising |
Week 16: Assessment Task 3: Create and Test Relational Database Due. Demonstrations/Submissions |
|
| Week 17 | 9/06/2025-15/06/2025 |
Assessment Task 3 Feedback Uncompleted Assessments Resubmissions (if required)
Final Feedback on Student Performance Results Finalised |
Uncompleted Assessments Final Resubmissions | |
| Week 18 | 16/06/2025-22/06/2025 |
Assessment Task 3 Feedback Uncompleted Assessments Resubmissions (if required)
Final Feedback on Student Performance Results Finalised |
Uncompleted Assessments Final Resubmissions |
*Please note that this timeline is subject to change based on semester requirements. We recommend checking your Canvas course shell regularly to stay updated with the latest schedule.
Student directed hours involve completing activities such as reading online resources, assignments, individual student/teacher course-related consultation. Students are required to self-study the learning materials and complete the assigned out of class activities for the scheduled non-teaching hours.
Learning Resources
Prescribed Texts
References
Other Resources
Software Requirements:
Microsoft Office (Word, Access)
Microsoft Visio (To Create ER Diagrams)
XAMPP (MySQL & Web Server) - Open Source Software
Virtual Box- Open Source Software
All required software will be available on classroom computers. It is recommended for students to install the same software on their own laptops/PC at home.
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 and various types of assessments.
Full assessment briefs will be provided and can be found on CANVAS.
Assessment Tasks
Assessment in this course is competency based. In order to be deemed competent for this course, students must satisfactory complete all assessment tasks.
There are three (3) assessment tasks in this course.
Task Number 1: Knowledge Assessment Task - Two Online Quizzes
Task Number 2: Product Assessment Task - Assignment: Prepare to Create and Design Relational Database
Task Number 3: Product Assessment Task - Assignment: Create and Test Relational Database
Assessment Matrix
|
Element |
Performance criteria |
|
|
|
|
|
|
Assessment Task 1: Online Quizzes |
Assessment Task 2: Project |
Assessment Task 3: Project |
|
1. Prepare to create relational database |
1.1 Determine organisational database functionality requirements |
X
|
X |
|
|
1.2 Document organisational database requirements |
X |
X |
|
|
|
1.3 Gather required data according to task requirements |
|
X |
|
|
|
|
1.4 Submit document to required personnel and according to organisational policies and procedures |
|
X |
|
|
|
1.5 Seek and respond to documentation feedback according to organisational policies and procedures |
|
X |
|
|
2. Design relational database
|
2.1 Design entity-relationship (ER) diagram to model relationships between entities, including entity attributes according to functionality requirements |
X |
X |
|
|
2.2 Define primary and foreign keys and implement relationships |
X |
X |
|
|
|
2.3 Normalise database model
|
X |
X |
|
|
|
2.4 Develop data dictionary and detail entity attributes according to functionality requirements |
X |
X |
X |
|
|
2.5 Document ER diagram and data dictionary, including data model, and submit to required personnel |
X |
X |
X |
|
|
|
2.6 Seek feedback from required personnel, and update data model according to feedback |
|
X |
|
|
3. Create relational database |
3.1 Use required language on web and database server to create relational database according to confirmed task design |
X |
|
X |
|
3.2 Create tables according to required language and ER diagram |
|
|
X |
|
|
3.3 Populate database fields according to task requirements |
|
|
X |
|
|
|
3.4 Test and fix database problems on web and database server |
|
|
X |
|
4. Finalise relational database and required documentation |
4.1 Determine alignment between represented information and task requirements |
|
|
X |
|
4.2 Confirm and submit all task documentation to required personnel |
|
|
X |
|
|
|
4.3 Seek and respond to feedback on task delivery and documentation |
|
|
X |
|
|
4.4 Save changes and obtain final task signoff from required personnel |
|
|
X |
Other Information
Credit Transfer and/or Recognition of Prior Learning (RPL):
You may be eligible for credit towards courses in your program if you have already met the learning/competency outcomes through previous learning and/or industry experience. To be eligible for credit towards a course, you must demonstrate that you have already completed learning and/or gained industry experience, that is:• Relevant
• Current
• Satisfies the learning/competency outcomes of the course
To find more information about credit transfer and RPL, please refer to the following link: https://www.rmit.edu.au/students/my-course/enrolment/apply-for-credit
Study and Learning Support:RMIT University Library provides free study support services and resources to help you build your academic skills.
Study and Learning Centre (SLC) provides free learning and academic development advice to you. Services offered by SLC to support your numeracy and literacy skills are:
• Assignment writing, thesis writing and study skills advice
• Math and science developmental support and advice
• English language development
Equitable Learning Services (ELS):
The Equitable Learning Services team (ELS team) supports and creates equal opportunities for students with a disability, long-term illness and/or mental health condition. We also support primary carers.
ELS works in partnership with students to create an Equitable Learning Plan. Your plan is tailored to you, supports your needs and establishes how RMIT can provide ongoing assistance so you can access and participate in your studies. The ELS team can assist you to manage your Equitable Learning Plan.
To find more information about services offered by Equitable Learning Services (ELS), please refer to the following link: https://www.rmit.edu.au/students/support-services/equitable-learning
Extensions and Special Consideration
Extensions:
• Extensions are available for unforeseen circumstances of a short-term nature.
• Applications must be submitted to the school at least one working day before the due date of the assessment.
• Extensions can be approved for up to 7 days past the due date for an assessment. (Where students need an extension exceeding 7 days, they must instead apply for special consideration.)
Special Consideration:
• An application for special consideration is made in advance of an assessment wherever possible, but will normally be accepted within five working days after the assessment date. For more information, see the Special Consideration page of the RMIT website.
Plagiarism:Plagiarism is a form of cheating and it is very serious academic offence that may lead to expulsion from the University.
Please Refer: www.rmit.edu.au/academicintegrity to find more information about plagiarism.
Other Information:
All email communications will be sent to your RMIT email address and you must regularly check your RMIT emails.
Course Overview: Access Course Overview