【實用教育app】Database Management Systems|最夯免費app

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

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

免費玩Database Management Systems APP玩免費

免費玩Database Management Systems App

Database Management Systems APP LOGO

Database Management Systems APP QRCode