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.
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.
9. Relational Data Model.
12. Relational Algebra.
13. Different types of joins
UNIT – III
1. Structured query language (SQL)
2. Role of SQL in DatabaseArchitecture
3. Data Schema and Table Definition
4. Data Manipulation & Database Change operations
5. SQL Operators
6. Dual Table in ORACLE
7. Null value Concepts
8. Aggregate functions or group functions
9. Nested queries &Correlated Nested Queries
10. Grouping Data from tables
11. Views or Virtual tables
12. Client server Database systems.
UNIT – IV
1. File organization and Addressing Methods
2. Mapping logical data structures to physical datastructures
3. Database administration.
4. Functions of DBA
5. Goals of DBA
6. Database security
7. Database recovery
UNIT – V
1. Need of distributed databases
2. Data integrity
3. Client server systems
4. Two tire architecture.
5. DBMS functions and Capabilities
6. DBMS feature requirements
7. Implementation issues