Course Information Undergraduate prospectus

Web Database Applications

Course summary

Course code: COMP1686
Level: 5
Credits: 15
School: Architecture, Computing and Hums
Department: Computing and Information Sys.
Course Coordinator(s): ACH TBA


Pre and co requisites

Computer Programming 1
Database Techniques


The course aims to develop student's ability to analyse and design solutions to business problems.
This course aims to continue to develop the student's ability to apply systems building tools and techniques in order to construct high quality systems to meet the needs of business.
The course is practical and builds on the skills gained at level 1 and introduces higher level concepts.

Learning outcomes

By the end of this course students will be able to:
A. Appreciate the functions required of common business information systems.
B. Employ problem solving techniques to deal with complex systems.
C. Prepare data models and map them to database schemas.
D. Demonstrable problem solving skills involving integration of a range of technologies.
E. Construct efficient user interfaces for a variety of users.
F. Apply security, testing and quality assurance techniques to software product development.

Indicative content

Common business systems and their functionality;
Advanced database modeling (ERD);
Programming implementation concepts;
Client and server-side web programming (e.g. VB or C#); Recordsets; Functions; Procedures;
Application of XHTML and CSS;
Complex queries; SQL;
Implementation and testing in an Integrated Development Environment (e.g. Visual Studio);
Documentation; user manuals.

Teaching and learning activity

Concepts will be introduced in lecture and practical exercises and problem solving will be done through tutorials.
Student time will be: Lecture 1/3, Tutorial 1/3, and Laboratory 1/3.

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;
formative assessment;
other scheduled time.

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.

Placements (including work placement and year abroad).

Total hours ('Should be equal to credit x 10') 150.


Methods of Assessment:

Practical Coursework; grading mode - numeric; weighting% - 100; pass mark - 40%; outline details - lab based development of a web based application; are students required to pass all components in order to pass the course - yes.