Database Management Systems16.0

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.