Given the following relational model (primary keys are underlined, foreign keys are in italics)

BOOK(ISBN, title, pages, price, publishername)

AUTHOR(authorname, date_of_birth)

WRITES(authorname, ISBN)

PUBLISHER(publishername, streetnumber, streetname, zipcode)

CITY(zipcode, city)

The assumptions are:

• Each book has a unique ISBN number
• Each author has a unique name
• Each publisher has a unique name
• A book can have multiple authors
• An auther can write more than one book
• A publisher can publish more than one book
• A book can have multiple publishers
• A publisher has only one address

Which statement is CORRECT?

		The relational model is in first normal form but not in second normal form.
		The relational model is in third normal form.
		The relational model is not in first normal form.
		The relational model is in second normal form but not in third normal form.