Principle and design of database P113 No. 2013211466 class: 0401302

14.

Select question number:

4.4.4.3.2

15.

(1) Readers and books: one-to-many; but what about books and readers?

Bibliography and reader: one to one;

Bibliography and books: one on one.

(2) Borrowing also records (reader ID, book ID, loan time, should also time, return time);

Reservation registration (reader ID, appointment time, appointment period, book ID).

(3)

Primary key FOREIGN key

Reader Reader ID

Bibliography ISBN

Book book ID or ISBN none

Borrowing also records book ID reader ID

Register Reader id+ book ID book ID, reader ID

Principles and design of database P113 number 2013211466 class: 0401302