ITB7325 – Advanced Databases

Module code

ITB7325

Module title

Advanced Databases

Prescription

This module develops further methods for verification of current or emerging data models, and enables a detailed examination of database design issues, particularly more efficient implementation strategies that include PL/SQL. In turn, it further concentrates on principles of performance, data integrity, security and management and extends programming skills through the building of applications based on database structures.

NZQA Level

Level 7

NZQA Credits

Delivery method

Web-Based

Learning hours

Total learning hours: 150

Resources required

Learning Outcomes: Upon successful completion of this module, the student will be able to:

1. Investigate the issues involved in the management, security, and system performance of
current or emerging database systems
1.1. Compare and contrast the differences between database systems
1.2. Distinguish performance methods
1.3. Discuss concurrency control, data integrity, data security and performance requirements
1.4. Identify security issues and resolve problems

2. Apply current or emerging data modelling techniques to a complex system:
2.1. Distinguish between various levels of data models:
2.1.1. Conceptual Level
2.1.2. External Level
2.1.3. Internal Level

2.2. Apply data modelling to a complex system that include high level normalization or
schemas
2.3. Incorporate modelling techniques to support business rules
2.4. Implement data modelling for a complex system using a Computer-Aided Software
Engineering (CASE) tool
2.5. Implement Data Definition Languages (DDLs) to support the data model for the complex
system including data integrity and business rules where applied

3. Design, implement, test and document a solution for a complex system:
3.1. Identify user requirements
3.2. Design input screens and story-board the solution for a complex system
3.3. Create input screens according to specification
3.4. Create reports according to specification
3.5. Implement processing (other than data input and reporting) according to specification
3.6. Implement and execute a test plan for the solution which will validate the solution against
the specification
3.7. Produce appropriate application documentation
3.8. Implement PL/SQL functions, procedures or packages to support the complex system

4. Implement an application to access data stored in a database utilising current industry
technology:
4.1. Design and develop a database application with network or internet access.
Content: - Performance methods shall investigate data integrity, concurrency, security, and accuracy

- Database systems include DBMS and includes one or more of the following: RDBMS,
DDBMS, OODBMS, ORDBMS, Data Warehouse, Data Mining, NoSQL or any current or
emerging database system

- Data modeling techniques includes one or more of the following: RDBMS, OODBMS,
ORDBMS, Star Schemas, Dimensional Modelling or any current or emerging data model

-High level normalization includes 3rd Normal Form and above

-High level schemas include schemas utilized in current or emerging database systems

-SQL and PL/SQL

-Implementation of Triggers, Functions, Procedures and Packages in PL/SQL
Teaching and Learning Strategy: Teaching methods will involve theoretical and practical classes which may include, but are not limited to lectures, tutorials, computer laboratory work, group activities and assignments.
Learning and Teaching Resource: Allen, S., Terry, E., (Feuerstein, S., (2014). Oracle PL/SQL Programming (6th Ed)

Churcher, C., (2012). Beginning Database Design (2nd Ed)

Gault, D., Cannell, K., Cimolini, P., D'Souza, M. G., & Hilaire, T (2013). Beginning Oracle Application Express 4.2.

Kimball, R., & Ross, M., (2013). The Data Warehouse Toolkit (3rd Ed)

Ozsu, M. T., & Valduriez, P., (2011). Principles of Distributed Database Systems (3rd Ed)

Oracle, (2005). Oracle/SQL User's Guide and Reference 10G Release 2 (10.2)

Morton, K., Osborne, K., Sands, R., Shamsudeen, R., & Still, R., (2010). Pro Oracle SQL

Stephens, R., (2010). Beginning Database Design Solutions