Course Title: Create basic relational databases

Part B: Course Detail

Teaching Period: Term1 2024

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. 

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: C4410 - Certificate IV in Information Technology

Course Contact: Luke Eberbach

Course Contact Phone: +61 3 9925 4381

Course Contact Email: luke.eberbach@rmit.edu.au

Name and Contact Details of All Other Relevant Staff

Chandra Nannegari

Email: chandra.nannegari@rmit.edu.au

Location: Building 57, Level 5, Room 36

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.

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 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

Semester 1: 2024

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 Activities	Assessments
Week 1 12 Feb (Mon) & Week 2 19 Feb	Course Overview Introduction: General Database Concepts	Learning Activity 1:   Introduction to Relational Databases   Learning Activity 2:  Create a Database in Access	Week 2: Pre-Assessment (Non-assessed)
Week 3 26 Feb & Week 4 04 Mar	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)   Learning Activity 3A: Business Requirements Document (Example)	Week 3: Assessment Task 1: Online Quiz 1 Released
Week 5 11 Mar & Week 6 18 Mar & Week 7 25 Mar	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)   Learning Activity 6: Application of Business Rules to Relationships	Week 5: Assessment Task 1: Online Quiz 1 Due Week 6: Assessment Task 1: Online Quiz 2 Released Week 6: Assessment Task 2: Prepare to Create and Design Relational Database Released
Mid-Semester -  Break 29 March - 7 April
Week 8 08 Apr & Week 9 15 Apr	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 8: Assessment Task 2 (Part A): Prepare to Create and Design Relational Database Due
Week 10 22 Apr	Finalising Assignment Task 2		Week 10: Assessment Task 2 (Part B): Prepare to Create and Design Relational Database Due
Week 11 29 Apr & Week 12 06 May & Week 13 13 May	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. Assessment Task 3: Developing	Learning Activity 8: Creating, Testing, Debugging, and Searching a Database (Using SQL Scripts)	Week 11: Assessment Task 3: Create and Test Relational Database Released
Week 14 20 May	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 27 May	Assessment Task 3: Finalising		Week 15: Assessment Task 3: Create and Test Relational Database Due
Week 16 03 Jun & Week 17 10 Jun	Assessment Task 3 Feedback Uncompleted Assessments Resubmissions (if required)		Week 16 & 17: Uncompleted Assessments Final Resubmissions
Week 18 17 Nov	Final Feedback on Student Performance Results Finalised

 

Learning Resources

Prescribed Texts

Course Online Learning Materials

References

Database Design - 2nd Edition, Adrienne Watt, Online Open Source Book

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, 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

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

 

All three tasks are individual tasks.

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

 

Course Overview: Access Course Overview