DOWNLOAD  $1.00

Database Management Systems -I

    • SEARCH TYPE
    Database Management Systems -I icon

    Database Management Systems -I

    by: faadooengineers.com 0 0

    DOWNLOAD  $1.00


    Screenshots

    Description

    This ultimate 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

    All topics not listed due to character limitations set by Play Store.

    Tags: schema sql 97 96 111