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.
School: School Engineering&Mathematical Sciences
Credit points: 15
Subject Co-ordinator: Rabei Alhadad
Available to Study Abroad Students: No
Subject year level: Year Level 2 - UG
Exchange Students: No
Subject particulars
Subject rules
Prerequisites: Must be admitted into SBACTO or SBAIO and must have passed CSE1ITX.
Co-requisites: N/A
Incompatible subjects: N/A
Equivalent subjects: N/A
Special conditions: N/A
Learning resources
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 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
Online (Didasko), 2019, Study Block 1, Online
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Rabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 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 (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 assessment | 10 | 05 |
| Written assignment on cloud database management system (1,100-words equivalent) | An assignment focused on cloud database management system | 25 | 05, 06 |
Online (Didasko), 2019, Study Block 2, Online
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Rabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 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 (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 assessment | 10 | 05 |
| Written assignment on cloud database management system (1,100-words equivalent) | An assignment focused on cloud database management system | 25 | 05, 06 |
Online (Didasko), 2019, Study Block 3, Online
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Rabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 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 (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 assessment | 10 | 05 |
| Written assignment on cloud database management system (1,100-words equivalent) | An assignment focused on cloud database management system | 25 | 05, 06 |
Online (Didasko), 2019, Study Block 4, Online
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Rabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 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 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 (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 assessment | 10 | 05 |
| Written assignment on cloud database management system (1,100-words equivalent) | An assignment focused on cloud database management system | 25 | 05, 06 |
Online (Didasko), 2019, Study Block 5, Online
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Rabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 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 (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 assessment | 10 | 05 |
| Written assignment on cloud database management system (1,100-words equivalent) | An assignment focused on cloud database management system | 25 | 05, 06 |
Online (Didasko), 2019, Study Block 6, Online
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Rabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 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 (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 assessment | 10 | 05 |
| Written assignment on cloud database management system (1,100-words equivalent) | An assignment focused on cloud database management system | 25 | 05, 06 |
Online (Didasko), 2019, Study Block 7, Online
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Rabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 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 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 (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 assessment | 10 | 05 |
| Written assignment on cloud database management system (1,100-words equivalent) | An assignment focused on cloud database management system | 25 | 05, 06 |
Online (Didasko), 2019, Study Block 8, Online
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Rabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 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 (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 assessment | 10 | 05 |
| Written assignment on cloud database management system (1,100-words equivalent) | An assignment focused on cloud database management system | 25 | 05, 06 |
Online (Didasko), 2019, Study Block 9, Online
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Rabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 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 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 (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 assessment | 10 | 05 |
| Written assignment on cloud database management system (1,100-words equivalent) | An assignment focused on cloud database management system | 25 | 05, 06 |
Online (Didasko), 2019, Study Block 10, Online
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Rabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 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 (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 assessment | 10 | 05 |
| Written assignment on cloud database management system (1,100-words equivalent) | An assignment focused on cloud database management system | 25 | 05, 06 |
Online (Didasko), 2019, Study Block 11, Online
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Rabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 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 (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 assessment | 10 | 05 |
| Written assignment on cloud database management system (1,100-words equivalent) | An assignment focused on cloud database management system | 25 | 05, 06 |
Online (Didasko), 2019, Study Block 12, Online
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: Rabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 49
One 3.0 hours unscheduled online class per week on weekdays during the day in week 49 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 (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 assessment | 10 | 05 |
| Written assignment on cloud database management system (1,100-words equivalent) | An assignment focused on cloud database management system | 25 | 05, 06 |