MCA C1004
Database Management System
![](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" width="1" height="1"/%3E)
Notes are on their way.
For now, use the syllabus outline to see what this subject covers.
Syllabus topics
File systems versus Database systems, Advantages of DBMS, DBMS classification/types, DBMS structure, three schema DBMS architecture, Data Models, Data Independence, Data abstraction, Database Users, Database Schemas and Database Instances, Views and its advantages, Data dictionary, DBA and its functions, RDBMS, Difference between DBMS and RDBMS. [Q-2]
Notes will be added here.
Syllabus: supplied PDF, page 12.
Syllabus topics
Entities and Entity Sets, Relationships and R elationship Sets, Mapping Cardinality, ER Diagram, Reducing ER Diagram to tables, Specialization, Generalization and Aggregation. Codd’s rule, RDBMS Concepts, Types of Keys, Constraints Types, Relational database Scheme, Procedural & Non Procedural Languages, Relational Algebra, Relational Calculus. [Q-2]
Notes will be added here.
Syllabus: supplied PDF, page 12.
Syllabus topics
Basic Concepts, Basic SQL, Advance SQL, Database languages, Set operations, Aggregate Functions, Null Values, views, Sub-queries, Integrity Constraints(Entity integrity, Referential integrity and Domain constraint), SQL Constraints Types , Indexing , Cursors, Stored procedures and triggers. [Q-1]
Notes will be added here.
Syllabus: supplied PDF, page 12.
Syllabus topics
Pitfalls in relational database design, Normalization using functional dependency, Multivalu ed and join dependencies, Atomic values, Full and Partial Functional Dependency, 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. [Q-2]
Notes will be added here.
Syllabus: supplied PDF, page 12.
Syllabus topics
DBMS Transaction, ACID Properties, States of Transaction, Serializability, DBMS Concurrency control, DBMS deadlock, Deadlock avoidance, Deadlock detection, Deadlock Prevention, , Schedules and Recovery, Locking and Timestamp Ordering for concurrency control. [Q-1]
Notes will be added here.
Syllabus: supplied PDF, page 12.
Check your university’s syllabus for the topics covered in your exams.