cse2dbx database fundamentals
DATABASE FUNDAMENTALS
CSE2DBX
2017
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.
SchoolSchool Engineering&Mathematical Sciences
Credit points15
Subject Co-ordinatorFei Liu
Available to Study Abroad StudentsNo
Subject year levelYear Level 2 - UG
Exchange StudentsNo
Subject particulars
Subject rules
Prerequisites Must be enrolled in SBAIO.
Co-requisitesN/A
Incompatible subjectsN/A
Equivalent subjectsN/A
Special conditionsN/A
Learning resources
Readings
| Resource Type | Title | Resource Requirement | Author and Year | Publisher |
|---|---|---|---|---|
| Readings | Database Systems: Design, Implementation & Management | Prescribed | Morris. S, & Coronel. C. 2016 | CENGAGE Learning Custom Publishing |
| Readings | Database fundamentals learning guide | Prescribed | Computer Power Institute, 2016 | Didasko Digital |
Graduate capabilities & intended learning outcomes
01. Explain the functions of a database and show how a database meets the information needs of management.
- Activities:
- Reading material, and online viewing of multimedia presentations and participation in webinars.
- Related graduate capabilities and elements:
- Literacies and Communication Skills(Speaking)
02. Apply the relational database model as a design tool and as a structure for a database management system.
- Activities:
- Discussions about the relational model and how it differs from its predecessors (ie: hierarchical) and its successors (Object oriented).
- Related graduate capabilities and elements:
- Literacies and Communication Skills(Speaking)
03. Develop ER/EER diagrams to model data requirements and mapping them to the relational model.
- Activities:
- Reading materials, and online viewing of multimedia presentations and participation in webinars. Self-checking questions will be incorporated to scaffold learning.
- Related graduate capabilities and elements:
- Discipline -Specific Knowledge and Skills(Discipline-Specific Knowledge and Skills)
04. Create queries using standard Structured Query Language (SQL).
- Activities:
- Hands-on skills in writing in SQL scripts on a commercial database management system.
- Related graduate capabilities and elements:
- Discipline -Specific Knowledge and Skills(Discipline-Specific Knowledge and Skills)
05. Apply the principles of normalization to a problem in order to reduce data redundancy and improve data integrity.
- Activities:
- Demonstrate process of data normalization via a case study. Microsoft word and other applications can be used.
- Related graduate capabilities and elements:
- Discipline -Specific Knowledge and Skills(Discipline-Specific Knowledge and Skills)
06. Explain how security is implemented in database system.
- Activities:
- Discussions about overall security (physical security, SQL injection and other common threats) as well as security provided by SQL (ie: GRANT, REVOKE). Reading materials will supplement these forums.
- Related graduate capabilities and elements:
- Discipline -Specific Knowledge and Skills(Discipline-Specific Knowledge and Skills)
07. Explain commercial directions in database use, including client-server models, distributed databases, NoSQL and data warehousing.
- Activities:
- Peer teaching via webinar.
- Related graduate capabilities and elements:
- Discipline -Specific Knowledge and Skills(Discipline-Specific Knowledge and Skills)
Subject options
Select to view your study options…
Online, 2017, Study Block 1, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online Class
One 3.0 hours unscheduled online class per week on any day including weekend during the day and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Study Block 2, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online Class
One 3.0 hours unscheduled online class per week on any day including weekend during the day and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Study Block 3, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online Class
One 3.0 hours unscheduled online class per week on any day including weekend during the day and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Study Block 4, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online Class
One 3.0 hours unscheduled online class per week on any day including weekend during the day and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Study Block 5, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online Class
One 3.0 hours unscheduled online class per week on any day including weekend during the day and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Study Block 6, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online Class
One 3.0 hours unscheduled online class per week on any day including weekend during the day and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Study Block 7, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online Class
One 3.0 hours unscheduled online class per week on any day including weekend during the day and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Study Block 8, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online Class
One 3.0 hours unscheduled online class per week on any day including weekend during the day and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Study Block 9, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online Class
One 3.0 hours unscheduled online class per week on any day including weekend during the day and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Study Block 10, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online Class
One 3.0 hours unscheduled online class per week on any day including weekend during the day and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Study Block 11, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online Class
One 3.0 hours unscheduled online class per week on any day including weekend during the day and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Study Block 12, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online Class
One 3.0 hours unscheduled online class per week on any day including weekend during the day and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Week 02-13, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online ClassWeek: 02 - 13
One 3.0 hours unscheduled online class per week on any day including weekend during the day from week 02 to week 13 and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Week 05-16, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online ClassWeek: 05 - 16
One 3.0 hours unscheduled online class per week on any day including weekend during the day from week 05 to week 16 and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |
Online, 2017, Week 09-21, Online
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorFei Liu
Class requirements
Unscheduled Online ClassWeek: 09 - 21
One 3.0 hours unscheduled online class per week on any day including weekend during the day from week 09 to week 21 and delivered via online.
Assessments
| Assessment element | Comments | % | 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. | 10 | 01, 02, 04 |
| Written (word-processed) report (equivalent to 450-words) | Create ER/EER diagram and map to relational model | 10 | 03 |
| 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. | 20 | 07 |
| 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). | 20 | 01, 02, 04 |
| 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. | 40 | 01, 04, 05, 06 |