Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Book (ISBN, name, author, publisher, number of pages, library ) Library is a foreign key referring to 'zip code' in 'Library'. This value can be
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?
A library can be uniquely identified based on its zip code. | ||
A customer can loan multiple books. | ||
All the relations are in 2NF but not in 3NF. | ||
A book can be loaned by different customers. |
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