Biju Patnaik University of Technology, Odisha, Computer Engineering Semester 5, Database Management Systems Syllabus

Database Management Systems Lecture notes | Videos | Free pdf Download | Previous years solved question papers | MCQs | Question Banks| Syllabus
Get access to 100s of MCQs, Question banks, notes and videos as per your syllabus.
Try Now for free

Unit - 1 Introduction

Unit 1

Introduction

1.1 Purpose of Database System

1.2 Views of data

1.3 Data models

1.4 Database management system

1.5 Threeschema architecture of DBMS

1.6 Components of DBMS

1.7 ER Model Conceptual data modelling

1.8 Motivation

1.9 Entities

1.10 Entity types

1.10 Attributes relationships

1.11 Relationship types

1.12 ER diagram notation

1.13 Examples

Unit - 2 Relational Model

Unit 2

Relational Model

2.1 Relational Data Model

2.2 Concept of relations

2.3 Schemainstance distinction

2.4 Keys

2.5 Referential integrity and foreign keys

2.6 Relational algebra operators

2.7 SQL – Introduction

2.8 Data definition in SQL

2.9 Table

2.10 Key and foreign key definitions

2.11 Update behaviours

2.12 Querying in SQL

2.13 Notion of aggregation

2.14 Aggregate functions group by and having clauses

2.15 Embedded SQL

Unit - 3 Database Design

Unit 3

Database Design

3.1 Dependencies and Normal forms

3.2 Dependency theory Functional dependencies

3.3 Armstrongs axioms for FDs

3.4 Closure of a set of FDs

3.5 Minimal covers

3.6 Definitions of 1NF 2NF 3NF and BCNF

3.7 Decompositions and desirable properties of them

3.8 Algorithms for 3NF and BCNF normalization

3.9 4NF

3.10 5NF

Unit - 4 Transactions

Unit 4

Transactions

4.1 Transaction processing and Error recovery Concepts of transaction processing

4.2 ACID properties

4.3 Concurrency Control Lockbased protocols

4.4 Error recovery and logging

4.5 Undo

4.6 Redo

4.7 Undoredo logging and recovery methods

Unit - 5 Implementation Techniques

Unit 5

Implementation Techniques

5.1 Data Storage

5.2 Indexes File organizations

5.3 Primary Secondary index structures

5.4 Various index structures hashbased dynamic hashing techniques

5.5 Multilevel indexes B trees

Download CSE Sem 5 syllabus pdf
Get access to 100s of MCQs, Question banks, notes and videos as per your syllabus.
Try Now for free
Other Subjects of Semester-1
Operating systems
Formal languages and automata theory
Artificial intelligence and machine learning
Popular posts
Top 10 free online resources to learn coding
What is machine learning
What is cloud computing
What is DBMS architecture
Sorting algorithm overview
Share  
Link Copied
More than 1 Million students use Goseeko! Join them to feel the power of smart learning.
Spot anything incorrect? Contact us