Savitribai Phule Pune University, Maharashtra (SPPU), Electronics and Telecommunications Semester 5, Database Management Syllabus

Database Management 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 To DBMS

Unit 1

Introduction to DBMS

1.1 Introduction to Database Management Systems

1.2 Purpose of Database Systems

1.3 DatabaseSystem Applications

1.4 Data Abstraction and Database System Structure

1.5 Relational Model Structure of relational databases Domains Relations

1.6 Relational algebra – fundamental operators and syntax relational algebra queries

1.7 Tuple relational calculus

1.8 EntityRelationship model Basic Concepts Entity Set Relationship Sets and Weak Entity Sets

1.9 Mapping Cardinalities

1.10 Keys

1.11 ER diagrams

1.12 Design Issues

1.13 Extended ER Features

1.14 Converting ER EER diagram into tables

Unit - 2 Relational Database Design

Unit 2

Relational Database Design

2.1 Basic concepts

2.2 CODDs Rules

2.3 Relational Integrity Domain Referential Integrities Enterprise Constraints

2.4 Database Design Features of Good Relational Designs

2.5 Normalization

2.6 Atomic Domains and First Normal Form

2.6 Decomposition using Functional Dependencies

2.7 Algorithms for Decomposition

2.8 2NF 3NF 4NF and BCNF

Unit - 3 Basics Of SQL

Unit 3

Basics of SQL

3.1 DDL DML DCL Structure Creation Alteration

3.2 Defining constraints – Primary key Foreign key Unique key Not null Check IN operator

3.3 Functions Aggregate Function

3.4 Builtin Functions –Numeric Date String Functions

3.5 Set operations

3.6 Subqueries correlated subqueries

3.7 Use of group by having order by

3.8 Join and its types Exist Any All

3.9 View and its types

3.10 Transaction control commands Commit Rollback

3.11 Savepoint PLSQL Concepts Cursors

3.12 Stored Procedures

3.13 Stored Function

3.14 Database Triggers

Unit - 4 Database Transactions Management

Unit 4

Database Transactions Management

4.1 Basic concepts of a Transaction

4.2 Transaction Management

4.3 Properties of Transactions

4.4 Concept of Schedule

4.5 Serial Schedule

4.6 Serializability Conflict and View

4.7 Cascaded Aborts Recoverable and Nonrecoverable Schedules

4.8 Concurrency Control Need Locking Methods

4.9 Deadlock handling and Timestamp based Protocols

Unit - 5 Parallel Databases

Unit 5

Parallel Databases

5.1 Introduction to Database Architectures Multiuser DBMS Architectures

5.2 Case study Oracle Architecture

5.3 Parallel Databases Performance Parameters for Parallel Databases

5.4 Types of Parallel Database Architecture

5.5 Evaluating Parallel Query in Parallel Databases and Virtualization on Multicore processors

Unit - 6 Distributed Databases

Unit 6

Distributed Databases

6.1 Distributed Databases Distributed Database Management System

6.2 Factors Encouraging DDBMS

6.3 Advantages of Distributed Databases

6.4 Types of Distributed Databases

6.5 Architecture of Distributed Databases

6.6 Distributed Database Design

6.7 Distributed Data Storage

6.8 Distributed Transaction Basics Failure modes

6.9 Commit Protocols

6.10 Concurrency Control in Distributed Database

Download ENTC 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
Microcontroller
Digital communication
Digital signal processing
Electromagnetic field theory
Popular posts
What is race around condition
Top 5 websites for academic research
Top 5 interview advice for engineers
Multiplexrs and demultiplexers
What is convolution theorem
Share  
Link Copied
More than 1 Million students use Goseeko! Join them to feel the power of smart learning.
Spot anything incorrect? Contact us