20 credits at level HE6
This module allows students to develop their database techniques and knowledge further from the Database Theory and Practice module, including use of triggers and procedures. Students will be introduced to tools for developing database solutions either interactively with a forms approach, or through a programming language and pre-compiler. The module will develop some of the concepts introduced in the earlier database module, such as concurrent transactions, and as well as providing an introduction to some new areas such a distributed databases and data-warehousing, and performance issues.
Research and report on current database issues such as data-warehousing, distributed databases
Analyse and critically evaluate the different approaches to distributed data
Analyse the differences between operational databases and data warehouses
At the end of the module the learner will be able to
Develop the functionality and usefulness of an existing database, by adding SQL code in the form of procedures or triggers.
Access a database through scripts or pre-compiled code.
Use effectively tools such as SQL*Forms to develop further an existing database.
Design a simple data-warehouse from an existing operational database and discuss implementation issues
The learner can
1.Design, code and test SQL procedure and triggers.
2.Modify code in a high level language to provide access a database through pre-compiled code.
3.Design and implement a simple forms-interface to an existing database.
4.Design and implement a simple data-warehouse.
Assessment will consist of one assignment (50%), which will involve database programming and enhancement using forms,
PL/SQL or similar database programming language features:
loops, cursors, procedures, triggers, packages
Embedded SQL- precompilers and related concepts
SQLForms or similar forms interface – master detail, extra data, design for user interaction
Further Database issues –
Transactions and Concurrency
Recovery and Backup
Distributed data approaches including client server, distributed database
and replication systems.
Data-warehousing - design and implementation
The module will be taught by a combination of lectures, a case study, practical work and directed reading. The students will be expected to enhance an existing database, used as a case study through out the module, in various ways. The theoretical aspects will be covered in outline in the lectures with the students expected to supply background research and analysis.
NB Where this module is offered online (via BoltOnline) lectures and seminars delivered by Elluminate.
when you have successfully completed this module you will:
to demonstrate that you have achieved the learning outcome you will:
|1.||Discuss the advantages and disadvantages of using of triggers and procedures to solve a database problem.
||Choose and justify a solution using either triggers or procedures.|
|2.||Analyse various ways of providing access to a database, through forms, scripts, programming languages etc||
Provide a typical user with access to a database, through forms, scripts, programming languages etc.
|3.||Demonstrate an understanding of database issues such as concurrency, distribution of data, performance of databases etc.
||Research and discuss database issues such as concurrency, distribution of data, performance of databases etc.|
|4.||Discuss the need for data warehouses and their characteristics and uses for data mining operations.
||Design a data warehouse and justify their design. Outline implementation issues.|
Your achievement of the learning outcomes for this module will be tested as follows:
|Description||Given a case study of an existing database , enhance its usefulness and functionality by the use of triggers, procedures and forms. Demonstrate the solution and evaluate its effectiveness, and discuss alternative designs||Two hour closed book examination testing grasp of concepts and issues|
Before taking this module you must have successfully completed the following:
No restrictions apply.
Connolly and Begg (2004) Database Systems 4th Edition.
Ward and Dafoulas (2006) Database Management Systems.
William Smith (2004) Systems Building with Oracle .
Feuerstein S. (2008) Oracle PL/SQL Programming 4th ed.
Indicative Web Sites
Oracle Concepts (2005) www.oracle.com
Oracle (2010) academy.oracle.com
Sushil Kilkarni (2007) Distributed Database
Valentina Tamma Distributed Database
Yang Distributed Database
|Host Subject Group:|
|User Name||Date Accessed||Action|