Tutorial by Examples: 2nf

To normalize the database in the second form, there must not be any partial dependency of any column on primary key. Let's consider the following example: idnamedobsubject1Mark1-1-1981Physics2Jack2-2-1982Math2Jack2-2-1982Biology3John3-3-1983Math This table is considered to have a composite primar...

Page 1 of 1