Database Management System is very vital concept in modern computer era. Knowledge of database plays an important role for the success of education in computer science. In this book we give the basic concepts of database management. These concepts include features of database design, languages and implementation. Details of particular database system are discussed in the "Case Studies".

Unit 1 (Introduction to Database) present overview of the database system. We define how the basics of database system have developed, what the characteristics of database are, and how database interact with operating system.

Unit II (Database Design) concentrate on E-R diagram, define entity, attribute, relationship. entity set, and relationship set etc. This unit is also focus on different types of keys like primary key, foreign key and candidate key.

Unit III (Relational Data Model and Languages) present concepts of relational data model in which a database is a collection of one or more relations, where each relation in a table have rows and columns. This unit also provides various constraints like integrity, domain and entity integrity constraints, referential integrity, and foreign key integrity.

Unit IV (Normalization) defines the theory of relational database design. The theory of functional dependencies and normalization is focus on the motivational and instinctive understanding of each normal form. This allows the concept of normalization to be introduced prior to full coverage of functional dependency theory. Students must get the clear concept of normalization with the help of appropriate example.

Unit V (Transaction Management) provides on fundamentals of a transaction-processing system, including transaction atomicity, consistency, isolation, durability and serializability.

Unit VI (Concurrency Control) concentrates on concurrency control and presents vario techniques for ensuring serializability, including locking, timestamping and validation techniqu This unit also covers deadlock issues.

We have also discuss the case study of Bus Reservation system which is categorize into phases viz. Design and Implementation phase and finally the key feature of provides thin model question papers with complete solutions.

No other version available

No Data