Course Information Undergraduate prospectus

Database Techniques

Course summary

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

Specification

Aims

In today's world, data is power, but the real secret to success is having power over your data.
Effective data storage and retrieval skills is must have for any IT specialist as databases are so ubiquitous, therefore students need to understand the fundamentals of designing and building robust and flexible database applications. This course aims to start to develop the student's ability to apply system building tools and techniques in order to eventually construct high quality systems to meet the needs of business. The course is practically based and uses a case study approach to give students the grounding they require to take courses at a higher level.

Learning outcomes

On completing this course successfully you will be able to:

Prepare a database design to model a given user requirement.
Map a database model to a database schema.
Use the basic facilities of a Relational Database Management System to construct a database.
Build and test a variety of database queries.

Indicative content

Database technology, its principles, benefits, techniques and practical applications.
Relational Database Management Systems.
Basic Database modelling (ERD); tables, attributes, relationships, keys.
Database schema design.
Structured Query Language (SQL).

Teaching and learning activity

Concepts will be introduced in lectures and practical exercises and problem solving will be done through tutorials.

Each week there will be: Lecture 1 hour, Tutorial 1 hour, Laboratory 1 hour.

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

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 0.

Placements (including work placement and year abroad) 0.

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

Assessment

Coursework - 100% weighting;
3000 words plus code to develop and query a DB.
Outline details: Individual Work. Design a database system for a given case study and demonstration
Last item of assessment.