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 Hash File organization method is the one where data is stored at the data blocks whose address is generated by using hash f...
-
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...
-
Introduction So far we have seen sequential file organization and fetching of records based on the primary key or the column which is fr...
-
Third Normal Form (3NF) For a relation to be in third normal form: it should meet all the requirements of both 1NF and 2NF If there i... -
Introduction Consider our regular example of student table with ID, NAME, ADDRESS, AGE, GENDER and Semester. This table will be loaded w...
-
Indexed Sequential Access Method (ISAM) This is an advanced sequential file organization method. Here records are stored in order of pri...
-
Boyce-Codd Normal Form (3.5NF) This normal form is also referred as 3.5 normal forms. This normal form Meets all the requirement of 3N...
-
Fourth Normal Form (4NF) In the fourth normal form, It should meet all the requirement of 3NF Attribute of one or more rows in the ta...
