Parton Address

This public library’s database have a lot of flaws due to the fact that it only has one large file for all transactions that occur. There is minimal information collected when a book is checked out. This will lead to problems when adding a new record, modifying an existing record, deleting a record, querying a record, and much more. If a new book is purchased and needs to be added into the database, it would be impossible because there is no field relevant for that transaction. If a patron’s address needs to be change, it is possible, but difficult. The patron’s address would need to be change for every record created. For example, if M. Jones’s address needs to be changed, her/his address would need to be changed two times (M. Jones has two records

First, “Parton Name”. The problem here is that only the first name initial and last name is provided. What if there are people with the same last name and first name initial? A full name is needed. Next, “Parton Address”. The address is too short and not detailed. There is no zip code, city, or state provided. My account at both the public and school library has my full address. In the “Book ID” field, there are only three lettered ID. What if there are too many books and all of the combination of three lettered ID is used? Instead of a three lettered ID, a barcode of book should be used. There is only a one word title in the “Book Title” field. Many book titles begin with the same words. The full title should be used instead. The problem of the “Book Author” field is similar to “Parton Name”. There may be authors who share the same last name and first name initial. For the fields “Borrow, Due, and Return Date”, the dates are out of order. The order of each record does not make sense. The order should be by “Borrow Date”. For example, the order of the rows should be: J. Smith, M. Jones, G. Hart, E. Rice, V. Hicks, and M.