DATABASE FUNDAMENTALS ON THE CLOUD
CSE2DCX
2021
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.
SchoolEngineering and Mathematical Sciences
Credit points15
Subject Co-ordinatorRabei Alhadad
Available to Study Abroad/Exchange StudentsNo
Subject year levelYear Level 2 - UG
Available as ElectiveNo
Learning ActivitiesN/A
Capstone subjectNo
Subject particulars
Subject rules
PrerequisitesCSE1ITX
Students must be admitted in one of the following courses: SBAIO, SBACTO
Co-requisitesN/A
Incompatible subjectsN/A
Equivalent subjectsN/A
Quota Management StrategyN/A
Quota-conditions or rulesN/A
Special conditionsN/A
Minimum credit point requirementN/A
Assumed knowledgeN/A
Readings
Database Fundamentals on the Cloud
Resource TypePrescribed
Resource RequirementN/A
AuthorDidasko
Year2018
Edition/VolumeN/A
PublisherDidasko Digital
ISBNN/A
Chapter/article titleN/A
Chapter/issueN/A
URLN/A
Other descriptionN/A
Source locationN/A
Database Systems: Design, Implementation & Management
Resource TypePrescribed
Resource RequirementN/A
AuthorMorris. S, & Coronel. C.
Year2016
Edition/VolumeN/A
PublisherCENGAGE Learning, Custom Publishing
ISBNN/A
Chapter/article titleN/A
Chapter/issueN/A
URLN/A
Other descriptionN/A
Source locationN/A
Career Ready
Career-focusedNo
Work-based learningNo
Self sourced or Uni sourcedN/A
Entire subject or partial subjectN/A
Total hours/days requiredN/A
Location of WBL activity (region)N/A
WBL addtional requirementsN/A
Graduate capabilities & intended learning outcomes
Graduate Capabilities
Intended Learning Outcomes
Subject options
Select to view your study options…
Online (Didasko), 2021, Study block 1, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorRabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 2 - 13
One 3.00 h 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 | 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 | No | 15 | SILO1, SILO2 |
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development. | 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 | 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 | No | 20 | SILO1, SILO4 |
Online (Didasko), 2021, Study block 10, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorRabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 41 - 52
One 3.00 h unscheduled online class per week on weekdays during the day from week 41 to week 52 and delivered via online.
Assessments
| Assessment element | 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 | No | 15 | SILO1, SILO2 |
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development. | 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 | 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 | No | 20 | SILO1, SILO4 |
Online (Didasko), 2021, Study block 11, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorRabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 45 - 0
One 3.00 h unscheduled online class per week on weekdays during the day from week 45 to week 0 and delivered via online.
Assessments
| Assessment element | 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 | No | 15 | SILO1, SILO2 |
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development. | 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 | 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 | No | 20 | SILO1, SILO4 |
Online (Didasko), 2021, Study block 12, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorRabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 50 - 0
One 3.00 h unscheduled online class per week on weekdays during the day from week 50 to week 0 and delivered via online.
Assessments
| Assessment element | 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 | No | 15 | SILO1, SILO2 |
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development. | 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 | 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 | No | 20 | SILO1, SILO4 |
Online (Didasko), 2021, Study block 2, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorRabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 6 - 17
One 3.00 h 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 | 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 | No | 15 | SILO1, SILO2 |
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development. | 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 | 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 | No | 20 | SILO1, SILO4 |
Online (Didasko), 2021, Study block 3, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorRabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 10 - 21
One 3.00 h 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 | 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 | No | 15 | SILO1, SILO2 |
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development. | 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 | 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 | No | 20 | SILO1, SILO4 |
Online (Didasko), 2021, Study block 4, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorRabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 15 - 26
One 3.00 h 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 | 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 | No | 15 | SILO1, SILO2 |
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development. | 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 | 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 | No | 20 | SILO1, SILO4 |
Online (Didasko), 2021, Study block 5, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorRabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 19 - 30
One 3.00 h 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 | 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 | No | 15 | SILO1, SILO2 |
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development. | 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 | 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 | No | 20 | SILO1, SILO4 |
Online (Didasko), 2021, Study block 6, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorRabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 23 - 34
One 3.00 h 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 | 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 | No | 15 | SILO1, SILO2 |
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development. | 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 | 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 | No | 20 | SILO1, SILO4 |
Online (Didasko), 2021, Study block 7, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorRabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 28 - 39
One 3.00 h unscheduled online class per week on weekdays during the day from week 28 to week 39 and delivered via online.
Assessments
| Assessment element | 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 | No | 15 | SILO1, SILO2 |
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development. | 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 | 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 | No | 20 | SILO1, SILO4 |
Online (Didasko), 2021, Study block 8, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorRabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 32 - 43
One 3.00 h unscheduled online class per week on weekdays during the day from week 32 to week 43 and delivered via online.
Assessments
| Assessment element | 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 | No | 15 | SILO1, SILO2 |
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development. | 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 | 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 | No | 20 | SILO1, SILO4 |
Online (Didasko), 2021, Study block 9, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorRabei Alhadad
Class requirements
Unscheduled Online ClassWeek: 37 - 48
One 3.00 h unscheduled online class per week on weekdays during the day from week 37 to week 48 and delivered via online.
Assessments
| Assessment element | 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 | No | 15 | SILO1, SILO2 |
Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development. | 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 | 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 | No | 20 | SILO1, SILO4 |