Database Management System | Relational Database Management System | Computer Notes

DETAILED CONTENTS (Database Management System | Relational Database Management System PDF Notes)

1. Introduction

Database Systems; Database and its purpose, Characteristics of the database approach, Advantages and disadvantages of database systems. Classification of DBMS Users; Actors on the scene, Database Administrators, Database Designers, End Users, System Analysts and Application Programmers, Workers behind the scene (DBMS system designers and implementers, tool developers, operator and maintenance personnel)

2. Database System Concepts and Architecture

Data models, schemas, instances, data base state. DBMS Architecture; The External level, The conceptual level, The internal level, Mappings. Data Independence; Logical data Independence, Physical data Independence. Database Languages and Interfaces; DBMS Language, DBMS Interfaces. Classification of Database Management Systems- Centralized, Distributed, parallel and object based.

3. Data Modeling using E.R. Model (Entity Relationship Model)

Data Models Classification; File based or primitive models, traditional data models, semantic data models. Entities and Attributes, Entity types and Entity sets, Key attribute and domain of attributes, Relationship among entities, Database design with E/R model.

4. Relational Model:

Relational Model Concepts: Domain, Attributes, Tuples cardinlity, keys(Primary, Secondary, foreign, alternative keys) and Relations. Relational constraints and relational database schemes; Domain constraints, Key constraints and constraints on Null. Relational databases and relational database schemes, Entity integrity, referential integrity and foreign key. Comparison b/w E/R model and Relational model.

5. Normalization

Trivial and non-trivial dependencies.

Non-loss decomposition and functional dependencies, First, Second and Third normal forms, Boyce/Codd normal form, denormalization

6. Database Access and Security

Creating and using indexes, creating and using views.

Database security, process controls, database protection, grant and revoke

7. MYSQL/SQL (Structured Query Language)

– SQL* DDL (Data Definition Languages): Creating Tables, Creating a table with data from another table, Inserting values into a table, updating columns of a Table, Deleting Rows, Dropping a Table. DML (Data Manipulation Language): Database Security and Privileges, Grant and Revoke Command, Maintaining Database Objects, Commit and Rollback, various types of select commands, various types of joins, sub query, aggregate functions. Challenges of My SQL. Introduction to Big Data. Understanding Big Data with samples.