HPH Relational Database Management Systems by Maria Sarah Raj

Relational Database Management is a practical subject which enables the students to learn to create database components. This book has been specifically prepared, keeping in mind the changing trends in the field of Information Technology. It also seeks to enhance the students learning activities. Computer Science is of course a diverse and rich discipline comprising many different subject areas and database management system is one of them

This book provides comprehensive coverage of fundamentals of database management system who wish a better understanding of relational data modeling, its purpose, its nature, and the standards used in creating relational data model. Relational databases are the most popular database management systems and are supported by a variety of people.

Contents :

UNIT – I
1. Introduction to Database.
2. Evolution of Database systems.
3. Database Administrator.
4. Data Models.
5. Components of DBMS.
6. Database Approach Objectives.
7. Advantages of Database approach.
8. Components of Database Environment.
9. Application Sharing.
10. Risks and costs of Database.
11. Database development life cycle (DDLC)
UNIT – II
1. Fundamentals of Database.
2. Attribute, Entity, object.
3. E-R Model.
4. Relationship Definition.
5. Degrees of relationship.
6. Specialization.
7. Generalization.
8. Aggregation.
9. Relational Data Model.
10. Keys.
11. Normalization.
12. Relational Algebra.
13. Different types of joins