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
Computer Engineering
Database Management Systems
Savitribai Phule Pune University, Maharashtra, 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 To Database Management Systems And ER Model
Unit 1
Introduction to Database Management Systems and ER Model
1.1 Introduction
1.2 Purpose of Database Systems
1.3 DatabaseSystem Applications
1.4 View of Data
1.5 Database Languages
1.6 Database System Structure
1.7 Data Models
1.8 Database Design and ER Model Entity Attributes Relationships Constraints Keys
1.9 Design Process
1.10 Entity Relationship Model ER Diagram
1.11 Design Issues
1.12 Extended ER Features
1.13 Converting ER and EER diagrams into tables
Unit - 2 SQL And PL-SQL
Unit 2
SQL and PLSQL
2.1 SQL Characteristics and Advantages
2.2 SQL Data Types and Literals DDL DML DCL TCL
2.3 SQL Operators
2.4 Tables Creating Modifying Deleting Updating
2.5 SQL DML Queries SELECT Query and clauses
2.5 Index and Sequence in SQL
2.6 Views Creating Dropping Updating using Indexes
2.7 Set Operations
2.8 Predicates and Joins
2.9 Set membership
2.10 Tuple Variables
2.11 Set comparison
2.12 Ordering of Tuples
2.13 Aggregate Functions
2.14 SQL Functions
2.15 Nested Queries
2.16 PLSQL Concept of Stored Procedures and Functions
2.17 Cursors
2.18 Triggers
2.19 Assertions
2.20 Roles and Privileges
Unit - 3 Relational Database Design
Unit 3
Relational Database Design
3.1 Relational Model Basic concepts Attributes and Domains
3.2 CODDs Rules
3.3 Relational Integrity Domain Referential Integrities Enterprise Constraints
3.4 Database Design Features of Good Relational Designs
3.5 Normalization
3.6 Atomic Domains and First Normal Form
3.7 Decomposition using Functional Dependencies
3.8 Algorithms for Decomposition
3.9 2NF 3NF BCNF
3.10 Case Study Normalize relational database designed in Unit I
Unit - 4 Database Transaction Management
Unit 4
Database Transaction Management
4.1 Introduction to Database Transaction Transaction states
4.2 ACID properties
4.3 Concept of Schedule
4.4 Serial Schedule
4.5 Serializability Conflict and View Cascaded Aborts Recoverable and Nonrecoverable Schedules
4.5 Concurrency Control Lockbased Timestamp based Deadlock handling
4.6 Recovery methods ShadowPaging and LogBased Recovery
4.7 Checkpoints
4.8 LogBased Recovery Deferred Database Modifications and Immediate Database Modifications
Unit - 5 NoSQL Databases
Unit 5
NoSQL Databases
5.1 Introduction to the Distributed Database System Advantages Disadvantages CAP Theorem
5.2 Types of Data Structured Unstructured Data and SemiStructured Data
5.3 NoSQL Database Introduction Need Features
5.4 Types of NoSQL Databases Keyvalue store document store graph wide column stores BASE Properties Data Consistency model ACID Vs BASE Comparative study of RDBMS and NoSQL
5.5 MongoDB with syntax and usage CRUD Operations Indexing Aggregation MapReduce Replication Sharding
5.6 Case Study Use of NoSQL databases for processing unstructured data from social media
Unit - 6 Advances In Databases
Unit 6
Advances in Databases
6.1 Emerging Databases Active and Deductive Databases Main Memory Databases Semantic Databases
6.2 Complex Data Types SemiStructured Data Features of SemiStructured Data Models
6.3 Nested Data Types JSON XML
6.4 Object Orientation ObjectRelational Database System Table Inheritance Object Relational Mapping
6.5 Spatial Data Geographic Data Geometric Data
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
Theory of computation
Computer networks and security
Systems programming and operating system
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.
Try For Free
Spot anything incorrect?
Contact us