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.
School: Engineering and Mathematical Sciences (Pre 2022)
Credit points: 15
Subject Co-ordinator: Eric Pardede
Available to Study Abroad/Exchange Students: No
Subject year level: Year Level 2 - UG
Available as Elective: No
Learning Activities: N/A
Capstone subject: No
Subject particulars
Subject rules
Prerequisites: Students must be admitted in the following course: SBAIO
Co-requisites: N/A
Incompatible subjects: N/A
Equivalent subjects: N/A
Quota Management Strategy: N/A
Quota-conditions or rules: N/A
Special conditions: N/A
Minimum credit point requirement: N/A
Assumed knowledge: N/A
Learning resources
Database Systems: Design, Implementation & Management
Resource Type: Book
Resource Requirement: Prescribed
Author: Morris. S, & Coronel. C.
Year: 2016
Edition/Volume: N/A
Publisher: CENGAGE Learning Custom Publishing
ISBN: N/A
Chapter/article title: N/A
Chapter/issue: N/A
URL: N/A
Other description: N/A
Source location: N/A
Database fundamentals learning guide
Resource Type: Book
Resource Requirement: Prescribed
Author: Computer Power Institute
Year: 2016
Edition/Volume: N/A
Publisher: Didasko Digital
ISBN: N/A
Chapter/article title: N/A
Chapter/issue: N/A
URL: N/A
Other description: N/A
Source location: N/A
Career Ready
Career-focused: No
Work-based learning: No
Self sourced or Uni sourced: N/A
Entire subject or partial subject: N/A
Total hours/days required: N/A
Location of WBL activity (region): N/A
WBL addtional requirements: N/A
Graduate capabilities & intended learning outcomes
Graduate Capabilities
Intended Learning Outcomes
Online (Didasko), 2020, Study block 1, Online
Overview
Online enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Unscheduled Online ClassWeek: 0 - 0
One 3.00 hours 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 enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Unscheduled Online ClassWeek: 0 - 0
One 3.00 hours 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 enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Unscheduled Online ClassWeek: 0 - 0
One 3.00 hours 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 enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Unscheduled Online ClassWeek: 0 - 0
One 3.00 hours 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 enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Unscheduled Online ClassWeek: 0 - 0
One 3.00 hours 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 enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Unscheduled Online ClassWeek: 0 - 0
One 3.00 hours 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 enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Unscheduled Online ClassWeek: 0 - 0
One 3.00 hours 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 enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Unscheduled Online ClassWeek: 0 - 0
One 3.00 hours 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 enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Unscheduled Online ClassWeek: 0 - 0
One 3.00 hours 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 enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Unscheduled Online ClassWeek: 0 - 0
One 3.00 hours 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 enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Unscheduled Online ClassWeek: 0 - 0
One 3.00 hours 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 enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Unscheduled Online ClassWeek: 0 - 0
One 3.00 hours 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 |