UNIVERSITY OF ENGINEERING AND TECHNOLOGY ROORKEE VIDEO


For more information


 

Comments

Post a Comment

Popular posts from this blog

KEYS IN RDBMS (PRIMARY KEY, SUPER KEY, CANDIDATE KEY)

Image
KEYS IN RDBMS (Data Constraints) Many keys are available in the RDBMS, They allow finding the relation between columns and table that help identify a tuple (row) in a table. They help find a unique record from the table or database.      Keys are seven types in RDBMS Primary key Super key Alternate key Foreign key Candidate key Unique key Composite key                                                                     Fig 1.2 KEYS 1.       PRIMARY KEY A primary key is an attribute (columns) of a table or group of columns that uniquely identify each record in a table. This contains a unique value that’s no repetition for any row. It cannot be a null value. A table contains only one primary key. Example:- Roll_no Name class ...
Read more

3RD AND BC NORMAL FORM IN DBMS (3rd NF and BCNF)

Image
                                                                                    THIRD NORMAL FORM A relation is said to be in third normal form when all transitive dependencies are removed from the table or database that is no transitive dependency for the nonprime attributes. 3rd normal form is implementing after the 1 st and 2 nd NF. A general Example:- A, B, C are three columns in table           If C is belonging to B           If B is belonging to A           Then C is indirectly belonging to the A In above example, there are contains transitive dependency.   This problem can be solved using a foreign key that column id(students), id(Subject) must be placed in the third table...
Read more