Hirarchical Data Model
Relational Data Model
It stores information by table
Object Oriented
ER Model , Relational Model - important
ER Model - Entity Relation - Conceptual - Blueprint - Different Attribute Types - Types of Relation - Bahat important he -
Basics of keys - Primary key - Candidate key - Super key - Alternative key -_ Foreign key **_ 2 tables are connected with foreign key
Normalization - Not complex - Concept - Find Closure Method - Functional Dependency
1st Normal Form - 1NF
2NF
3NF
4NF
Find the 1NF from the given table. - This question is important
Minimization of function
Transaction Control & Concurrency - Kind of theoretical topic - ACID - Read Write Problem - W -R , W -W
Conflict Serializability - Very Very Important
Conflict Serializable or not
Whether Schedule is recoverable or not
Concurrency -2 Phase Locking , Time Stamp
SQL and Realtime algebra
DDL
DML
DCL
Constraint
Aggregate Function
Joins - Bahat Important
Different Types of Joins
Natural Join - Important
Outer Join
Last but not least
Nested Query - 7 to 8 marks
In , Not - In , Any , All
Indexing
-Single Level Indexing
-Primary
-Cluster
-Secondary Next
B Tree - Design - Delete Node - Insert Node - Level - Height
B+ Tree
Top comments (0)