Question: Given the following relations: Book ( ISBN , name, author, publisher, number of pages, library ) Library is a foreign key referring to 'zip code'
Given the following relations:
Book ISBN name, author, publisher, number of pages, library
Library is a foreign key referring to 'zip code' in 'Library'. This value can be NULL.
Library zip code, straat, nr city, opening hours
Customer ID name, date of birth
Loan ISBN customerID
ISBN is a foreign key referring to 'ISBN' in 'Book' and cannot be NULL.
customerID is a foreign key referring to ID in 'Customer' and cannot be NULL.
Which statement is not correct?
Group of answer choices
A book can be loaned by different customers.
All the relations are in NF but not in NF
A library can be uniquely identified based on its zip code.
A customer can loan multiple books.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
