You are building a Library database. The Book table has a repeating group for authors because some books have multiple authors. What should you do to ensure this table conforms to 1NF?

Question

You are building a  Library  database. The  Book  table has a repeating group for authors because some books have multiple authors. What should you do to ensure this table conforms to 1NF?

Answer

Merge author fields into a memo field

Answer

Use an AutoNumber to ensure that author names are unique

Answer

Allow multiple names in one field

Answer

Create a separate  Author  table and a junction table linking the  Author  to the  Book.

Answer

Delete duplicate author names

Crowdly

You are building a Library database. The Book table has a repeating group fo...

Want instant access to all verified answers on connect.belgiumcampus.ac.za?