A public library records data about the details of each transaction in one large

Question

A public library records data about the details of each transaction in one large file, consisting of Patron Name, Patron Address, Book ID, Book Title, Book Author, Borrow Date, Due Date, and Return Date. No separate record is kept of patrons, books, and book borrowings other than in this file. As shown below, when a book is to be checked out, the various details of that borrowing are recorded in this file as a new row:

With this file structure, what problems is the library liable to run into in terms of conducting day-to-day transactions or retrieving information? Specifically:

a)adding a new record (such as of a new book just purchased)

b)modifying an existing record (such as changing a patron’s address)

c)deleting a record (such as of a patron who has discontinued membership)

d)querying a record (such as whether the collection comprises a certain book)

Take the above structure and break it down into separate, smaller files so as to avoid the problems discussed above.

Patron Patron Book Book Book Borrow ue Return Name Address ID Title Author Date Date Date J. Smith 12 Elk AAA Peace A. Bart 03/04/03 03/18/03 03/15/03 M. Jones 25 Sun BBB War M. Hine 03/04/03 03/18/03 03/19/03 G. Hart 73 Sera CCC System N. Vang 03/05/03 03/19/03 03/23/03 V. Hicks 22 Mann AAA Peace A. Bart 03/19/03 04/02/03 04/02/03 E. Rice 69 Witt DDD Spring F. Lyon 03/06/03 03/20/03 03/08/03 M. Jones 25 Sun CCC System N. Vang 03/26/03 04/09/03 04/08/03

Explanation / Answer

As the Coding language of solving the Problem is not clearlyvmentioned, Using SQL the Following Problem has been solved :

INSERT INTO PUBLIC_LIBRARY (PATRON NAME, PATRON ADDRESS, BOOK ID, BOOK TITLE, BOOK AUTHOR, BORROW DATE, DUE DATE, RETURN DATE)

VALUES (‘XYZ’,’ABC’,’ZZZ’,’SCIXYZ’,’PQR’,’01/02/2017’,’09/02/2017’,’03/03/2017’);

B :

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.