0 votes
99 views
in DataBase Management System by (98.9k points)
edited
Syllabus of DataBase Management System

1 Answer

0 votes
by (98.9k points)
selected by
 
Best answer
Module Content Hrs
1 Introduction Database Concepts 3
1.1 Introduction, Characteristics of databases, File system v/s Database system, Data abstraction and data Independence, DBMS system architecture, Database Administrator
2 Entity–Relationship Data Model 6
2.1 The Entity-Relationship (ER) Model: Entity types: Weak and strong entity sets, Entity sets, Types of Attributes, Keys, Relationship constraints: Cardinality and Participation, Extended Entity-Relationship (EER) Model: Generalization, Specialization and Aggregation
3 Relational Model and relational Algebra 8
3.1 Introduction to the Relational Model, relational schema and concept of keys. Mapping the ER and EER Model to the Relational Model, Relational Algebra-operators, Relational Algebra Queries.
4 Structured Query Language (SQL) 6
4.1 Overview of SQL, Data Definition Commands, Integrity constraints: key constraints, Domain Constraints, Referential integrity , check constraints, Data Manipulation commands, Data Control commands, Set and string operations, aggregate function-group by, having, Views in SQL, joins, Nested and complex queries, Triggers
5 Relational-Database Design 6
5.1 Pitfalls in Relational-Database designs, Concept of normalization, Function Dependencies, First Normal Form, 2NF, 3NF, BCNF.
6 Transactions Management and Concurrency and Recovery 10
6.1 Transaction concept, Transaction states, ACID properties, Transaction Control Commands, Concurrent Executions, Serializability-Conflict and View, Concurrency Control: Lock-based, Timestamp-based protocols, Recovery System: Log based recovery, Deadlock handling

Related questions

0 votes
1 answer 117 views
0 votes
1 answer 165 views
0 votes
1 answer 131 views
0 votes
1 answer 114 views

Doubtly is an online community for engineering students, offering:

  • Free viva questions PDFs
  • Previous year question papers (PYQs)
  • Academic doubt solutions
  • Expert-guided solutions

Get the pro version for free by logging in!

5.7k questions

5.1k answers

108 comments

561 users

...