Database Managemet System

Name of the Faculty : Mahesh singh
Discipline : B.TECH
semester : Vth semester
subject:DATABASE MANAGEMENT SYSTEMS
Paper Code : PCC-CS-501
Lesson plan duration : July 2019 to december 2019
work load lecture per week(in hours) : 3 lectures
Week	Theory		Practical
	Lecture Day	Topic (including assignment/test)	Practical Day	Topic
					1st	1	Introduction to Database system architecture	1	INTRODUCTION TO ORACLE DATA TYPES OF SQL
2	Data abstaction and Data independence
3	Concept of DDL and DML
2nd	4	Data Models and its types	2	To write a query on creation and modification of relations using STUDENT DATABASE.
	5	Data manipulation operations
	6	Summerization of module 1
3rd	7	introduction to Relational query languages	3	To write a query on creation and modification of relation EMPLOYEE AND DEPTT.
	8	Relatonal algebra and relational calculus
	9	Open source & Commercial DBMS  MYSQL, ORACLE, DB2
4th	10	data base server and SQL server	4	Some of the Most Important SQL Commands DDL and DML Commands   Data Definition Language Commands                                                                  Data Manipulation Language Commands
	11	Relational database design
	12	and data dependency, Armstrong’s axiom
5th	13	Normalization and Normal form	5	To write a query creation and modification of relation
	14	Query processing and optimization
	15	Query optimization algorithms.
6th	16	Storage strategies	6	Create and manipulate :                                                                                                                                                                       BOOK DEALER DATABASE .                                                                              ENTERPRISE DATABASE
	17	B-trees, hashing
	18	hsahing properties
7th	19	Transaction processing and ACID properties	7	NSURANCE DATABASE,                                                                                                                     ORDER PROCESSING DATABASE,                                                                            STUDENT ENROLLMENT DATABASE
	20	Serializability of scheduling
	21	introduction to cuncurrency control method
8th	22	Locking and timestamp based schedulers	8	HOSPITAL MANAGET SYSTEM:DOCTOR TABLE, NURSE TABLE, WARD TABLE,PATIENT &UNDERGOES
	23	Multi-version and optimistic Concurrency Control
	24	Database recovery approches
9th	25	introduction Database Security	9	To create queries using Triggers
	26	Authentication, Authorization and access control Intrusion detection
	27	DAC, MAC and RBAC models
10th	28	Object oriented database	10	Nested Queries And Join Queries
	29	Logical databases
	30	ordbms and Web databases
11th	31	Distributed databases and architecture
	32	Data warehousing and data mining.
	33	seummerization of module 6