|
|
home · studies

DataBases ΙΙ |
Module Type: |
Information Technology Track |
Module Code: |
533Î |
Syllabus: |
Review of relational database systems. Multi value and coupling dependencies.
Normal forms (BC-NF, 4th and 5th). Entity model correlations, relational algebra,
QUEL and QBE languages. Data protection: recovery, simultaneity, integrity, security. |
Module Aims-Objectives: |
To analyse the various techniques for the performance optimisation of database systems
via physical design optimisation and synchronisation. To study modern models for database
development such object-oriented and object-oriented – relational databases.
Upon completing this module students should be able to:
1. Optimise the performance of a database employing synchronisation and physical design methods.
2. Design object-oriented and object-oriented – relational databases.
3. Manage the storage of large objects in databases.
4. Design and implement distributed databases.
|
Bibliography: |
• H. Darwen A Guide to the Sql Standard: A User’s Guide to the Standard
Database Language Sql. 4th Edition. Addison-Wesley, 1997.
• C. J. Date Introduction to DataBase Systems. Volume II 6th
edition. Kleidarithmos Publishing, 1996.
• B. C. Desai Introduction to Database Systems. 11th edition. West Information
Pub. Group, 1997.
• R. Elmasri and S. B. Navathe Fundamental Principles of DataBase Systems
Volume II. 2nd edition. Diavlos Publishing, 1996.
• J. M. Nicolas, Η. Gallaire and J. W. Minker (eds.) Advances in Database
Theory. Vol. 2. Plenum Press, New York, 1984.
• R. Vieira Professional SQL Server 2000 Programming. 1st Edition.
Wrox Press Inc., 2000.
• J. D. Ullman Principles of Data and Knowledge-Base Systems, Vol. 2.
Computer Science Press, New York, 1988.
• Lecture Notes.
|
|
|
|
|
|