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 TypeTitleResource RequirementAuthor and YearPublisher
ReadingsDatabase Systems: Design, Implementation & ManagementPrescribedMorris. S, & Coronel. C. 2016CENGAGE Learning Custom Publishing
ReadingsDatabase fundamentals learning guidePrescribedComputer Power Institute, 2016Didasko 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…

Start date between: and    Key dates

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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 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 elementComments%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.1001, 02, 04
Written (word-processed) report (equivalent to 450-words) Create ER/EER diagram and map to relational model1003
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.2007
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).2001, 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. 4001, 04, 05, 06