Foundation degrees

Course Information

Database Tools

Module summary

Module code: COMP1533
Level: 7
Credits: 15
School: Liberal Arts and Sciences
Department: Computing and Information Sys.
Module Coordinator(s): Tatiana Simmonds

Specification

Aims

Modern database systems provide a range of tools to facilitate data manipulation and automated data processing. This course has been designed to provide students with the opportunity to explore the techniques that can help with database performance improvement, network traffic reduction, database security, and code reusability. Students will acquire technical skills to implement complex database processing to support enterprise data and data manipulation requirements.

Learning outcomes

On successful completion of this course a student will be able to:

1. Demonstrate in-depth and advanced knowledge and understanding of the database-intensive systems, informed by current practice, scholarship and research.
2. Design, build and test complex stored database programming components to automate data processing.
3. Devise strategies for efficient implementation of the business functions, including decision making, iteration and database security.
4. Demonstrate skills, self-direction and originality in identifying and solving various database systems problems.

Indicative content

Database Programming. Moving business logic into the database. Conditional and sequential control statements. Dynamic SQL. Cursors. Automating Routine Tasks. Stored procedures and Functions. Packages. Advanced Programming Techniques. Using built in packages. Scripting. Automating the database with triggers. Composite data types and Collections. Implementing robust exception-handling. Dependencies and Invalidations. Analysing and Improving Performance.

Teaching and learning activity

Lectures - (1 hour) to introduce concepts and necessary theoretical background.
Lab work - (2 hours) to develop practical skills needed to apply the theoretical concepts.

Assessment

Coursework - 100% weighting, 50% pass mark.
Learning Outcomes - All.
Outline Details - Design, build and test database-centric system based on provided case study.

Students are required to pass all elements of summative assessment in order to pass the course.

Formative Assessment:
Feedback on quiz results.
Feedback from lab tutors on lab-based tutorial exercises.