Question
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 ,
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. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Relational Database Design A Practical Approach
Authors: Marilyn Campbell
1st Edition
1587193175, 978-1587193170
