Course Information Undergraduate prospectus

Database Applications Technologies

Course summary

Course code: COMP1556
Level: 5
Credits: 15
School: Architecture, Computing and Hums
Department: Computing and Information Sys.
Course Coordinator(s): Anthony Valsamidis

Specification

Aims

To develop the necessary knowledge and skills to analyse data, design and build solutions for business problems using various tools and techniques for developing a database systems that positively contribute to the success of running a business and enabling it to achieve its mission and objectives.

Learning outcomes

On completing this course successfully you will be able to:

A. Appreciate the functions required of common business information systems.
B. Understand and be able to apply appropriate development methodologies of data analysis, design and use appropriate modelling techniques for databases.
C. Gather requirements and identify scope and boundaries for developing a business application.
D. Map the business model to a relational Schema.
E. Build a Database System using the integrated tools provided by a Database Management System.
F. Use query facilities to formulate queries and manipulate the database.

Indicative content

Common business systems and their functionality (e.g. stock control, payroll).
Database concepts, database users and the role of databases in organisations.
Data Analysis and Conceptual Data Model e.g. Entity Relationship Modelling diagrams.
Identifying business rules and enterprise constraints.
The relational model: Entity constraints, referential integrity, cardinality and participation constraints, Primary, foreign, candidate keys.
Mapping a Conceptual Model to a Relational Schema.
Functional dependencies and normalisation for relational databases.
Developing Database system for existing business applications.
Linking a web page to a DB table.
Database query and manipulation languages e.g. SQL.

Teaching and learning activity

Each week there will be a 1 hour lecture, 1 hour a workshop seminar and a 1 hour practical session. In the lecture students will be introduced to the issues of data analysis, modelling design, development of a database system for business applications. In the workshop seminars, students will consolidate their understanding from the theoretical lectures with paper exercise and group discussions. In the lab sessions students will learn how to develop a database system using tools provided by the chosen DBMS such as SQL. There will also be self-study time mainly on SQL supported by online learning materials.

Learning Time (1 credit = 10 hours).

Scheduled contact hours:
Note: include in scheduled time: project supervision, demonstrations, practical classes and workshops, supervised time in studio or workshop, scheduled lab work , fieldwork, external visits, work-based learning where integrated into a structured academic programme.
lectures 12;
seminars 12;
supervised practical sessions 12;
tutorials n/a;
formative assessment n/a;
other scheduled time n/a.

Guided independent study:
Note: include in guided independent study preparation for scheduled sessions, follow up work, wider reading or practice, revision.
Independent coursework 90;
Independent laboratory work 24;
other non-scheduled time n/a;
Placements (including work placement and year abroad) n/a;
Total hours (Should be equal to credit x 10) 150.

Assessment

Coursework - 100% weighting. Pass mark 40%. 3000 words plus code to develop and query a DB. Outline details: Individual work building a database system for a given business application and demonstration.
Last item of demonstration.