? Credit Points : 10  ? SCQF Level : 11  ? Acronym : INF-P-AD

Applied Databases covers the practical application of current database technology and strategies for dealing with complex data. The course will focus on the practical application Relational Database Systems with reference to the underlying design limitations of such systems.

? Pre-requisites : For Informatics PG students only, or by special permission of the School.

? This course has variants for part year visiting students, as follows

• Applied Databases (VS1) (Semester 1 (Blocks 1-2))
• Applied Databases (VS1) (Semester 1 (Blocks 1-2))
• Applied Databases (VS1) (Semester 1 (Blocks 1-2))
• Applied Databases (VS1) (Semester 1 (Blocks 1-2))
• Applied Databases (VS1) (Semester 1 (Blocks 1-2))

Home subject area

Bioinformatics, (School of Informatics, Schedule O)

Other subject areas

Neuroinformatics, (School of Informatics, Schedule O)

Net-Centric Computing, (School of Informatics, Schedule O)

Database Systems, (School of Informatics, Schedule O)

Learning from Data, (School of Informatics, Schedule O)

? Normal year taken : Postgraduate

? Delivery Period : Semester 1 (Blocks 1-2)

? Contact Teaching Time : 2 hour(s) per week for 10 weeks

First Class Information

Date Start End Room Area Additional Information 27/09/2006 09:00 10:50 Room A9/11, Forrest Hill

All of the following classes

Type Day Start End Area Lecture Wednesday 09:00 10:50 Central

It is anticipated that students who successfully complete the course will be able to:
-Discuss the application of database systems in Informatics
-Describe how database systems work
-Analyse data and describe using common description methods such as ER diagrams and XML
-Convert ER schema into relational tables, populate a relational database and run queries on the data
-Design and implment appropriate interfaces (middleware) to database systems
-Disucss the limitations of database and data handling technologies
-Explain the relationship between database limitations and the underlying technology
-Contrast relational systems with semi-structured approaches
-Describe examples of current research in the field

Written Examination 70%
Assessed Assignments 30%

Exam times

Diet Diet Month Paper Code Paper Name Length 1ST May 1 - 2 hour(s)

The Course Secretary should be the first point of contact for all enquiries.

Course Secretary

Mr Neil McGillivray
Tel : (0131 6)50 2701
Email : Neil.McGillivray@ed.ac.uk

Course Organiser

Dr Douglas Armstrong
Tel : (0131 6)50 4492
Email : Douglas.Armstrong@ed.ac.uk

Course Website : http://www.inf.ed.ac.uk/teaching/courses/

School Website : http://www.informatics.ed.ac.uk/

College Website : http://www.scieng.ed.ac.uk/