BOOK Book id Title Publisher name BOOK AUTHORS Book id Author name PUBLISHER Name Address Phone BOOK COPIES Book id Branch lid No of copies BOOK LOANS Boo id Branch id Card no l Date out l Due date LIBRARY BRANCH Branch id Branch name Address BORROWER Card no Name l Address Phone Figure 6.14 A relational database schema for a LIBRARY database. BOOK Book id Title Publisher name BOOK AUTHORS Book id Author name PUBLISHER Name Address Phone BOOK COPIES Book id Branch lid No of copies BOOK LOANS Boo id Branch id Card no l Date out l Due date LIBRARY BRANCH Branch id Branch name Address BORROWER Card no Name l Address Phone Figure 6.14 A relational database schema for a LIBRARY database