Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual Basic Net Database Programming

Authors: Rod Stephens

1st Edition

0789726815, 978-0789726810

More Books

Students also viewed these Databases questions

Question

Determine miller indices of plane X z 2/3 90% a/3

Answered: 1 week ago

Question

Is conflict always unhealthy? Why or why not? (Objective 4)

Answered: 1 week ago