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.
No comments:
Post a Comment