CAS 767

CAS 767 DATABASE MANAGEMENT SYSTEMS

Objectives:

  • To understand the needs of a database management system.
  • To provide a solid technical overview of database management systems, both in terms of usage and implementation.
  • To be aware of emerging database technologies.

 

Introduction : Database System -– Views– Data Models – Database Languages –– Database System Architecture – Database users and Administrator – E-R model – E-R Diagrams -- Introduction to relational databases

Relational model: The relational Model -Keys - Relational Algebra – Domain Relational Calculus – Tuple Relational Calculus - Fundamental operations – Additional Operations- SQL fundamentals - Integrity – Triggers - Security – Advanced SQL features –Missing Information– Views –

Database design: Functional Dependencies – Non-loss Decomposition – Functional Dependencies – First, Second, Third Normal Forms, Dependency Preservation – Boyce/Codd Normal Form-Multi-valued Dependencies and Fourth Normal Form – Join Dependencies and Fifth Normal Form

Transactions :Transaction Concepts - Transaction Recovery – ACID Properties – System Recovery –Media Recovery – Two Phase Commit - SQL Facilities for recovery – Concurrency– Need for Concurrency – Locking Protocols – Two Phase Locking – Intent Locking – Deadlock- Serializability – Recovery Isolation Levels

Emerging systems: Distributed Data bases – Object oriented Data bases - Mobile Databases-XML and Web Databases. Active and Deductive Databases - Multimedia Databases– Multimedia Data Structures – Multimedia Query languages - Spatial Databases.

 

References:

  1. Ramez Elmasri and Shamkant B. Navathe, “Fundamentals of Database Systems”, 4th Edition, Pearson / Addision wesley, 2007.
  2. 2.Thomas Connolly and Carlolyn Begg, “Database Systems, A Practical Approach to Design, Implementation and Management”, 3rd Edition, Pearson Education, 2003.
  3. 3.Abraham Silberschatz, Henry F. Korth and S. Sudharshan, “Database System Concepts”,5th Edition, Tata McGraw Hill, 2006.

     

     Outcomes:

 Students will be able to:

                Understand the role of a database management system in an organization.

                Assimilate basic database concepts and construct database queries using SQL.

                Apply logical database design principles in solving real world problems.