Database Management Systems

Database Management Systems (DBMS) is a free Computer Science handbook covering important course topics, notes, diagrams, equations, formulas and study materials. Download this digital book and reference guide for Diploma, BE, BTech, BCA, BSc, MCA and other degree courses.

Explore 150 topics in 5 chapters, with simple explanations of database design, ER diagrams, relational models, SQL, normalization, indexing, transactions and concurrency control. Useful for exams, interviews, viva, assignments and projects.

RELATED ENGINEERING BRANCHES

Computer Science Engineering (CSE), Information Technology (IT), Computer Engineering, Software Engineering, Data Science, Artificial Intelligence and related computing courses.

104 UNIQUE LISTED TOPICS

DBMS FUNDAMENTALS & ARCHITECTURE

1. Overview of Database Management Systems

2. Database Systems vs File Systems

3. History of Database Systems

4. View of Data

5. Extending Database Capabilities

6. Types of Databases and Applications

7. Advantages of Database Systems

8. Functions of a DBMS

9. Role of Database Administrator

10. Database Users

11. Data Models

12. Components of DBMS

13. Transactions

14. DBMS Languages

15. Two-Tier Architecture

16. Three-Layer Architecture

ER MODEL & RELATIONAL DATABASES

17. Entity-Relationship Model

18. Database Design and ER Diagrams

19. Entity Types, Attributes and Keys

20. Relationships and Relationship Sets

21. Types of Entity

22. Constraints

23. Keys

24. Hierarchical Data Model

25. Network Data Model

26. Design Issues

27. Extended E-R Features

28. Alternative E-R Notations

29. Unified Modeling Language

30. Relational Model Terminology

31. Mathematical Definition of Relation

32. Database Relations

33. Structure of Relational Databases

34. Database Schema

35. Schema Diagram

RELATIONAL ALGEBRA & STORAGE

36. Relational Algebra

37. Composition of Relational Operations

38. Union Operation

39. Set Difference Operation

40. Rename Operation

41. Formal Definition of Relational Algebra

42. Additional Operations

43. Extended Relational-Algebra Operations

44. Outer Join

45. Null Values

46. Modification of Database

47. Views

48. Physical Storage Media

49. RAID

50. Tertiary Storage

51. Storage Access

52. File Organization

53. Variable-Length Records

54. Organization of Records in Files

55. Indexing Structures for Files

56. Secondary Indexes

57. Clustering File Organization

58. Data-Dictionary Storage

59. Hashing

60. B-Tree

QUERIES & NORMALIZATION

61. Query-by-Example

62. Queries on One Relation

63. Queries on Several Relations

64. Condition Box

65. Result Relation

66. Ordering Display of Tuples

67. Aggregate Operations

68. Normalization

69. Functional Dependency

70. Process of Normalization

71. First Normal Form (1NF)

72. Boyce-Codd Normal Form (BCNF)

73. Fourth Normal Form (4NF)

74. Fifth Normal Form (5NF)

75. Algorithm for Functional Dependencies

SQL & DATABASE DEFINITION

76. Objectives of SQL

77. History of SQL

78. Importance of SQL

79. SQL Statement

80. Use of DISTINCT

81. Search Condition

82. Pattern Matching

83. NULL Search Condition

84. SELECT Statement

85. SELECT Statement: Grouping

86. Subqueries

87. Join

88. Integrity Enhancement Feature

89. Data Definition

90. Data-Definition Language (DDL)

91. Schema Definition in SQL

92. Dynamic SQL

CONCURRENCY CONTROL & DEADLOCKS

93. Lock-Based Protocols

94. Granting of Locks

95. Two-Phase Locking Protocol

96. Implementation of Locking

97. Graph-Based Protocols

98. Timestamp-Based Protocols

99. Validation-Based Protocols

100. Deadlock Handling

101. Timeout-Based Deadlock Prevention

102. Deadlock Detection

103. Recovery from Deadlock

104. Need for Concurrency Control

Study with this free DBMS ebook for quick revision and practical database concepts.