var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
need to normalize the table upto 3NF n BCNF
The foll. is table with values
regno owner model manf cylinder
1 a l f 4
2 b fl f 6
3 a co t 4
4 b l f 4
5 c co t 4
Detail explanation with table
plz!! help me!!
Answer the following questions one after another and normalize for each:
Eliminate repeating columns.
Eliminate redundant rows.
Eliminate independent columns.
Last edited by certus; 12-01-05 at 00:11.
this table is in 2NF already!! I think
1nf: regno is pk
2nf: as there is only 1 pk so all the nonkey attrib. r dependent on it.
plz!! convert it to 3NF n BCNF