Sem II (2023)

Sr. No

Content

Date

1

Overview

1.2 File system Vs. DBMS

11/1/23 (Please follow the

2

Database models: Relational, Hierarchical and network

date format.)

3

Levels of abstraction

Data independence-

Logical data independence

Physical data independence

4

Instances and Schemas

5

Characteristics of DBMS ,Advantages of DBMS

6

Applications of DBMS

7

Types of Users , Types of databases

8

Data Dictionary

9

Overview of DB design

10

Relational Model: Relation, Domain & attributes

11

ER data model (entities, attributes, entity sets, relations, relationship sets) ,

Conversion of ER to Relational model

12

keys

13

Decomposition

2.5.1 Problems Related to Decomposition

Desirable Properties of Decomposition

14

Functional dependencies

Types of Functional Dependencies

Full Functional Dependencies

Partial Dependencies

Transitive Dependencies

15

Trivial Dependencies

Multi valued Dependencies

16

Closure of set of Functional Dependencies

Closure of Attribute set

17

An algorithm to find the candidate key for a

Relation R

18

Canonical Cover , Prime attribute and Non-Prime Attribute

19

Properties of Decomposition

Loss less Join Decomposition

Dependency Preserving

20

Normalization. lNF, 2NF

21

Normalization. 3NF and BCNF

22

Case studies

23

Introduction to SQL

24

DDL Commands : CREATE, ALTER, DROP for tables

DML Commands; SELECT, INSERT, DELETE and UPDATE

25

Order by clause

26

Group By and Having clause

27

Joins and Types of Joins

28

Sub queries and nested sub queries

29

View and DML operations on view

30

Sequences

31

Case studies on SQL

32

Transaction Concepts

Properties of Transactions

State of the Transaction

33

Concurrent Transactions

Problems in concurrent transactions

34

Types of schedule based on order of operations

Types of schedules based on recoverability

35

Conflict Serializability

4.5.2 Precedence graph of Serializability

4.5.3 View Serializability

36

Concurrency control mechanisms

37

Deadlock

Deadlock Avoidance

38

Deadlock Prevention Algorithms

39

Deadloclc Detection

40

Recovery from deadlock

41

Domain Constraints

5.3 Referential Integrity

42

Methods of Database security

5.5 Discretionary Access Control ( DAC) method

43

Granting Privileges

5.5.2 Specifying Privileges using views

5.5.3 Revoking Privileges

5.5.4 Propagation of Privileges using the Grant Option

44

Mandatory Access Control Method

45

Introduction to NoSQL, Brief history of NoSQL, feed of NoSQL, RDBMS vs NoSQL, CAP Theorem, NoSQL pros/cons , NoSQL Categories - Key-value stores, Column-oriented, Graph, Document oriented

Sr. No

Content

Date

1

Installation and configuration of MYSQL

2

Draw ER-Diagram for Bank Management System

3

Assignment on DML commands-select, Insert, Delete, Update

4

Assignment on DDL commands-create, alter, drop, truncate, rename, comment, flashbaclc

5

Assignment on Constraints- Primary key, Unique Key, Check ,full, Referential integrity constraint

6

Restricting and Sorting Data using where clause and order by clause

7

Assignment on accepting Data from users-Substitution variables

8

Assignment on Slngle Row Functions to customize output

9

ASSlgnment on Conversion Functions and Conditional Statements

10

Assignment on Group Functions

11

Assignment on displaying data from multiple tables using jolns.

12

Assignment on Sub queries, nested sub queries

13

Assignment on DCL commands- Grant, Revoke

14

Assignment on TCL command—s commit, rollback, save point

15

Assignment on Views

16

Installing MongoDB on Windows

17

Data Types in Mongo DB, Database Create and Drop, CRUD Operations in

Mongo DB