DATABASE FUNDAMENTALS ON THE CLOUD

CSE2DCX

2019

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 TypeTitleResource RequirementAuthor and YearPublisher
ReadingsDatabase Systems: Design, Implementation & ManagementPrescribedMorris. S, & Coronel. C., 2016CENGAGE Learning, Custom Publishing
ReadingsDatabase Fundamentals on the CloudPrescribedDidasko, 2018Didasko 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 using SQL and apply the relevant knowledge in database management and administration.

Activities:
Hands-on skills in implementing a database system and writing SQL scripts on a commercial database management system.

05. Create business cases for application to cloud databases.

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

06. Implement a cloud database management system to provide delivery of computing as a service

Activities:
Hands-on skills in setting up the database service and running queries on cloud databases

Subject options

Select to view your study options…

Start date between: and    Key dates

Online (Didasko), 2019, 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 elementComments% 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 (450-words equivalent)An assignment focused on schema development.10 03
Written assignment on SQL (1,800-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.40 04
Online test (250-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment10 05
Written assignment on cloud database management system (1,100-words equivalent)An assignment focused on cloud database management system25 05, 06

Online (Didasko), 2019, 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 elementComments% 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 (450-words equivalent)An assignment focused on schema development.10 03
Written assignment on SQL (1,800-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.40 04
Online test (250-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment10 05
Written assignment on cloud database management system (1,100-words equivalent)An assignment focused on cloud database management system25 05, 06

Online (Didasko), 2019, 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 elementComments% 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 (450-words equivalent)An assignment focused on schema development.10 03
Written assignment on SQL (1,800-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.40 04
Online test (250-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment10 05
Written assignment on cloud database management system (1,100-words equivalent)An assignment focused on cloud database management system25 05, 06

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

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

Assessments

Assessment elementComments% 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 (450-words equivalent)An assignment focused on schema development.10 03
Written assignment on SQL (1,800-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.40 04
Online test (250-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment10 05
Written assignment on cloud database management system (1,100-words equivalent)An assignment focused on cloud database management system25 05, 06

Online (Didasko), 2019, 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 elementComments% 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 (450-words equivalent)An assignment focused on schema development.10 03
Written assignment on SQL (1,800-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.40 04
Online test (250-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment10 05
Written assignment on cloud database management system (1,100-words equivalent)An assignment focused on cloud database management system25 05, 06

Online (Didasko), 2019, 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 elementComments% 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 (450-words equivalent)An assignment focused on schema development.10 03
Written assignment on SQL (1,800-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.40 04
Online test (250-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment10 05
Written assignment on cloud database management system (1,100-words equivalent)An assignment focused on cloud database management system25 05, 06

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 27 - 38
One 3.0 hours unscheduled online class per week on weekdays during the day from week 27 to week 38 and delivered via online.

Assessments

Assessment elementComments% 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 (450-words equivalent)An assignment focused on schema development.10 03
Written assignment on SQL (1,800-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.40 04
Online test (250-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment10 05
Written assignment on cloud database management system (1,100-words equivalent)An assignment focused on cloud database management system25 05, 06

Online (Didasko), 2019, 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 elementComments% 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 (450-words equivalent)An assignment focused on schema development.10 03
Written assignment on SQL (1,800-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.40 04
Online test (250-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment10 05
Written assignment on cloud database management system (1,100-words equivalent)An assignment focused on cloud database management system25 05, 06

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

Unscheduled Online Class Week: 36 - 47
One 3.0 hours unscheduled online class per week on weekdays during the day from week 36 to week 47 and delivered via online.

Assessments

Assessment elementComments% 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 (450-words equivalent)An assignment focused on schema development.10 03
Written assignment on SQL (1,800-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.40 04
Online test (250-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment10 05
Written assignment on cloud database management system (1,100-words equivalent)An assignment focused on cloud database management system25 05, 06

Online (Didasko), 2019, 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 elementComments% 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 (450-words equivalent)An assignment focused on schema development.10 03
Written assignment on SQL (1,800-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.40 04
Online test (250-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment10 05
Written assignment on cloud database management system (1,100-words equivalent)An assignment focused on cloud database management system25 05, 06

Online (Didasko), 2019, 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 elementComments% 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 (450-words equivalent)An assignment focused on schema development.10 03
Written assignment on SQL (1,800-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.40 04
Online test (250-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment10 05
Written assignment on cloud database management system (1,100-words equivalent)An assignment focused on cloud database management system25 05, 06

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorRabei Alhadad

Class requirements

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

Assessments

Assessment elementComments% 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 (450-words equivalent)An assignment focused on schema development.10 03
Written assignment on SQL (1,800-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.40 04
Online test (250-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases. Timed assessment10 05
Written assignment on cloud database management system (1,100-words equivalent)An assignment focused on cloud database management system25 05, 06