BCNF 和 3NF的问题

1.(15 marks) The Order-Has-Invoice entity and relationship sets as highlighted in the
ER diagram has been mapped into a relation as follows:
Order-Has-Invoice(orderNo, orderdate, invoiceNo, amount, issuedate, duedate)
Complete the following tasks:
• give the minimal basis for all FDs on the relation,
• specify all its candidate keys,
• specify if it is BCNF or 3NF, and explain the reason.
2. (5 marks) For the relation mapped from the weak entity set Installment, specify if it is
in BCNF or 3NF and explain the reason.
3. (5 marks) For the relation mapped from the ternary relationship set Place, specify if it
is in BCNF or 3NF and explain the reason.
4. (10 marks) For all relations mapped from the ER diagram, specify any relations not in
BCNF or 3NF, and explain the reason. Decompose each of these relations into
BCNF/3NF and denote the primary key and any foreign keys for each resultant
relation.

这4道题目应该怎么做
1.Order-Has-Invoice 是BCNF 还是3NF 为什么？
2.installment 是BCNF 还是3NF 为什么？
3.place 是BCNF 还是3NF 为什么？
4.所有的关系，哪些不是BCNF或3NF,为什么？解析每个关系into BCNF/3NF 和指示primary keys and foreign keys


[ 本帖最后由 jackyshen 于 2010-5-18 18:23 编辑 ]