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.

SchoolSchool Engineering&Mathematical Sciences

Credit points15

Subject Co-ordinatorRabei Alhadad

Available to Study Abroad StudentsNo

Subject year levelYear Level 2 - UG

Exchange StudentsNo

Subject particulars

Subject rules

Prerequisites Must be admitted into SBACTO or SBAIO and must have passed CSE1ITX.

Co-requisitesN/A

Incompatible subjectsN/A

Equivalent subjectsN/A

Special conditionsN/A

Readings

Resource Type	Title	Resource Requirement	Author and Year	Publisher
Readings	Database Systems: Design, Implementation & Management	Prescribed	Morris. S, & Coronel. C., 2016	CENGAGE Learning, Custom Publishing
Readings	Database Fundamentals on the Cloud	Prescribed	Didasko, 2018	Didasko Digital

Graduate capabilities & intended learning outcomes

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

Activities:: Discussions about the relational model and how it differs from its predecessors (ie: hierarchical) and its successors (Object oriented).

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.

Activities:: Reading materials, and online viewing of multimedia presentations and participation in webinars. Self-checking questions will be incorporated to scaffold learning.

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

Activities:: Demonstrate process of data normalisation via a case study. Microsoft word and other applications can be used.

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.

Activities:: Hands-on skills in implementing a database system on the cloud and setting up the database as a service and writing SQL scripts on a commercial database management system.

Subject options

Select to view your study options…

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 02 - 13
One 3.0 hours unscheduled online class per week on any day including weekend during the day from week 02 to week 13 and delivered via online.

Assessments

Assessment element	Comments	%	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.	15	01, 02
Written assignment on Normalisation (700-words equivalent)	An assignment focused on schema development.	15	03
Written assignment on SQL (2,100-words equivalent)	An assignment that implements and writes SQL scripts on a relational database management system.	50	04
Online test (500-words equivalent)	Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment	20	01, 04

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 06 - 17
One 3.0 hours unscheduled online class per week on any day including weekend during the day from week 06 to week 17 and delivered via online.

Assessments

Assessment element	Comments	%	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.	15	01, 02
Written assignment on Normalisation (700-words equivalent)	An assignment focused on schema development.	15	03
Written assignment on SQL (2,100-words equivalent)	An assignment that implements and writes SQL scripts on a relational database management system.	50	04
Online test (500-words equivalent)	Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment	20	01, 04

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 10 - 21
One 3.0 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	%	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.	15	01, 02
Written assignment on Normalisation (700-words equivalent)	An assignment focused on schema development.	15	03
Written assignment on SQL (2,100-words equivalent)	An assignment that implements and writes SQL scripts on a relational database management system.	50	04
Online test (500-words equivalent)	Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment	20	01, 04

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 15 - 26
One 3.0 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	%	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.	15	01, 02
Written assignment on Normalisation (700-words equivalent)	An assignment focused on schema development.	15	03
Written assignment on SQL (2,100-words equivalent)	An assignment that implements and writes SQL scripts on a relational database management system.	50	04
Online test (500-words equivalent)	Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment	20	01, 04

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 19 - 30
One 3.0 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	%	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.	15	01, 02
Written assignment on Normalisation (700-words equivalent)	An assignment focused on schema development.	15	03
Written assignment on SQL (2,100-words equivalent)	An assignment that implements and writes SQL scripts on a relational database management system.	50	04
Online test (500-words equivalent)	Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment	20	01, 04

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 23 - 34
One 3.0 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	%	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.	15	01, 02
Written assignment on Normalisation (700-words equivalent)	An assignment focused on schema development.	15	03
Written assignment on SQL (2,100-words equivalent)	An assignment that implements and writes SQL scripts on a relational database management system.	50	04
Online test (500-words equivalent)	Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment	20	01, 04

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 28 - 39
One 3.0 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	%	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.	15	01, 02
Written assignment on Normalisation (700-words equivalent)	An assignment focused on schema development.	15	03
Written assignment on SQL (2,100-words equivalent)	An assignment that implements and writes SQL scripts on a relational database management system.	50	04
Online test (500-words equivalent)	Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment	20	01, 04

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 32 - 43
One 3.0 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	%	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.	15	01, 02
Written assignment on Normalisation (700-words equivalent)	An assignment focused on schema development.	15	03
Written assignment on SQL (2,100-words equivalent)	An assignment that implements and writes SQL scripts on a relational database management system.	50	04
Online test (500-words equivalent)	Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment	20	01, 04

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 37 - 48
One 3.0 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	%	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.	15	01, 02
Written assignment on Normalisation (700-words equivalent)	An assignment focused on schema development.	15	03
Written assignment on SQL (2,100-words equivalent)	An assignment that implements and writes SQL scripts on a relational database management system.	50	04
Online test (500-words equivalent)	Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment	20	01, 04

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 41 - 52
One 3.0 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	%	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.	15	01, 02
Written assignment on Normalisation (700-words equivalent)	An assignment focused on schema development.	15	03
Written assignment on SQL (2,100-words equivalent)	An assignment that implements and writes SQL scripts on a relational database management system.	50	04
Online test (500-words equivalent)	Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment	20	01, 04

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 45
One 3.0 hours unscheduled online class per week on weekdays during the day in week 45 and delivered via online.

Assessments

Assessment element	Comments	%	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.	15	01, 02
Written assignment on Normalisation (700-words equivalent)	An assignment focused on schema development.	15	03
Written assignment on SQL (2,100-words equivalent)	An assignment that implements and writes SQL scripts on a relational database management system.	50	04
Online test (500-words equivalent)	Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment	20	01, 04

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 50
One 3.0 hours unscheduled online class per week on weekdays during the day in week 50 and delivered via online.

Assessments

Assessment element	Comments	%	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.	15	01, 02
Written assignment on Normalisation (700-words equivalent)	An assignment focused on schema development.	15	03
Written assignment on SQL (2,100-words equivalent)	An assignment that implements and writes SQL scripts on a relational database management system.	50	04
Online test (500-words equivalent)	Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment	20	01, 04