Other university, Computer Engineering , 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 Third Year syllabus pdf
Get access to 100s of MCQs, Question banks, notes and videos as per your syllabus.
Try Now for free
Other Subjects of third-year
Compiler design
Machine learning
Computer networks
Software engineering
Theory of computation
Artificial intelligence
Advance java programming
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