DATABASE FUNDAMENTALS
CSE2DBX
2020
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 TypeBook
Resource RequirementPrescribed
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 TypeBook
Resource RequirementPrescribed
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
Subject options
Select to view your study options…
Online (Didasko), 2020, Study block 1, Online
Overview
Online enrolmentNo
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
Class requirements
Unscheduled Online Class
Week:
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 element | Category | Contribution | Hurdle | % | 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/A | N/A | No | 10 | SILO1, SILO2, SILO4 |
Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model | N/A | N/A | No | 10 | 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/A | N/A | No | 20 | 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/A | N/A | No | 20 | 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/A | N/A | No | 40 | SILO1, SILO4, SILO5, SILO6 |
Online (Didasko), 2020, Study block 10, Online
Overview
Online enrolmentNo
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
Class requirements
Unscheduled Online Class
Week:
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 element | Category | Contribution | Hurdle | % | 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/A | N/A | No | 10 | SILO1, SILO2, SILO4 |
Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model | N/A | N/A | No | 10 | 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/A | N/A | No | 20 | 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/A | N/A | No | 20 | 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/A | N/A | No | 40 | SILO1, SILO4, SILO5, SILO6 |
Online (Didasko), 2020, Study block 11, Online
Overview
Online enrolmentNo
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
Class requirements
Unscheduled Online Class
Week:
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 element | Category | Contribution | Hurdle | % | 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/A | N/A | No | 10 | SILO1, SILO2, SILO4 |
Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model | N/A | N/A | No | 10 | 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/A | N/A | No | 20 | 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/A | N/A | No | 20 | 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/A | N/A | No | 40 | SILO1, SILO4, SILO5, SILO6 |
Online (Didasko), 2020, Study block 12, Online
Overview
Online enrolmentNo
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
Class requirements
Unscheduled Online Class
Week:
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 element | Category | Contribution | Hurdle | % | 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/A | N/A | No | 10 | SILO1, SILO2, SILO4 |
Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model | N/A | N/A | No | 10 | 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/A | N/A | No | 20 | 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/A | N/A | No | 20 | 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/A | N/A | No | 40 | SILO1, SILO4, SILO5, SILO6 |
Online (Didasko), 2020, Study block 2, Online
Overview
Online enrolmentNo
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
Class requirements
Unscheduled Online Class
Week:
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 element | Category | Contribution | Hurdle | % | 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/A | N/A | No | 10 | SILO1, SILO2, SILO4 |
Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model | N/A | N/A | No | 10 | 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/A | N/A | No | 20 | 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/A | N/A | No | 20 | 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/A | N/A | No | 40 | SILO1, SILO4, SILO5, SILO6 |
Online (Didasko), 2020, Study block 3, Online
Overview
Online enrolmentNo
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
Class requirements
Unscheduled Online Class
Week:
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 element | Category | Contribution | Hurdle | % | 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/A | N/A | No | 10 | SILO1, SILO2, SILO4 |
Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model | N/A | N/A | No | 10 | 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/A | N/A | No | 20 | 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/A | N/A | No | 20 | 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/A | N/A | No | 40 | SILO1, SILO4, SILO5, SILO6 |
Online (Didasko), 2020, Study block 4, Online
Overview
Online enrolmentNo
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
Class requirements
Unscheduled Online Class
Week:
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 element | Category | Contribution | Hurdle | % | 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/A | N/A | No | 10 | SILO1, SILO2, SILO4 |
Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model | N/A | N/A | No | 10 | 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/A | N/A | No | 20 | 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/A | N/A | No | 20 | 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/A | N/A | No | 40 | SILO1, SILO4, SILO5, SILO6 |
Online (Didasko), 2020, Study block 5, Online
Overview
Online enrolmentNo
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
Class requirements
Unscheduled Online Class
Week:
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 element | Category | Contribution | Hurdle | % | 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/A | N/A | No | 10 | SILO1, SILO2, SILO4 |
Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model | N/A | N/A | No | 10 | 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/A | N/A | No | 20 | 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/A | N/A | No | 20 | 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/A | N/A | No | 40 | SILO1, SILO4, SILO5, SILO6 |
Online (Didasko), 2020, Study block 6, Online
Overview
Online enrolmentNo
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
Class requirements
Unscheduled Online Class
Week:
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 element | Category | Contribution | Hurdle | % | 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/A | N/A | No | 10 | SILO1, SILO2, SILO4 |
Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model | N/A | N/A | No | 10 | 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/A | N/A | No | 20 | 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/A | N/A | No | 20 | 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/A | N/A | No | 40 | SILO1, SILO4, SILO5, SILO6 |
Online (Didasko), 2020, Study block 7, Online
Overview
Online enrolmentNo
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
Class requirements
Unscheduled Online Class
Week:
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 element | Category | Contribution | Hurdle | % | 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/A | N/A | No | 10 | SILO1, SILO2, SILO4 |
Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model | N/A | N/A | No | 10 | 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/A | N/A | No | 20 | 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/A | N/A | No | 20 | 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/A | N/A | No | 40 | SILO1, SILO4, SILO5, SILO6 |
Online (Didasko), 2020, Study block 8, Online
Overview
Online enrolmentNo
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
Class requirements
Unscheduled Online Class
Week:
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 element | Category | Contribution | Hurdle | % | 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/A | N/A | No | 10 | SILO1, SILO2, SILO4 |
Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model | N/A | N/A | No | 10 | 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/A | N/A | No | 20 | 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/A | N/A | No | 20 | 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/A | N/A | No | 40 | SILO1, SILO4, SILO5, SILO6 |
Online (Didasko), 2020, Study block 9, Online
Overview
Online enrolmentNo
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorEric Pardede
Class requirements
Unscheduled Online Class
Week:
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 element | Category | Contribution | Hurdle | % | 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/A | N/A | No | 10 | SILO1, SILO2, SILO4 |
Written (word-processed) report (equivalent to 450-words)Create ER/EER diagram and map to relational model | N/A | N/A | No | 10 | 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/A | N/A | No | 20 | 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/A | N/A | No | 20 | 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/A | N/A | No | 40 | SILO1, SILO4, SILO5, SILO6 |