STCS 44036

>< Type/ Status : Core for students offering the special degree in Statistics and Computer Science
>< Title :Design and Implementation of Database Systems
>< Objectives : At the end of this unit the student will be able to describe the functionalities of a database management system, be familiar with data modelling concepts used in database development be able to design and implement relational databases, be able to demonstrate an understanding of the data integrity and security issues associated with database systems, be able to demonstrate an understanding of transaction management in databases, have an understating of query Processing, effectively use the use the knowledge in an industry oriented database management system, have an understanding of emerging database applications.
>< Course Content :

Introduction to database systems, Database system concepts and architecture, Data Modeling using Entity-Relationship (ER) model and Enhanced Entity-Relationship (EER) model, Introduction to relational model, Relational constraints, Normalization approach for relational database design (first, second, third and BCNF normal forms), Advantages and disadvantages of the normalization approach, Relational algebra and relational calculus, Logical database design: ER to relational mapping and EER to relational mapping, Security and integrity in databases, Physical database design, Storing data and primary file organization, File organization and indexes (primary, secondary, clustering and multilevel indexes), Dynamic index structure B+ tree. Transaction management: Concurrency control and crash recovery, Query Processing and Optimization, Advanced data models and emerging trends.

Practical: Introduction to Oracle 8(or later version): use of objects types, Components of an object type, Methods (map methods, order methods), oracle 8 data types, BLOB, CLOB, BFILE, NCLOB, Controlling transactions, Understanding views, PL/SQL, Creating synonyms, Indexes and snapshots, Partitioned tables and indexes, Data clusters, Handling exceptions, Procedures and functions, Database triggers, Creating a cursor, Auditing and privileges.

>< Methodology : A combination of lectures, tutorials and practical sessions.
>< Scheme of Evaluation : End of course examination, practical examination, seminars and/or assignments.
>< Recommended Reading :
1.Elmasri &Navathe Fundamentals of Database Systems, (1999, 3rd Edition).
2.Ramakrishnan G, Database Management Systems. (3rd Edition).
3.Date C.J. An Introduction to Database Systems. Vol 1 (1999, 7th Edition).
4.Relevant software manuals.

Back