Database Management System (PGDCA-107)
UNIT - I
Introduction to DBMS
Purpose of database systems, views of data, Data Modeling Relational Model, Network Model, Hierarchical Model, Database Languages - Data definition Language, Data Manipulation Language, Data Control Language Transaction Management, Storage Management, Database Administrator and User, Database System Structure
UNIT - II
E-R Model
Entity Relationship model as a tool for conceptual design-entities, attributes and relationships. ER diagrams, Concept of keys, Case studies of ER modeling Generalization; specialization and aggregation. Converting an ER model into relational Schema
UNIT - III
Database Design
Relational algebra Basic operations like select, Project, Union, set difference, Cartesian product, rename
and additional operations like Set intersection, Natural Join, Division, Join(Left, right and Full) Normalization concept in logical model; Pitfalls in database design, Anomalies-Insert, Update, Delete, Redundancy, Functional dependencies, Decomposition, Normal forms (INF, 2NF, 3NF).
UNIT - IV
SQL-DDL and DML. Commands
Introduction to my SQL language, Structure of my SQL, statements & my SQ1. writing guidelines, Data Definition commands: Creatinga Database, Show, Creating a Table, Use, Altering the Database, Altering the Table, RENAME, DESCRIBE, Dropping the Database, Dropping the Table. SELECT statement that are described in (FROM, WHERE, GROUP BY, HAVING, ORDER BY), INSERT, UPDATE, DELETE, REPLACE
UNIT - V
Database Functions and Security
Aggregate Function (AVG, COUNT, MAX, MIN, SUM). Defining primary keys, foreign keys, Unique Keys, CHECK constraints in a table, removing constraints from table SQL. Sub Queries. Views What is Views, Create, Drop and Retrieving data from views. Security Management of Roles, Changing Password. Granting Roles & Privilege, with drawing privileges.