Shivaji University, Maharashtra, Computer Engineering Semester 6, Database Engineering Syllabus

Database Engineering 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 and Database Modeling using ER Model

1.1 General introduction to database systems and its advantages applications

1.2 Database System Architecture

1.3 Database users and Administrator

1.4 Data models

1.5 Database management system

1.6 Database languages

1.7 View of Database

1.8 Data Models

1.9 ER Model

1.10 Entity set Entity types

1.11 Attributes

1.12 Notations

1.13 Relationship sets Relationship types

1.14 Keys super key candidate key primary key

1.15 Extended Features of ER ModelGeneralization

1.16 Specialization and aggregation

Unit - 2 Data Modeling and SQL

2.1 Concept of relations

2.2 Schemainstance distinction

2.3 Referential integrity and foreign keys

2.4 Relational algebra

2.5 Various types of joins

2.6 Tuple relation calculus

2.7 Example queries

2.8 Introduction to SQL

2.9 Data definition statements with constraints

2.10 Update behaviours

2.11 Nested Queries

2.12 Aggregate functions group by and having clauses

Unit - 3 Database Design

3.1 Importance of a good schema design

3.2 Motivation for normal forms

3.3 Dependency theory functional dependencies

3.4 Closure of a set of FDs

3.5 Definitions of 1NF 2NF 3NF and BCNF

3.6 Decompositions and desirable properties of them

3.7 Multivalued dependencies and 4NF

3.8 Join dependencies and definition of 5NF 

Unit - 4 Data Storage and Indexes

4.1 File organizations

4.2 Primary Secondary index structures

4.3 Various index structures hashbased dynamic hashing techniques

4.4 Multilevel indexes B tree indices

4.5 Multiple key accesses

Unit - 5 Transaction Processing and Concurrency Control

5.1 Concepts of transaction processing

5.2 ACID properties

5.3 Transaction states

5.4 Implementation of atomicity Isolation and Durability

5.5 Serializability Testing for serializability

5.6 Concurrency Control Lockbased protocols Timestamp based Protocols Validation based Protocols

5.7 Multiple Granularities

5.8 Deadlock handling

Unit - 6 Recovery System

6.1 Failure classification

6.2 Storage structure

6.3 Implementation of stable storage

6.4 Recovery and Atomicity

6.5 Log based recovery

6.6 Checkpoints

6.7 Shadow Paging

6.8 Buffer management in crash recovery

Download CSE Sem 6 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-2
Operating system-ii
Compiler construction
Engineering economics
Object oriented modeling and design
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