Course Title: Create basic relational databases

Part B: Course Detail

Teaching Period: Term2 2022

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

Course Coordinator

Email: dalija.beganovic@rmit.edu.au

Ph. 9925 4664

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 4. Finalise relational database 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 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 above elements.

Details of Learning Activities

This unit describes the skills and knowledge required to design, develop and test relational databases to meet specifications.

It applies to individuals who are database support staff, application programmers and web designers who are required to create a simple database to store information for an online, desktop, web or mobile device application, using a simple entity relational database on a web or database server environment.

Teaching Schedule

 

Week	Topic
1	Analyse the requirements for the database (1) Determine the information that the database is required to hold Introduction to databases Principles of open platforms Xampp, HeidiSQl, W3Schools
2	Analyse the requirements for the database (2) Develop a written requirement report for the functionality of the database Entities, Attributes, Relationships Microsoft Visio Online Quiz 1: (Due Week 3) Practical task 1
3	Analyse the requirements for the database (3) 1.3 Complete the documentation, and submit it to the appropriate person for approval. Business rules, Cardinality, Participation Practical task 2 Assignment 1: (Due Week 5)
4	Use data modelling for design (1) 2.1 Design an entity-relationship (ER) diagram to model the relationships between the entities and the attributes that the database will hold Normalization Database redundancies Practical task 3
5	Use data modelling for design (2) 2.2 Develop primary and foreign keys to link the entities Keys, Constraints Practical task 4
6	Use data modelling for design (3) 2.3 Develop a data dictionary Database schemas Naming conventions Practical task 5 Assignment 2: (Due Week 10)
7	Create a database on a web or database server (1) 3.1 Use the appropriate language on a web or database server to create one or more databases SQL syntax Practical task 6 Online Quiz 2: (Due Week 8)
8	Create a database on a web or database server (2) Naming conventions 3.2 Use the appropriate language on a web or database server to create tables SQL syntax (cont). Practical task 7
9	Create a database on a web or database server (3) Populate the database fields HeidiSQL, Xampp Scripting Practical task 8
10	Test the database and debug Test the database on the web or database server Xampp, Internet Browsers Internet operation Practical task 9
11	Test the database and debug Ensure that the information represented matches the requirements Practical task 10
12	Assignment 3: released (Due Week 16)
13	Security restrictions Assignment 3:
14	Communication, accessibility (including audiences with special needs), Assignment 3: Online Quiz 3: (Due Week 15)
15	Assignment 3:
16	Assignment 3 due
17	Resubmissions
18	Completing Program materials

 

Learning Resources

Prescribed Texts

References

Other Resources

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	Online Quizzes
Task 2	Practical Assessment
Task 3	Assignment

 

Assessment Matrix

Element	Performance criteria
		Assessment Task 1: Online Quizzes	Assessment Task 2: Practical Assessment	Assessment Task 3: Assignment
1. Prepare to create relational database	1.1 Determine organisational database functionality requirements	X	X	X
1.2 Document organisational database requirements	X	X	X
1.3 Gather required data according to task requirements	X	X	X
	1.4 Submit document to required personnel and according to organisational policies and procedures		X	X
	1.5 Seek and respond to documentation feedback according to organisational policies and procedures		X	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	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
2.5 Document ER diagram and data dictionary, including data model, and submit to required personnel		X	X
	2.6 Seek feedback from required personnel, and update data model according to feedback		X	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	X	X
3.3 Populate database fields according to task requirements		X	X
	3.4 Test and fix database problems on web and database server		X	X
4. Finalise relational database and required documentation	4.1 Determine alignment between represented information and task requirements		X	X
4.2 Confirm and submit all task documentation to required personnel		X	X
	4.3 Seek and respond to feedback on task delivery and documentation		X	X
	4.4 Save changes and obtain final task signoff from required personnel		X	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

Please refer to http://www.rmit.edu.au/students/enrolment/credit to find more information about credit transfer and RPL

Study and learning Support:

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 
• maths and science developmental support and advice 
• English language development 

Please Refer http://www.rmit.edu.au/studyandlearningcentre to find more information about Study and learning Support 

Equitable Learning Services (ELS):

If you are suffering from long-term medical condition or disability, you should contact Equitable Learning Services (ELS) to seek advice and support to complete your studies.
Please refer to https://www.rmit.edu.au/students/support-and-facilities/student-support/equitable-learning-services to find more information about services offered by Equitable Learning Services (ELS).

Late submission: 

If you require an Extension of Submittable Work (assignments, reports or project work etc.) for 7 calendar days or less (from the original due date) and have valid reasons, you must complete and lodge an Application for Extension of Submittable Work (7 Calendar Days or less) form and lodge it with the Senior Educator/ Program Manager. 
The application must be lodged no later than one working day before the official due date. You will be notified within no more than 2 working days of the date of lodgment as to whether the extension has been granted. 
If you seek an Extension of Submittable Work for more than 7 calendar days (from the original due date) must lodge an Application for Special Consideration form under the provisions of the Special Consideration Policy, preferably prior to, but no later than 2 working days after the official due date. 

Submittable Work (assignments, reports or project work etc.) submitted late without approval of an extension will not be accepted or assessed.


Special consideration: 

Please Refer http://www.rmit.edu.au/students/specialconsideration to find more information about special consideration 

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