STCS 31015

>< Type/ Status : Core for students offering Statistics and Computer Science as a subject
>< Title : Database Management 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 modeling concepts used in database development, be able to design and implement relational databases, use an industry relevant query language effectively to create and manipulate a relational database, demonstrate an understanding of data integrity and security issues associated with database systems and how these are addressed in relational database management systems.
>< 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 the 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, Data Manipulation using SQL, Security and integrity in databases, Physical database design, Introduction to transaction management in databases, Storing data and primary file organization, File organization and indexes (primary, secondary, clustering and multilevel indexes), Dynamic index structure B+ tree.

Practical sessions: Using MS Access and SQL.

>< Methodology : A combination of lectures, tutorials and practical sessions.
>< Scheme of Evaluation : End of semester examination, assignments and practical examination.
>< Recommended Reading :
1. Elmasri and 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).

Back