华南理工软件学院2015期末考试-数据库系统A卷.docVIP

[6 points] In database design , how to represent relationship set as relational schemas ? [14 points] Let R=( A , B , C ,D , E , F ) be a relation with functional dependency F={A→CB , E→FA} [2 points] Compute the candidate keys for R ; [6 points] Is R in 3NF ? If it is , justify your answer . If not , produce a decomposition of R into 3NF . [6 points] Is R in BCNF ? If it is , justify your answer . If not , produce a decomposition of R into BCNF . [28 points] BOOK ( Bookid , Title , Publishername ) BOOK_AUTHORS ( Bookid , Authorname ) PUBLISHER ( Publishername , Address , Phone )