Bihar Engineering University, Bihar, Information Technology Semester 4, Database Management System Syllabus

Database Management System 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 Database system architecture

Unit1

Database system architecture

1.1 Data Abstraction

1.2 Data Independence

1.3 Data Definition Language DDL

1.4 Data Manipulation Language DML

1.5 Data models

1.6 Integrity constraints

1.7 Data manipulation operations

Unit - 2 Relational query languages

Unit 2

Relational query languages

2.1 Relational algebra

2.2 Tuple and domain relational calculus

2.3 SQL3

2.4 DDL and DML constructs

2.5 Open source and Commercial DBMS MYSQL

2.6 Domain and data dependency

2.7 Armstrong’s axioms

2.8 Normal forms

2.9 Dependency preservation

2.10 Lossless design

2.11 Evaluation of relational algebra expressions

2.12 Query equivalence

2.13 Join strategies

2.14 Query optimization algorithms

Unit - 3 Storage strategies

Unit3

Storage strategies

3.1 Storage strategies Indices

3.2 Btrees

3.3 Hashing

Unit - 4 Transaction processing

Unit 4

Transaction processing

4.1 Concurrency control

4.2 ACID property

4.3 Serializability of scheduling

4.4 Locking and timestampbased schedulers

4.5 Multiversion and optimistic Concurrency Control schemes

4.6 Database recovery

Unit - 5 Database Security

Unit 5

Database Security

5.1 Database Security Authentication

5.2 Authorization and access control

5.3 DAC MAC and RBAC models

5.4 Intrusion detection

5.5 SQL injection

Unit - 6 Advanced topics

Unit 6

Advanced topics

6.1 Object oriented and object relational databases

6.2 Logical databases

6.3 Web databases

6.4 Distributed databases

6.5 Data warehousing and data mining

Download IT Sem 4 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
Machine learning
Formal language & automata theory
Computer organization & architecture
Management i (organizational behaviour)
Popular posts
Top 10 free online resources to learn coding
What is machine learning
Top 10 jobs in information technology
An overview of object oriented programming
What is sorting algorithm
Share  
Link Copied
More than 1 Million students use Goseeko! Join them to feel the power of smart learning.
Spot anything incorrect? Contact us