DATABASE FUNDAMENTALS

CSE2DBX

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 your interest and expertise in this area. We start by looking at how database systems have evolved. The subject is focused on 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 relation 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 implementing security will also be discussed. Several commercial directions in database use such as distributed databases, NoSQL and data warehousing also form part of the discussions.

SchoolEngineering and Mathematical Sciences

Credit points15

Subject Co-ordinatorEric Pardede

Available to Study Abroad/Exchange StudentsNo

Subject year levelYear Level 2 - UG

Available as ElectiveNo

Learning ActivitiesN/A

Capstone subjectNo

Subject particulars

Subject rules

Prerequisites Students must be admitted in the following course: SBAIO

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 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

Database fundamentals learning guide

Resource TypePrescribed

Resource RequirementN/A

AuthorComputer Power Institute

Year2016

Edition/VolumeN/A

PublisherDidasko Digital

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. Explain the functions of a database and show how a database meets the information needs of management.
02. Apply the relational database model as a design tool and as a structure for a database management system.
03. Develop ER/EER diagrams to model data requirements and mapping them to the relational model.
04. Create queries using standard Structured Query Language (SQL).
05. Apply the principles of normalization to a problem in order to reduce data redundancy and improve data integrity.
06. Explain how security is implemented in database system.
07. Explain commercial directions in database use, including client-server models, distributed databases, NoSQL and data warehousing.

Subject options

Select to view your study options…

Start date between: and    Key dates

Online (Didasko), 2021, Study block 1, Online

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorEric Pardede

Class requirements

Unscheduled Online ClassWeek: 0 - 0
One 3.00 h unscheduled online class per week on any day including weekend during the day from week 0 to week 0 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Laboratory report about Database Management System (DBMS) development (equivalent to 450-words)Database tables and queries need to be created on a SQL Server environment as stored procedures.

N/AN/AN/ANo10 SILO1, SILO2, SILO4

Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model

N/AN/AN/ANo10 SILO3

Advanced Database research report (equivalent to 1,000-words)Research and report on an advanced database topic. Individual topics provided during the 6th week of teaching.

N/AN/AN/ANo20 SILO7

Written laboratory report (500-words) and Oral presentation (5-mins) (total 1,000-words)Students use a DBMS to write actual queries and submit a lab report. Students are subsequently asked to verbally respond to questions about their report (5 minute oral).

N/AN/AN/ANo20 SILO1, SILO2, SILO4

One 1.5-hour exam delivered via the Learning Management System (equivalent to 1,500-words)LMS security mechanisms (specific IP addresses, password protection, time limited) will be used for security. Teacher graded online exam. Short answer and essay questions delivered via LMS. The exam is timed.

N/AN/AN/ANo40 SILO1, SILO4, SILO5, SILO6

Online (Didasko), 2021, Study block 10, Online

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorEric Pardede

Class requirements

Unscheduled Online ClassWeek: 0 - 0
One 3.00 h unscheduled online class per week on any day including weekend during the day from week 0 to week 0 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Laboratory report about Database Management System (DBMS) development (equivalent to 450-words)Database tables and queries need to be created on a SQL Server environment as stored procedures.

N/AN/AN/ANo10 SILO1, SILO2, SILO4

Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model

N/AN/AN/ANo10 SILO3

Advanced Database research report (equivalent to 1,000-words)Research and report on an advanced database topic. Individual topics provided during the 6th week of teaching.

N/AN/AN/ANo20 SILO7

Written laboratory report (500-words) and Oral presentation (5-mins) (total 1,000-words)Students use a DBMS to write actual queries and submit a lab report. Students are subsequently asked to verbally respond to questions about their report (5 minute oral).

N/AN/AN/ANo20 SILO1, SILO2, SILO4

One 1.5-hour exam delivered via the Learning Management System (equivalent to 1,500-words)LMS security mechanisms (specific IP addresses, password protection, time limited) will be used for security. Teacher graded online exam. Short answer and essay questions delivered via LMS. The exam is timed.

N/AN/AN/ANo40 SILO1, SILO4, SILO5, SILO6

Online (Didasko), 2021, Study block 11, Online

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorEric Pardede

Class requirements

Unscheduled Online ClassWeek: 0 - 0
One 3.00 h unscheduled online class per week on any day including weekend during the day from week 0 to week 0 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Laboratory report about Database Management System (DBMS) development (equivalent to 450-words)Database tables and queries need to be created on a SQL Server environment as stored procedures.

N/AN/AN/ANo10 SILO1, SILO2, SILO4

Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model

N/AN/AN/ANo10 SILO3

Advanced Database research report (equivalent to 1,000-words)Research and report on an advanced database topic. Individual topics provided during the 6th week of teaching.

N/AN/AN/ANo20 SILO7

Written laboratory report (500-words) and Oral presentation (5-mins) (total 1,000-words)Students use a DBMS to write actual queries and submit a lab report. Students are subsequently asked to verbally respond to questions about their report (5 minute oral).

N/AN/AN/ANo20 SILO1, SILO2, SILO4

One 1.5-hour exam delivered via the Learning Management System (equivalent to 1,500-words)LMS security mechanisms (specific IP addresses, password protection, time limited) will be used for security. Teacher graded online exam. Short answer and essay questions delivered via LMS. The exam is timed.

N/AN/AN/ANo40 SILO1, SILO4, SILO5, SILO6

Online (Didasko), 2021, Study block 12, Online

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorEric Pardede

Class requirements

Unscheduled Online ClassWeek: 0 - 0
One 3.00 h unscheduled online class per week on any day including weekend during the day from week 0 to week 0 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Laboratory report about Database Management System (DBMS) development (equivalent to 450-words)Database tables and queries need to be created on a SQL Server environment as stored procedures.

N/AN/AN/ANo10 SILO1, SILO2, SILO4

Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model

N/AN/AN/ANo10 SILO3

Advanced Database research report (equivalent to 1,000-words)Research and report on an advanced database topic. Individual topics provided during the 6th week of teaching.

N/AN/AN/ANo20 SILO7

Written laboratory report (500-words) and Oral presentation (5-mins) (total 1,000-words)Students use a DBMS to write actual queries and submit a lab report. Students are subsequently asked to verbally respond to questions about their report (5 minute oral).

N/AN/AN/ANo20 SILO1, SILO2, SILO4

One 1.5-hour exam delivered via the Learning Management System (equivalent to 1,500-words)LMS security mechanisms (specific IP addresses, password protection, time limited) will be used for security. Teacher graded online exam. Short answer and essay questions delivered via LMS. The exam is timed.

N/AN/AN/ANo40 SILO1, SILO4, SILO5, SILO6

Online (Didasko), 2021, Study block 2, Online

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorEric Pardede

Class requirements

Unscheduled Online ClassWeek: 0 - 0
One 3.00 h unscheduled online class per week on any day including weekend during the day from week 0 to week 0 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Laboratory report about Database Management System (DBMS) development (equivalent to 450-words)Database tables and queries need to be created on a SQL Server environment as stored procedures.

N/AN/AN/ANo10 SILO1, SILO2, SILO4

Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model

N/AN/AN/ANo10 SILO3

Advanced Database research report (equivalent to 1,000-words)Research and report on an advanced database topic. Individual topics provided during the 6th week of teaching.

N/AN/AN/ANo20 SILO7

Written laboratory report (500-words) and Oral presentation (5-mins) (total 1,000-words)Students use a DBMS to write actual queries and submit a lab report. Students are subsequently asked to verbally respond to questions about their report (5 minute oral).

N/AN/AN/ANo20 SILO1, SILO2, SILO4

One 1.5-hour exam delivered via the Learning Management System (equivalent to 1,500-words)LMS security mechanisms (specific IP addresses, password protection, time limited) will be used for security. Teacher graded online exam. Short answer and essay questions delivered via LMS. The exam is timed.

N/AN/AN/ANo40 SILO1, SILO4, SILO5, SILO6

Online (Didasko), 2021, Study block 3, Online

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorEric Pardede

Class requirements

Unscheduled Online ClassWeek: 0 - 0
One 3.00 h unscheduled online class per week on any day including weekend during the day from week 0 to week 0 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Laboratory report about Database Management System (DBMS) development (equivalent to 450-words)Database tables and queries need to be created on a SQL Server environment as stored procedures.

N/AN/AN/ANo10 SILO1, SILO2, SILO4

Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model

N/AN/AN/ANo10 SILO3

Advanced Database research report (equivalent to 1,000-words)Research and report on an advanced database topic. Individual topics provided during the 6th week of teaching.

N/AN/AN/ANo20 SILO7

Written laboratory report (500-words) and Oral presentation (5-mins) (total 1,000-words)Students use a DBMS to write actual queries and submit a lab report. Students are subsequently asked to verbally respond to questions about their report (5 minute oral).

N/AN/AN/ANo20 SILO1, SILO2, SILO4

One 1.5-hour exam delivered via the Learning Management System (equivalent to 1,500-words)LMS security mechanisms (specific IP addresses, password protection, time limited) will be used for security. Teacher graded online exam. Short answer and essay questions delivered via LMS. The exam is timed.

N/AN/AN/ANo40 SILO1, SILO4, SILO5, SILO6

Online (Didasko), 2021, Study block 4, Online

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorEric Pardede

Class requirements

Unscheduled Online ClassWeek: 0 - 0
One 3.00 h unscheduled online class per week on any day including weekend during the day from week 0 to week 0 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Laboratory report about Database Management System (DBMS) development (equivalent to 450-words)Database tables and queries need to be created on a SQL Server environment as stored procedures.

N/AN/AN/ANo10 SILO1, SILO2, SILO4

Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model

N/AN/AN/ANo10 SILO3

Advanced Database research report (equivalent to 1,000-words)Research and report on an advanced database topic. Individual topics provided during the 6th week of teaching.

N/AN/AN/ANo20 SILO7

Written laboratory report (500-words) and Oral presentation (5-mins) (total 1,000-words)Students use a DBMS to write actual queries and submit a lab report. Students are subsequently asked to verbally respond to questions about their report (5 minute oral).

N/AN/AN/ANo20 SILO1, SILO2, SILO4

One 1.5-hour exam delivered via the Learning Management System (equivalent to 1,500-words)LMS security mechanisms (specific IP addresses, password protection, time limited) will be used for security. Teacher graded online exam. Short answer and essay questions delivered via LMS. The exam is timed.

N/AN/AN/ANo40 SILO1, SILO4, SILO5, SILO6

Online (Didasko), 2021, Study block 5, Online

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorEric Pardede

Class requirements

Unscheduled Online ClassWeek: 0 - 0
One 3.00 h unscheduled online class per week on any day including weekend during the day from week 0 to week 0 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Laboratory report about Database Management System (DBMS) development (equivalent to 450-words)Database tables and queries need to be created on a SQL Server environment as stored procedures.

N/AN/AN/ANo10 SILO1, SILO2, SILO4

Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model

N/AN/AN/ANo10 SILO3

Advanced Database research report (equivalent to 1,000-words)Research and report on an advanced database topic. Individual topics provided during the 6th week of teaching.

N/AN/AN/ANo20 SILO7

Written laboratory report (500-words) and Oral presentation (5-mins) (total 1,000-words)Students use a DBMS to write actual queries and submit a lab report. Students are subsequently asked to verbally respond to questions about their report (5 minute oral).

N/AN/AN/ANo20 SILO1, SILO2, SILO4

One 1.5-hour exam delivered via the Learning Management System (equivalent to 1,500-words)LMS security mechanisms (specific IP addresses, password protection, time limited) will be used for security. Teacher graded online exam. Short answer and essay questions delivered via LMS. The exam is timed.

N/AN/AN/ANo40 SILO1, SILO4, SILO5, SILO6

Online (Didasko), 2021, Study block 6, Online

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorEric Pardede

Class requirements

Unscheduled Online ClassWeek: 0 - 0
One 3.00 h unscheduled online class per week on any day including weekend during the day from week 0 to week 0 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Laboratory report about Database Management System (DBMS) development (equivalent to 450-words)Database tables and queries need to be created on a SQL Server environment as stored procedures.

N/AN/AN/ANo10 SILO1, SILO2, SILO4

Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model

N/AN/AN/ANo10 SILO3

Advanced Database research report (equivalent to 1,000-words)Research and report on an advanced database topic. Individual topics provided during the 6th week of teaching.

N/AN/AN/ANo20 SILO7

Written laboratory report (500-words) and Oral presentation (5-mins) (total 1,000-words)Students use a DBMS to write actual queries and submit a lab report. Students are subsequently asked to verbally respond to questions about their report (5 minute oral).

N/AN/AN/ANo20 SILO1, SILO2, SILO4

One 1.5-hour exam delivered via the Learning Management System (equivalent to 1,500-words)LMS security mechanisms (specific IP addresses, password protection, time limited) will be used for security. Teacher graded online exam. Short answer and essay questions delivered via LMS. The exam is timed.

N/AN/AN/ANo40 SILO1, SILO4, SILO5, SILO6

Online (Didasko), 2021, Study block 7, Online

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorEric Pardede

Class requirements

Unscheduled Online ClassWeek: 0 - 0
One 3.00 h unscheduled online class per week on any day including weekend during the day from week 0 to week 0 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Laboratory report about Database Management System (DBMS) development (equivalent to 450-words)Database tables and queries need to be created on a SQL Server environment as stored procedures.

N/AN/AN/ANo10 SILO1, SILO2, SILO4

Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model

N/AN/AN/ANo10 SILO3

Advanced Database research report (equivalent to 1,000-words)Research and report on an advanced database topic. Individual topics provided during the 6th week of teaching.

N/AN/AN/ANo20 SILO7

Written laboratory report (500-words) and Oral presentation (5-mins) (total 1,000-words)Students use a DBMS to write actual queries and submit a lab report. Students are subsequently asked to verbally respond to questions about their report (5 minute oral).

N/AN/AN/ANo20 SILO1, SILO2, SILO4

One 1.5-hour exam delivered via the Learning Management System (equivalent to 1,500-words)LMS security mechanisms (specific IP addresses, password protection, time limited) will be used for security. Teacher graded online exam. Short answer and essay questions delivered via LMS. The exam is timed.

N/AN/AN/ANo40 SILO1, SILO4, SILO5, SILO6

Online (Didasko), 2021, Study block 8, Online

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorEric Pardede

Class requirements

Unscheduled Online ClassWeek: 0 - 0
One 3.00 h unscheduled online class per week on any day including weekend during the day from week 0 to week 0 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Laboratory report about Database Management System (DBMS) development (equivalent to 450-words)Database tables and queries need to be created on a SQL Server environment as stored procedures.

N/AN/AN/ANo10 SILO1, SILO2, SILO4

Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model

N/AN/AN/ANo10 SILO3

Advanced Database research report (equivalent to 1,000-words)Research and report on an advanced database topic. Individual topics provided during the 6th week of teaching.

N/AN/AN/ANo20 SILO7

Written laboratory report (500-words) and Oral presentation (5-mins) (total 1,000-words)Students use a DBMS to write actual queries and submit a lab report. Students are subsequently asked to verbally respond to questions about their report (5 minute oral).

N/AN/AN/ANo20 SILO1, SILO2, SILO4

One 1.5-hour exam delivered via the Learning Management System (equivalent to 1,500-words)LMS security mechanisms (specific IP addresses, password protection, time limited) will be used for security. Teacher graded online exam. Short answer and essay questions delivered via LMS. The exam is timed.

N/AN/AN/ANo40 SILO1, SILO4, SILO5, SILO6

Online (Didasko), 2021, Study block 9, Online

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorEric Pardede

Class requirements

Unscheduled Online ClassWeek: 0 - 0
One 3.00 h unscheduled online class per week on any day including weekend during the day from week 0 to week 0 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Laboratory report about Database Management System (DBMS) development (equivalent to 450-words)Database tables and queries need to be created on a SQL Server environment as stored procedures.

N/AN/AN/ANo10 SILO1, SILO2, SILO4

Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model

N/AN/AN/ANo10 SILO3

Advanced Database research report (equivalent to 1,000-words)Research and report on an advanced database topic. Individual topics provided during the 6th week of teaching.

N/AN/AN/ANo20 SILO7

Written laboratory report (500-words) and Oral presentation (5-mins) (total 1,000-words)Students use a DBMS to write actual queries and submit a lab report. Students are subsequently asked to verbally respond to questions about their report (5 minute oral).

N/AN/AN/ANo20 SILO1, SILO2, SILO4

One 1.5-hour exam delivered via the Learning Management System (equivalent to 1,500-words)LMS security mechanisms (specific IP addresses, password protection, time limited) will be used for security. Teacher graded online exam. Short answer and essay questions delivered via LMS. The exam is timed.

N/AN/AN/ANo40 SILO1, SILO4, SILO5, SILO6