I am designing a database to hold information about a book rental business.
Member rating:
(7 votes)
| Words:
| Submitted: Sat Aug 30 2003
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
Unit 2 Assignment 1 I am designing a database to hold information about a book rental business. The database will feature tables including information about the members of the book club, the books available to rent and the member - book relations. The following outlines what factors are included in each table and for what reasons. Member: * Membership number: To make sure that member has correct membership card. * Rentee: The name of the member. This is so that I know the name of my member. * Date of birth: To make it easier to recognise customers and to help work out suitability of books for this person. * Address: In case member needs to be contacted. If for example they have an overdue book. This is my final table that I have created for information about members of my library. Book Info: * Book Reference Number: The reference number of that specific book. * Title: Title of book....

