Test

In 2NF tables, non-key attributes are

• fully functionally determined by the PK.

• partially functionally determined by the PK.

• not determined by any other non-key attributes.

Which of the following normal form (NF) takes care of the multi-value dependency?

• 1NF

• 3NF

• BCNF

• 4NF

Which of the following is correct?

• All relational database implementation requires that all tables must be in 3NF.

• The smaller the database tables, the better the database.

• A 3NF table must be in 2NF.

• Transitive dependency cannot be eliminated by normalization.

What is the due date for group project report?

• Fri, Oct 20

• Fri, Dec 1

• Fri, Dec 8

• Sun, Dec 10

How long is given for each group project presentation (not including the QA)?

• 3~5min

• 5-10min

• 10-12min

• 13-15min