module specification

CC3017 - Database Application Development (2017/18)

Module specification Module approved to run in 2017/18, but may be subject to modification
Module title Database Application Development
Module level Honours (06)
Credit rating for module 15
School School of Computing and Digital Media
Assessment components
Type Weighting Qualifying mark Description
Coursework 70%   Individual Assignment *FC*
Coursework 30%   Individual Report
Running in 2017/18 No instances running in the year

Module summary


The module builds upon the student's general understanding of database systems acquired in the prerequisite module, and emphasizes the techniques and practice of database application development, as well as its theoretical underpinning. It also provides a comprehensive introduction to the Oracle development suite as an example toolset, enabling the student to acquire transferable skills and proficiency in developing more substantial 'real life' database applications.

Assessment is by means of two pieces of coursework (100%). Students are required to pass each component to achieve an overall pass of the module.

Prior learning requirements

CC2006N Data Modelling and Databases Systems (Intermediate Level)

Module aims

The principal graduate attribute focused on in this module is A2

The module aims to enhance the student's understanding of database systems acquired in the prerequisite module by enabling the student to gain considerable exposure to the practical issues, as well as their theoretical underpinning, pertinent to the development of modern database applications. [A2]

This module emphasizes the practical element by providing transferable skills with the chosen developer toolset. This will include an understanding of the database development environment and the chosen toolset platform; advanced coverage of SQL and PL/SQL, database Forms and Reports (using Oracle developer as an example toolset). [A2]

This module also addresses web-based databases and their applications, and includes coverage of interface design pertinent to database application development. [A2]

Syllabus

• Database development environment; 3 tier architecture.
• Database server; client side and server side; Oracle platform
• Advanced coverage of SQL
• PL/SQL; including triggers, and trigger types
• User interface design for database applications: graphical user interface, textual user interface.
• Database Forms (using Oracle as an example toolset): including single forms, multi-forms, canvas, buttons, list of values, checkbox and radio groups.
• Database Reports (using Oracle as an example toolset) : including report generation, parameter values, incoporating queries to produce reports.
• Web-based database applications
• Current issues/topics/products in database industry.

Learning and teaching

Each week will consist of formal lectures followed by supervised practical workshops with a total of 4 hours per week.

The lectures will cover the designated topics and discuss the concepts and theory required to understand the practical development of database applications.

The 2 hours per week workshop sessions will provide students with the opportunity to gain hands-on experience and practical proficency of using the chosen toolset.

In addition students are strongly advised to read widely of relevant materials from books, journals and the internet in order to acquire a better understanding of the subject.

Learning outcomes

On successful completion of this module the student should be able to:

1. Design, implement and test a substantial database for the given DBMS environment [A2]
2. Design, implement and test a user interface for a DBMS [A2]
3. Demonstrate a good understanding of various design and implementation issues which affect the database system and its performance. [A2]
4. Communicate and describe systems with a professional approach in both written documentation and practical demonstration.

Assessment strategy

The module will be assessed by coursework (100%). This will consist of two pieces of individual work with a 70% and 30% weighting respectively.

The first coursework (CW1, 70% weighting) is a substantial development project involving the design and implementation of a database, using suite of forms and reports provided in the Oracle developer as an example toolset. Assessment of the first coursework will consist of a written technical document (40%) of the system and a demonstration of the application (30%). Part 1 of the coursework covers primarily learning outcomes 1 and 2.
The second coursework (CW2, 30% weighting) is a report on an investigation or a compartive study on the development of a web database using either Oracle database suite of tools and other alternative of web database development. Part 2 of the coursework covers primarily learning outcomes 3 and 4.

Bibliography

Main References

• The main reference for practical work will be the module workshop booklet.

• Connolly, T. & Begg, C. Database Systems - A Practical Approach to Design, Implementation, and Management (4th ed.), Addison Wesley, 2005.

• Bennett, M. Programming with Oracle Developer, SAMS (a division of Pearson), 2002.

• Morrison, J & Morrison, M. Guide to Oracle 9i, Thomson, 2003 (to be updated to reference bokk on racle 10G).

• David, M. Kroenke, Database Processing- Fundamentals, Design & Implementation. Prentice Hall, 9th Edition, 2004.

Other References

• Elmasri, R. & Navathe, S. Fundamentals of Database Systems (4th ed.) Addison Wesley, 2004.

• Motivala, B. Oracle Forms, Prentice Hall, 2000.