Study material
Engineering
Computer Engineering
Information Technology
Electrical Engineering
Civil Engineering
Mechanical Engineering
Electronics and Communications
Electronics and Telecommunication
Electrical and Electronics
B.Com
B.A
BBA
BAF
BMS
New Test BE-Btech
Demo BE-Btech
Prod BE-BTech
Blog
Log in
Become a data analyst in the next 4 months and kickstart your career.
100% placement assistance.
Start your Analytics journey with our free
Python course.
Explore Now
Home
Universities
Savitribai Phule Pune University, Maharashtra (SPPU)
Electronics and Telecommunications
Database Management
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.
Try For Free
Spot anything incorrect?
Contact us