Popular Posts
-
Introduction As the database grows, the ER diagram representation becomes more complex and crowded. It is creates a difficult situation ...
-
Introduction We have seen what ER diagram is and what its basic concepts are. Now let us see how to draw the ER diagram using these conc...
-
Introduction So far we have seen sequential file organization and fetching of records based on the primary key or the column which is fr...
-
Introduction Hash File organization method is the one where data is stored at the data blocks whose address is generated by using hash f...
-
Introduction As we have already seen in previous articles that B+ tree is a (key, value) storage method in a tree like structure. B+ tre...
-
Database is full of datas and records. What we see in rows and columns is quite different when it reaches the memory. What we see is the a...
-
Indexed Sequential Access Method (ISAM) This is an advanced sequential file organization method. Here records are stored in order of pri...
-
Fifth Normal Form (5NF) A database is said to be in 5NF, if and only if, It's in 4NF If we can decompose table further to elimina... -
Concurrency Control As we have seen above, when there are multiple transactions executing at the same time on same data, it may affect t... -
These data models are based on application and user levels of data. They are modeled considering the logical structure of the objects in t...
