The university of Zimbabwe library holds a large stock of books that are available for loan to various borrowers. The library requires a database to support the processing of these loans. Examine the example records in the Forms (Figure 1) and the assumptions (Figure 2) shown below, then attempt the questions that follow:Figure 1: Three sample forms recording loans of copies of books over a period of timeFigure 2: Assumptions made 1) Design a Database and create required tables2) Apply the constraints like Primary Key , Foreign key, NOT NULL to the tables. Figure 2: List of AssumptionsThe library acquires one or many copies of books, these are physical copies of aparticularpublication.of 3A publication has a unique ISBN (an international code for all published works); atitle andii.the date it was published.Each copy has a unique copy number and has a particular shelf number to which it isiii.|located.2 13A publication is always written by either one or two authors, and an author maywrite many publications.Only authors who have written at least one publication will be stored.iv.V.vi. A borrower may have more than one copy on loan at any time.vii. A borrower may yet to take out a loanviii. Over time a copy may be out on loan many times or it may never be loaned out.A loan is made by a single borrower for one copy of a publication.ix Form 1Title: The Joy of E-R ModellingPublished_In 2013ISBN: 939757Author Id: AU505Author Name : MossAuthor Id:Author Name :CopyNo C1034Shelf Number C100DateAcquired: 12-APR-16Borrower IdBorrower NameBorrower DeptLoan DateReturn DateA12BloggsGreenacreCISBusiness02-ОСТ-1613-ОСТ-1627-ОСТ-16B3413-0СТ-16Form 2Title: Normalisation is Fun and Easy Published_In 2010ISBN: 549950Author Id AU1911Author Name :BollingerAuthor Id AU505Author Name : MossCopyNo C2399Shelf Number: C101 DateAcquired: 22-APR-2011Borrower IdBorrower NameBorrower DeptLoan DateReturn DateB34L67GreenacreBusiness04-ОСТ-1622-ОСТ-1618-ОСТ-16FranksLeisure29-ОСТ-16Form 3Title: Normalisation is Fun and Easy Published_In 2010ISBN: 549950Author Id AU1911Author Name : BollingerAuthor Id AU505Author Name : MossCopyNo C2400Shelf Number: C101 DateAcquired: 25-JUN-2011Borrower IdBorrower NameBorrower DeptLoan DateReturn DateBloggsFranksA12CIS04-ОСТ-1602-SEP-1625 OCT-16L67Leisure09-SEP-16

We create tale as below as per the Form 1 given .

Answered: Form 1 Title: The Joy of E-R Modelling…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

The university of Zimbabwe library holds a large stock of books that are available for loan to various borrowers. The library requires a database to support the processing of these loans. Examine the example records in the Forms (Figure 1) and the assumptions (Figure 2) shown below, then attempt the questions that follow: Figure 1: Three sample forms recording loans of copies of books over a period of time Figure 2: Assumptions made 1) Design a Database and create required tables 2) Apply the constraints like Primary Key , Foreign key, NOT NULL to the tables.