This course is intended to provide an understanding of the theoretical and practical issues that influence the design and implementation of database management system. These include the Relational Model – relations, domains, attributes, keys, dependencies, normalization, relationship between relations, data models and data sublanguages. This course also intend to provide database system features of concurrency control and locking Recovery and security, and integrity of data management, transaction management, the database models, query optimizing strategies, object-oriented databases and new requirement of database systems.
This course intends to make student to
- Discuss the role of a database management system in an Organization.
- Demonstrate the logical database design principles, including E-R diagrams and database normalization.
- List and explain the fundamental concepts of a relational database system, including the structure and Operation of the relational data model.
- Construct a relational database using a relational database package.
- Apply a database using Structured Query Language (SQL).
- Apply in a program that interacts with a DBMS server.
