Database Management Systems

Features

• This ultimate free unique application is for all students of Database Management Systems across the world. It covers 150 topics of Database Management Systems in detail. These 150 topics are divided in 9 units.
• Each topic is around 600 words and is complete with diagrams, equations and other forms of graphical representations along with simple text explaining the concept in detail.
• The USP of this application is "ultra-portability". Students can access the content on-the-go from any where they like.
• Basically, each topic is like a detailed flash card and will make the lives of students simpler and easier.
• Some of topics Covered in this application are:
• 1. Overview of Database Management Systems
• 2. Database Systems versus File Systems
• 3. History of Database Systems
• 4. View of Data
• 5. Extending Database Capabilities
• 6. Types of Databases and Database Applications
• 7. Advantages of Database Systems
• 8. Functions of a DBMS
• 9. Role of the Database Administrator
• 10. Database Users
• 11. Data Models
• 12. Components of Database Management system
• 13. Transaction
• 14. Database Management System Languages
• 15. The two tier architecture
• 16. Three-layer architecture
• 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. Entity-Relationship Diagram
• 25. Hierarchical Data Model
• 26. Network Data Model
• 27. Design Issues
• 28. Extended E-R Features
• 29. Alternative E-R Notations
• 30. The Unified Modeling Language
• 31. Relational Model Terminology
• 32. Mathematical Definition of Relation
• 33. Database Relations
• 34. Structure of Relational Databases
• 35. Database Schema
• 36. Keys
• 37. Schema Diagram
• 38. The Relational Algebra
• 39. Composition of Relational Operations
• 40. The Union Operation
• 41. The Set Difference Operation
• 42. The Rename Operation
• 43. Formal Definition of the Relational Algebra
• 44. Additional Operations
• 45. Extended Relational-Algebra Operations
• 46. Outer Join
• 47. Null Values
• 48. Modification of the Database
• 49. Views
• 50. Physical Storage Media
• 51. RAID
• 52. Tertiary Storage
• 53. Storage Access
• 54. File Organization
• 55. Variable-Length Records
• 56. Organization of Records in Files
• 57. Indexing structures for files
• 58. Secondary Indexes
• 59. Clustering File Organization
• 60. Data-Dictionary Storage
• 61. Hashing
• 62. B Tree
• 63. Query-by-Example
• 64. Queries on One Relation
• 65. Queries on Several Relations
• 66. The Condition Box
• 67. The Result Relation
• 68. Ordering of the Display of Tuples
• 69. Aggregate Operations
• 70. Normalization
• 71. Functional Dependency
• 72. The Process of Normalization
• 73. First Normal Form (1NF)
• 74. Boyce.Codd Normal Form (BCNF)
• 75. Fourth Normal Form (4NF)
• 76. Fifth Normal Form (5NF)
• 77. Algorithm for Functional Dependencies
• 78. Objectives of SQL
• 79. History of SQL
• 80. Importance of SQL
• 81. SQL Statement
• 82. Use of DISTINCT
• 83. Search Condition
• 84. Pattern Matching
• 85. NULL Search Condition
• 86. SELECT Statement
• 87. SELECT Statement - Grouping
• 88. Subqueries
• 89. Join
• 90. Integrity Enhancement Feature
• 91. Data Definition
• 92. View
• 93. Transactions
• 94. Data-Definition Language
• 95. Schema Definition in SQL
• 96. Dynamic SQL
• 97. Lock-Based Protocols
• 98. Granting of Locks
• 99. Two-Phase Locking Protocol
• 100. Implementation of Locking
• 101. Graph-Based Protocols
• 102. Timestamp-Based Protocols
• 103. Validation-Based Protocols
• 104. Deadlock Handling
• 105. Timeout-Based Schemes for Deadlock Prevention
• 106. Deadlock Detection
• 107. Recovery from Deadlock
• 108. Need for Concurrency Control
• 109. Schedule
• 110. Timestamping
• 111. Optimistic Techniques
• 112. Granularity of Data Items
• 113. Database Recovery
• 114. Checkpoint
• 115. Recovery Techniques
• 116. Failure Classification
• 117. Storage Types
• 118. Data Access
• 119. Log-Based Recovery
• 120. Deferred Database Modification

*If this is not the "Database Management Systems" product you were looking for, you can check the other results by clicking this link.  Details were last updated on Oct 21, 2024 15:58 +08.