MENU

Library Database System Basics

88 viewsG10-09. Database
0

Question Title: Library Database System Basics

libreary system

  1. What is the main purpose of the โ€œSchool Library Systemโ€ database shown above?
  2. Why was โ€œBookIDโ€ chosen as the primary key in the โ€œBooksโ€ table?
  3. Why is โ€œCopiesAvailableโ€ set as a Number data type instead of Text in the โ€œBooksโ€ table?
  4. How does the โ€œBookIDโ€ field connect the โ€œBooksโ€ and โ€œBorrowersโ€ tables?
  5. How would you set up the relationship between โ€œBooksโ€ and โ€œBorrowersโ€ in a DBMS like Microsoft Access?

Question Title: Advanced Library Database Operations

  1. Based on the sample data, which book has been borrowed more than once, and how can the database confirm this?
  2. What would happen in the DBMS if you tried to add a record to โ€œBorrowersโ€ with a BookID that doesnโ€™t exist in โ€œBooksโ€ (e.g., BookID 4)?
Spread the love
Ruwan Suraweera Changed status to publish May 23, 2025
0

Answers and Descriptions:

  1. Answer: The main purpose is to track books and their borrowers, ensuring efficient management of library resources.
    Description: This database helps librarians know which books are available, who has borrowed them, and when, reducing manual tracking errors and improving efficiency.
  2. Answer: โ€œBookIDโ€ is unique for each book, ensuring no two books have the same identifier, which prevents duplication.
    Description: A primary key like โ€œBookIDโ€ (e.g., 1, 2, 3) uniquely identifies each record. Titles or authors could repeat (e.g., multiple books by Tolkien), but โ€œBookIDโ€ cannot.
  3. Answer: โ€œCopiesAvailableโ€ is a numeric value (e.g., 5, 3) that may need calculations (e.g., subtracting when borrowed), which requires a Number data type.
    Description: If it were Text, you couldnโ€™t perform math operations like reducing stock when a book is borrowed. Number ensures functionality in an electronic system.
  4. Answer: โ€œBookIDโ€ is the primary key in โ€œBooksโ€ and a foreign key in โ€œBorrowers,โ€ linking each borrowed book to its details in the โ€œBooksโ€ table.
    Description: For example, BorrowerID 101 (Alice) has BookID 1, which matches โ€œThe Hobbitโ€ in the โ€œBooksโ€ table, showing what she borrowed.
  5. Answer: In the DBMS, drag โ€œBookIDโ€ from the โ€œBooksโ€ table to โ€œBookIDโ€ in the โ€œBorrowersโ€ table in the Relationships window to create a one-to-many link.
    Description: One book (e.g., BookID 1) can be borrowed by many students (e.g., Alice and Clara), and the DBMS enforces this link to maintain data integrity.

 

 

Question Title: Advanced Library Database Operations

Answers and Descriptions:

  1. Answer: โ€œThe Hobbitโ€ (BookID 1) has been borrowed twice (by Alice and Clara), confirmed by checking the โ€œBookIDโ€ in the โ€œBorrowersโ€ table.
    Description: The relational link shows BookID 1 appears in two records (BorrowerID 101 and 103), proving its popularity without needing manual counts.
  2. Answer: The DBMS would reject the record or show an error because the foreign key โ€œBookIDโ€ must match an existing primary key in โ€œBooksโ€ to maintain referential integrity.
    Description: If BookID 4 isnโ€™t in โ€œBooks,โ€ adding it to โ€œBorrowersโ€ would break the relationship (e.g., no book details exist), so the system prevents this.

 

Spread the love
Ruwan Suraweera Changed status to publish May 22, 2025
Write your answer.