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

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.

Subject options

Select to view your study options…

Start date between: and    Key dates

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 elementCommentsCategoryContributionHurdle% 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/AN/AN/ANo15 SILO1, SILO2

Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.

N/AN/AN/ANo15 SILO3

Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.

N/AN/AN/ANo50 SILO4

Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment

N/AN/AN/ANo20 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 elementCommentsCategoryContributionHurdle% 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/AN/AN/ANo15 SILO1, SILO2

Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.

N/AN/AN/ANo15 SILO3

Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.

N/AN/AN/ANo50 SILO4

Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment

N/AN/AN/ANo20 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 elementCommentsCategoryContributionHurdle% 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/AN/AN/ANo15 SILO1, SILO2

Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.

N/AN/AN/ANo15 SILO3

Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.

N/AN/AN/ANo50 SILO4

Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment

N/AN/AN/ANo20 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 elementCommentsCategoryContributionHurdle% 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/AN/AN/ANo15 SILO1, SILO2

Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.

N/AN/AN/ANo15 SILO3

Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.

N/AN/AN/ANo50 SILO4

Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment

N/AN/AN/ANo20 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 elementCommentsCategoryContributionHurdle% 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/AN/AN/ANo15 SILO1, SILO2

Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.

N/AN/AN/ANo15 SILO3

Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.

N/AN/AN/ANo50 SILO4

Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment

N/AN/AN/ANo20 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 elementCommentsCategoryContributionHurdle% 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/AN/AN/ANo15 SILO1, SILO2

Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.

N/AN/AN/ANo15 SILO3

Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.

N/AN/AN/ANo50 SILO4

Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment

N/AN/AN/ANo20 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 elementCommentsCategoryContributionHurdle% 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/AN/AN/ANo15 SILO1, SILO2

Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.

N/AN/AN/ANo15 SILO3

Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.

N/AN/AN/ANo50 SILO4

Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment

N/AN/AN/ANo20 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 elementCommentsCategoryContributionHurdle% 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/AN/AN/ANo15 SILO1, SILO2

Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.

N/AN/AN/ANo15 SILO3

Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.

N/AN/AN/ANo50 SILO4

Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment

N/AN/AN/ANo20 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 elementCommentsCategoryContributionHurdle% 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/AN/AN/ANo15 SILO1, SILO2

Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.

N/AN/AN/ANo15 SILO3

Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.

N/AN/AN/ANo50 SILO4

Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment

N/AN/AN/ANo20 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 elementCommentsCategoryContributionHurdle% 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/AN/AN/ANo15 SILO1, SILO2

Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.

N/AN/AN/ANo15 SILO3

Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.

N/AN/AN/ANo50 SILO4

Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment

N/AN/AN/ANo20 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 elementCommentsCategoryContributionHurdle% 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/AN/AN/ANo15 SILO1, SILO2

Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.

N/AN/AN/ANo15 SILO3

Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.

N/AN/AN/ANo50 SILO4

Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment

N/AN/AN/ANo20 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 elementCommentsCategoryContributionHurdle% 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/AN/AN/ANo15 SILO1, SILO2

Written assignment on Normalisation (700-words equivalent)An assignment focused on schema development.

N/AN/AN/ANo15 SILO3

Written assignment on SQL (2,100-words equivalent)An assignment that implements and writes SQL scripts on a relational database management system.

N/AN/AN/ANo50 SILO4

Online test (500-words equivalent)Multiple-choice and/or short answer questions on fundamentals of cloud databases.Timed assessment

N/AN/AN/ANo20 SILO1, SILO4