BN204 - Database Technologies

Credit Points: 15 credit points

Workload: 48 hours

Prerequisite: N/A

Co-requisite: N/A

Aims & Objectives

This is a third trimester core unit out of a total of 24 units in the Bachelor of Networking (BNet). This unit addresses the BNet course learning outcomes and complements other courses in a related field by developing students’ knowledge and skills in database technologies. For further course information refer to: http://www.mit.edu.au/study-with-us/programs/bachelor-networking. This unit is part of the AQF Level 7 (BNet) course.

This unit introduces students to the advantages and functionality of Database Management Systems. The unit presents various models of database management systems and data modelling techniques, and discusses general features and capabilities of databases, using an actual system for a practical application. Students will develop skills at using databases and data retrieval techniques using SQL (Structured Query Language).

This unit will cover the following topics:

  • Database: Introduction
  • Data Modelling
  • Information Systems
  • Relational Model
  • Distributed Databases
  • Transaction Processing

Learning Outcomes

4.1 Course Learning Outcomes
The Course learning outcomes applicable to this unit are listed on the Melbourne Institute of Technology’s website: www.mit.edu.au 

4.2 Unit Learning Outcomes
At the completion of this unit students should be able to:
a. Describe issues related to the integrity and security of database (DB) systems.
b. Make an informed and critical assessment of database management systems (DBMS).
c. Develop data models and implement DB systems.
d. Analyse business decisions related to DB information systems.
e. Demonstrate skills in building a database application using a commercially available database management system development tool.

Weekly Topics

This unit will cover the content below:

Week # Lecture Topic Laboratory
1 Introduction to database principles and concepts. Laboratory 1 - Introduction
2 Relational Model 1 – Introduce Structured Query Language (SQL) Laboratory 2 - The Relational Model1 SQL
3 Relational Model 2 - Using Structured Query Language (SQL) Laboratory 3 - The Relational Model 2 - SQL
4 Relational Model 2 – Using Structured Query Language (SQL) – advance commands Laboratory 4 - The Relational Model 2 - SQL
5 Database Design 1 - Normalization Laboratory 5 - Normalization
6 Database Design 2 - Database Design Methods Information-Level Design Method, Entity-relationship (E-R) diagram Laboratory 6 - Database Design 1 Normalization
7 Database Design 2 - Special issues related to implementing relationships Laboratory 7 - Database Design 2 Design Method –DBDL and ER, In-Class Test
8 DBMS Functions – Update and retrieve data, catalogue services, Support concurrent update, Recover data Laboratory 8 - Database Design 2 Design Method
9 Database Administration and DBMS functions - Security, integrity and support Services, DBA’s administrative and technical responsibilities Laboratory 9 - DBMS Functions and Database Administration
10 Database Management Approaches 1 Distributed database management systems (DDBMSs), Web access to databases Laboratory 10 - DBMS Functions and Database Administration
11 Database Management Approaches 2 Data warehouses, Object oriented DBMSs Laboratory 11- Complete Assignment 2 and Quizzes
12 Review Review

Assessment

Assessment Task Due Date A B Learning Outcomes Assessed
Formative Assignment 1 Week 3 (10/04/2022) 5%   a
In-Class Test Week 7 (06/05/2022)   10% a-c
Assignment 2 Week 11 (05/06/2022) 30%   a-e
Laboratory participation & submissions Week 2 – 11 (12/06/2022) 10%   a-e
Final Examination (2 hours)     45% a-e
TOTALS   45% 55%  

Task Type: Type A: unsupervised, Type B: supervised.

Class Participation and Contribution
This unit has class participation and student contribution as an assessment. The assessment task and marking rubric will follow the Guidelines on Assessing Class Participation (https://www.mit.edu.au/about-us/governance/institute-rules-policies-and-plans/policies-procedures-and-guidelines/Guidelines_on_Assessing_Class_Participation). Further details will be provided in the assessment specification on the type of assessment tasks and the marking rubrics.

Presentations (if applicable)
For presentations conducted in class, students are required to wear business attire.

Textbook and Reference Materials

Text Book:

  • David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder, Database Concepts, Pearson, 2019.

References:

  • P. J. Pratt and M. Z. Last, Concepts of database management, 8th ed., Thomson Course Technology, 2015.
  • K. Gordon, Principles of Data Management: Facilitating information sharing, BCS, The Chartered Institute for IT; 2nd ed., 2013.
  • Hendrikus and J.A. Van Kuijk, Five Pillars of Knowledge, Information and Data Management, CreateSpace Independent Publishing Platform, 2011.
  • P. J. Pratt and M. Z. Last, A Guide to SQL, 9th ed., Boston: Cengage Learning, 2014. 

Adopted Reference Style: IEEE

Graduate Attributes

MIT is committed to ensure the course is current, practical and relevant so that graduates are “work ready” and equipped for life-long learning. In order to accomplish this, the MIT Graduate Attributes identify the required knowledge, skills and attributes that prepare students for the industry.
The level to which Graduate Attributes covered in this unit are as follows:

Ability to communicate Independent and Lifelong Learning Ethics Analytical and Problem Solving Cultural and Global Awareness Team work Specialist knowledge of a field of study

Legend

Levels of attainment Extent covered
The attribute is covered by theory and practice, and addressed by assessed activities in which the students always play an active role, e.g. workshops, lab submissions, assignments, demonstrations, tests, examinations.
The attribute is covered by theory or practice, and addressed by assessed activities in which the students mostly play an active role, e.g. discussions, reading, intepreting documents, tests, examinations.
The attribute is discussed in theory or practice; it is addressed by assessed activities in which the students may play an active role, e.g. lectures and discussions, reading, interpretation, workshops, presentations.
The attribute is presented as a side issue in theory or practice; it is not specifically assessed, but it is addressed by activities such as lectures or tutorials.
The attribute is not considered, there is no theory or practice or activities associated with this attribute.