| STUDENTS
> Database and Information Management Systems
|
Database and Information Management Systems
Note:
Whilst every effort is made to keep the syllabus and assessment records correct
for this course, the precise details must be checked with the lecturer(s).
Code: | 3013
(Also taught as: GC06)
|
Year: | 3 |
Prerequisites: | Successful completion of years 1 and 2 of the computer science programme. In particular, students must have studied and been successfully examined in COMP2011 (Databases, Networks and Graphics) |
Term: | 2 |
Taught By: | John Dowell (100%)
|
Aims: | This module builds on the introduction to relational databases course in COMP2008. It covers advanced data modelling and database development methodology, the techniques exploited by relational database technologies relating in particular to query processing and transaction management, and post relational database technologies including object oriented databases and web databases. The coursework is an interesting group project lasting the duration of the term and building a web facing database system using very contemporary technologies.
|
Learning Outcomes: | Understanding of the theory, methods and technologies of relational databases and their development. Competence with SQL and in building web facing database systems. Understanding of application issues and current trends in database technologies.
|
Content:
Database development: framework and techniques | |
SQL and query processing | |
Transaction management | |
Architecture of relational database management systems | |
Post-relational databases and their applications | |
Web and database management systems | |
Business intelligence | |
Method of Instruction:
Each week student will attend two 'theory' lectures, and one 'lab' lecture (where they will learn how to use the technologies needed for the coursework). They will also attend one group session in the lab and a tutorial class to support the theory lectures.
Assessment:
The course has the following assessment components:
- Written Examination (2.5 hours, 70%)
- Coursework Section (1 piece, 30%)
To pass this course, students must:
- Obtain an overall pass mark of 40% for all sections combined
The examination rubric is: Answer any 3 questions out of 5. All questions carry equal marks.Resources:
Database systems: A practical guide to design, implementation and management, 3rd edition, Connolly/Begg, Addion Wesley, ISBN: 0-201-70857-4
A comprehensive set of learning materials for the module are provided through moodle (UCL's e-learning environment)
Link to Moodle
|