Answer Happy

a large library that borrows books to all members in the
society. This library needs to maintain a record of its members and
borrowed books in a database. The details about members need to be
stored including member identification number, member name,
telephone number and address. The details of available books are
stored in the database. The database should contain a unique
identification number for each book, book title, book rating and
number of copies. As books are rented, transactions are recorded.
Every transaction records an invoice number is automatically
generated, schedule, date of return, actual date of return and
final amount if required.
1. Use Ms Access to create the entities and attributes
identified in the case study. Hint: Make sure all tables are
normalized
2. Create a relationship between all the entities created.
3. Create data entry forms for each table, Remember to enforce a
relationship.
4. Insert atleast 5 records per table
5. Create a multi-table form for any 2 related tables.
6. Create a report for the above created “Multi-table” form
7. Add a footer on the above report created in (f)
8. Create a query to extract the following
i. Member name,
Telephone number and Address of the members
ii. All details of the books.