DATABASE FUNDAMENTALS ON THE CLOUD

CSE2DCX

2020

Credit points: 15

Subject outline

To operate effectively within any information system, an understanding of the theory and practice of database management systems is essential. This subject is designed to deepen students' interest and expertise in databases in general with a focus on cloud databases. A cloud database stores/processes data on the cloud. We start by looking at how database systems have evolved. The subject is mainly concerned with the relational data model and students learn the basics of database design using entity-relationship diagrams and how this design can then be mapped onto the relational model. A significant part of the subject is devoted to the use of structured query language (SQL). A commercial database management system will be used throughout the subject to provide hands-on skills. Foundations of normalising as well as data security will also be discussed.

School: Engineering and Mathematical Sciences (Pre 2022)

Credit points: 15

Subject Co-ordinator: Rabei Alhadad

Available to Study Abroad/Exchange Students: No

Subject year level: Year Level 2 - UG

Exchange Students: No

Available as Elective: No

Learning Activities: N/A

Capstone subject: No

Subject particulars

Subject rules

Prerequisites: CSE1ITX
Students must be admitted in one of the following courses: SBAIO, SBACTO

Co-requisites: N/A

Incompatible subjects: N/A

Equivalent subjects: N/A

Quota Management Strategy: N/A

Quota-conditions or rules: N/A

Special conditions: N/A

Minimum credit point requirement: N/A

Assumed knowledge: N/A

Learning resources

Database Fundamentals on the Cloud

Resource Type: Book

Resource Requirement: Prescribed

Author: Didasko

Year: 2018

Edition/Volume: N/A

Publisher: Didasko Digital

ISBN: N/A

Chapter/article title: N/A

Chapter/issue: N/A

URL: N/A

Other description: N/A

Source location: N/A

Database Systems: Design, Implementation & Management

Resource Type: Book

Resource Requirement: Prescribed

Author: Morris. S, & Coronel. C.

Year: 2016

Edition/Volume: N/A

Publisher: CENGAGE Learning, Custom Publishing

ISBN: N/A

Chapter/article title: N/A

Chapter/issue: N/A

URL: N/A

Other description: N/A

Source location: N/A

Career Ready

Career-focused: No

Work-based learning: No

Self sourced or Uni sourced: N/A

Entire subject or partial subject: N/A

Total hours/days required: N/A

Location of WBL activity (region): N/A

WBL addtional requirements: N/A

Graduate capabilities & intended learning outcomes

Graduate Capabilities

Intended Learning Outcomes

01. Apply the relational database model as a design tool and as a structure for a database management system.

02. Apply a database modelling technique using an ER and EER diagram, and use a transformation process to change these to a relational database design.

03. Identify the appropriate normalisation techniques for database design and apply it in a business case.

04. Implement a database system on the cloud to provide delivery of computing as a service using SQL and apply the relevant knowledge in database management and administration.

Online (Didasko), 2020, Study block 1, Online

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Rabei Alhadad

Class requirements

Unscheduled Online ClassWeek: 2 - 13
One 3.00 hours unscheduled online class per week on any day including weekend during the day from week 2 to week 13 and delivered via online.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Written assignment on Relational Model and ER diagrams(700-words equivalent)A report that covers ER/EER diagram and maps to a relational model.	N/A	N/A	N/A	No	15	SILO1, SILO2
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.	N/A	N/A	N/A	No	15	SILO3
Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.	N/A	N/A	N/A	No	50	SILO4
Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment	N/A	N/A	N/A	No	20	SILO1, SILO4

Online (Didasko), 2020, Study block 10, Online

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Rabei Alhadad

Class requirements

Unscheduled Online ClassWeek: 41 - 52
One 3.00 hours unscheduled online class per week on weekdays during the day from week 41 to week 52 and delivered via online.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Written assignment on Relational Model and ER diagrams(700-words equivalent)A report that covers ER/EER diagram and maps to a relational model.	N/A	N/A	N/A	No	15	SILO1, SILO2
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.	N/A	N/A	N/A	No	15	SILO3
Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.	N/A	N/A	N/A	No	50	SILO4
Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment	N/A	N/A	N/A	No	20	SILO1, SILO4

Online (Didasko), 2020, Study block 11, Online

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Rabei Alhadad

Class requirements

Unscheduled Online ClassWeek: 45 - 0
One 3.00 hours unscheduled online class per week on weekdays during the day from week 45 to week 0 and delivered via online.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Written assignment on Relational Model and ER diagrams(700-words equivalent)A report that covers ER/EER diagram and maps to a relational model.	N/A	N/A	N/A	No	15	SILO1, SILO2
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.	N/A	N/A	N/A	No	15	SILO3
Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.	N/A	N/A	N/A	No	50	SILO4
Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment	N/A	N/A	N/A	No	20	SILO1, SILO4

Online (Didasko), 2020, Study block 12, Online

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Rabei Alhadad

Class requirements

Unscheduled Online ClassWeek: 50 - 0
One 3.00 hours unscheduled online class per week on weekdays during the day from week 50 to week 0 and delivered via online.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Written assignment on Relational Model and ER diagrams(700-words equivalent)A report that covers ER/EER diagram and maps to a relational model.	N/A	N/A	N/A	No	15	SILO1, SILO2
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.	N/A	N/A	N/A	No	15	SILO3
Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.	N/A	N/A	N/A	No	50	SILO4
Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment	N/A	N/A	N/A	No	20	SILO1, SILO4

Online (Didasko), 2020, Study block 2, Online

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Rabei Alhadad

Class requirements

Unscheduled Online ClassWeek: 6 - 17
One 3.00 hours unscheduled online class per week on any day including weekend during the day from week 6 to week 17 and delivered via online.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Written assignment on Relational Model and ER diagrams(700-words equivalent)A report that covers ER/EER diagram and maps to a relational model.	N/A	N/A	N/A	No	15	SILO1, SILO2
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.	N/A	N/A	N/A	No	15	SILO3
Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.	N/A	N/A	N/A	No	50	SILO4
Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment	N/A	N/A	N/A	No	20	SILO1, SILO4

Online (Didasko), 2020, Study block 3, Online

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Rabei Alhadad

Class requirements

Unscheduled Online ClassWeek: 10 - 21
One 3.00 hours unscheduled online class per week on any day including weekend during the day from week 10 to week 21 and delivered via online.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Written assignment on Relational Model and ER diagrams(700-words equivalent)A report that covers ER/EER diagram and maps to a relational model.	N/A	N/A	N/A	No	15	SILO1, SILO2
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.	N/A	N/A	N/A	No	15	SILO3
Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.	N/A	N/A	N/A	No	50	SILO4
Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment	N/A	N/A	N/A	No	20	SILO1, SILO4

Online (Didasko), 2020, Study block 4, Online

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Rabei Alhadad

Class requirements

Unscheduled Online ClassWeek: 15 - 26
One 3.00 hours unscheduled online class per week on any day including weekend during the day from week 15 to week 26 and delivered via online.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Written assignment on Relational Model and ER diagrams(700-words equivalent)A report that covers ER/EER diagram and maps to a relational model.	N/A	N/A	N/A	No	15	SILO1, SILO2
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.	N/A	N/A	N/A	No	15	SILO3
Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.	N/A	N/A	N/A	No	50	SILO4
Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment	N/A	N/A	N/A	No	20	SILO1, SILO4

Online (Didasko), 2020, Study block 5, Online

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Rabei Alhadad

Class requirements

Unscheduled Online ClassWeek: 19 - 30
One 3.00 hours unscheduled online class per week on any day including weekend during the day from week 19 to week 30 and delivered via online.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Written assignment on Relational Model and ER diagrams(700-words equivalent)A report that covers ER/EER diagram and maps to a relational model.	N/A	N/A	N/A	No	15	SILO1, SILO2
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.	N/A	N/A	N/A	No	15	SILO3
Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.	N/A	N/A	N/A	No	50	SILO4
Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment	N/A	N/A	N/A	No	20	SILO1, SILO4

Online (Didasko), 2020, Study block 6, Online

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Rabei Alhadad

Class requirements

Unscheduled Online ClassWeek: 23 - 34
One 3.00 hours unscheduled online class per week on any day including weekend during the day from week 23 to week 34 and delivered via online.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Written assignment on Relational Model and ER diagrams(700-words equivalent)A report that covers ER/EER diagram and maps to a relational model.	N/A	N/A	N/A	No	15	SILO1, SILO2
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.	N/A	N/A	N/A	No	15	SILO3
Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.	N/A	N/A	N/A	No	50	SILO4
Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment	N/A	N/A	N/A	No	20	SILO1, SILO4

Online (Didasko), 2020, Study block 7, Online

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Rabei Alhadad

Class requirements

Unscheduled Online ClassWeek: 28 - 39
One 3.00 hours unscheduled online class per week on weekdays during the day from week 28 to week 39 and delivered via online.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Written assignment on Relational Model and ER diagrams(700-words equivalent)A report that covers ER/EER diagram and maps to a relational model.	N/A	N/A	N/A	No	15	SILO1, SILO2
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.	N/A	N/A	N/A	No	15	SILO3
Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.	N/A	N/A	N/A	No	50	SILO4
Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment	N/A	N/A	N/A	No	20	SILO1, SILO4

Online (Didasko), 2020, Study block 8, Online

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Rabei Alhadad

Class requirements

Unscheduled Online ClassWeek: 32 - 43
One 3.00 hours unscheduled online class per week on weekdays during the day from week 32 to week 43 and delivered via online.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Written assignment on Relational Model and ER diagrams(700-words equivalent)A report that covers ER/EER diagram and maps to a relational model.	N/A	N/A	N/A	No	15	SILO1, SILO2
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.	N/A	N/A	N/A	No	15	SILO3
Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.	N/A	N/A	N/A	No	50	SILO4
Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment	N/A	N/A	N/A	No	20	SILO1, SILO4

Online (Didasko), 2020, Study block 9, Online

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Rabei Alhadad

Class requirements

Unscheduled Online ClassWeek: 37 - 48
One 3.00 hours unscheduled online class per week on weekdays during the day from week 37 to week 48 and delivered via online.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Written assignment on Relational Model and ER diagrams(700-words equivalent)A report that covers ER/EER diagram and maps to a relational model.	N/A	N/A	N/A	No	15	SILO1, SILO2
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.	N/A	N/A	N/A	No	15	SILO3
Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.	N/A	N/A	N/A	No	50	SILO4
Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment	N/A	N/A	N/A	No	20	SILO1, SILO4