SCHOOL OF COMPUTING AND INFORMATION TECHNOLOGY
SUBJECT: COMPUTING
| Module Code &Title |
CP3342 Database Technology |
| Year of Delivery & Semester |
2000/2001 Semesters 1 & 2 |
| Author Name & Date of issue |
Mary Garvey 15 February 2001 |
| Pre-requisites |
Software Engineering Principles, IS Case Study or Software Development and CP1184, CP2240 Introduction to Databases or CP2001 Multi-User Databases |
| Pre-requisite Skills and Knowledge |
Practical experience of SQL Reading knowledge of relational algebra Elementary entity relationship modelling skills Knowledge of relational database principles and terminology Ability to normalise data to third normal form An appreciation of software engineering principles and practice |
| Co-requisites |
None |
| Module level and Credits |
15 credits at level 3 |
| Excluded module combinations: |
None |
| Proposed timetable slots with site: |
Lectures: Monday 18:00-20:00 (Semester1) Seminars: Monday 20:00-21:00 (Semester1) Main Site |
| Module Leader |
Mary Garvey, MU106, 321483, M.Garvey@wlv.ac.uk |
| School fax number: |
+44 (0)1902 321491 |
| Other members & room number & phone number & email |
Semester one: Mike Jackson, MU215, 321429, M.S.Jackson@wlv.ac.uk Semester two: Tony Atherden, MU343, 321442, A.Atherden@wlv.ac.uk; Bernadette Byrne, MU217, 321838, B.Byrne@wlv.ac.uk |
| Availability of staff: |
Contact via email |
Description of Module
| A database management system is an extremely complex piece of software. This module is an advanced database module that concentrates on the technical aspects of database management systems. The module includes a variety of topics, which cover both relational and post-relational systems. |
Learning Outcomes
At the end of the module, the students will be able to:
| Subject Specific Outcomes |
Assessment Component |
| (I) Critically assess some new developments in database technology
(II) Interpret and explain current issues in database research.
(III)Evaluate the contribution of database theory to practical implementations of database management systems
|
3 1, 2 1, 2 |
| Personal Transferable Skills |
|
| Communicate effectively Gather information |
3 1, 2, 3 |
Weekly programme: (NB: may be subject to amendment)
| Teaching Week |
Topics |
| 1 |
Relational model. Codd's 12 rules for the relational model. |
| 2 |
Query optimisation in Relational databases. |
| 3 |
Shortcomings and failings of SQL. |
| 4 |
Database Performance tuning in Oracle. |
| 5 |
Object-Oriented Databases; Object-Relational Database. |
| 6 |
Concurrency control in relational databases. |
| 7 |
Further SQL shortcomings: an industrial perspective. (Invited talk). |
| 8 |
Data Warehousing and Data Mining |
| 9 |
Temporal Databases |
| 10 |
Interfacing databases to the Web |
| 11 |
Deductive Databases |
| 12 |
Distributed relational databases. |
| 13 |
Revision |
| 14-15 |
Examination period |
Garvey M. and Jackson M., "CP3342 Database Technology Lecture Notes", SCIT internal publication (available from on-site bookshop).
Atzeni P., Ceri S., Paraboschi S and Torlone R., 'Database Systems: Concepts, Languages and Architectures', McGraw-Hill, 1999, ISBN 0-07-709500-6
Date C. J., "Introduction to Databases", Volume 1, seventh edition, Addison-Wesley 2000, ISBN: 0-201-38590-2.
Gardarin G. and Valduirez P., "Relational Database and Knowledge Bases", Addison-Wesley 1989
Ramakrishnan R. and Gehrke J., “Database Management Systems”, second edition, McGraw-Hill 2000, ISBN: 0-07-232206-3
Siberschatz A, Korth H. and Sudarshan S., "Database System Concepts", third edition, Mc-Graw Hill, 1997 ISBN: 0-07-114810-8
Ullman J. D., "Principles of Database and Knowledge-Base Systems", Volumes 1 & 2, Computer Science Press 1988, ISBN: 0-7167-8158-1
Ullman J.D. and Widom J., "A First Course in Database Systems", Prentice Hall, 1997, ISBN: 0-13-861337-0
| Teaching and Learning Methods |
Lectures and tutorials to deliver the theoretical material in the module. Seminars, which will involve student presentations, will complement the taught material. |
| Student contact hours |
3 hours per week |
| Student self directed hours |
7 hours per week |
Assessment Component 1 consisting of 1 element:
Individual exercise, which will be based on a topic complementary to the taught material: 30%
Week of issue: teaching week 4
Deadline: teaching week 9
Hand in at Student Registry (ground floor MT block for courses taught on main site).
Assessment Component 2 consisting of 1 element:
Seminar presentation – peer group assessed: 20%
Presented throughout the module.
Assessment Component 3 consisting of 1 element:
3 hour examination (seen) in the exam period (teaching weeks 14 and 15): 50%
A pass of D5 or above must be obtained in each of the components. Compensation between components is not allowed.
Penalties for late submission of coursework
Standard School of Computing and Information Technology arrangements apply.
"ANY late submission (without valid cause) will result in the grade F0 being allocated to the coursework."
Student collects SCIT form entitled “EX01 - request for extension” from the student registry. Student takes form to the appropriate year or personal tutor (not the module leader) who agrees a new submission date. The tutor sends the form to the module leader for agreement.
Issued with each assignment.
Where a component has been failed and an E grade awarded for the module, reassessment will normally take place in the following September.
Assignments will be normally returned within three working weeks.
Please ensure that you are registered on this module. You should see your course leader/personal tutor if you are not sure what this means. The fact that you are attending module lectures and classes does not mean that you are necessarily registered. A grade may not be given if you are not registered.
Cheating is any attempt to gain unfair advantage by dishonest means and includes plagiarism and collusion. Cheating is a serious offence. You are advised to check the nature of each assessment. You must work individually unless it is a group assessment. Refer to the subject guide for more details.