In Student-Course database design, there is a given relation:
SC(sno,sname,sdept,sdeptaddr,phones,sports,cno,cname,grade)
问题一: Analyse the given relation with 2nd, 3rd, BCNF and 4th NF.
问题二:Decompose the relation to satisfy BCNF and 4th NF.
In Student-Course database design, there is a given relation:
SC(sno,sname,sdept,sdeptaddr,phones,sports,cno,cname,grade)
问题一: Analyse the given relation with 2nd, 3rd, BCNF and 4th NF.
问题二:Decompose the relation to satisfy BCNF and 4th NF.