Unanswered: Hi I need help with a database scenario
Here is the scenario:
The case study is based on the video issue recording system of the Video Library (VL). VL specialises in obscure videos that are not readily available from other sources. VL lends only to members of the Video Society, part of the exclusive and very expensive Gentleman's Club. Details of finance are outside the scope of the investigation. Any member of the club is automatically a member of the library. Club membership is for one year. A few new members are admitted on 1st January each year; new members are not admitted during the year.
The library is set up along conventional lines and members are not restricted in the number of videos they may borrow at any one time. Videos are requested for return only if required by another member. Most active users of the library regularly change their videos. Two or three copies of popular titles are available. Two codes are used to describe a video. While a video publication can be identified by a standard 7-character alphanumeric video code assigned by the producer of the video, a particular copy of it has a 6-digit serial number, the copy number, given by the library itself.
In order to borrow a video a member selects it, takes it to the issue desk and gives the video and his club membership card to the librarian. The librarian takes the video ID card from the video and writes the membership number on the card at the end of the list of membership numbers of previous borrowers. The librarian places the card into the loans file in video code order and the member leaves with his video.
When a member returns a video, he presents the video to the librarian. The librarian finds the video card in the loans file, lightly crosses out the member's number and places the card in the video sleeve before returning the video to the library shelves. The crossed-out numbers provide a simple history of the loans of each copy.
To reserve a video which is on loan, a member asks the librarian and leaves his membership number. The librarian finds the record of the relevant video in the loans file and adds the member's number to the reservation column on the video card. The librarian also makes a note of the member who has the video on loan and completes a return request card addressed to that member. The address is taken from the library copy of the club membership book. When the reserved video is returned, the librarian puts the video under the counter and completes a reservation ready card addressed to the member who first requested the reservation, again taking the address from the membership book. The date by which the reserved item must be collected is entered on the card. The member requiring the video can then pick it up from the library and have it issued in the usual manner. Videos which are not collected by the collection date are returned to the shelves or offered to the next reserving member, if any.
The selection, ordering and payment for the videos is outside the scope of the investigation.
On receipt of a new video the librarian has to make out a video card for insertion in the video sleeve. The librarians are also responsible for amending the library's membership book with changes of address, and at the end of the year for collecting the new membership book from the Club Secretary.
The functionality of the new system is to be the same as in the current system. That is, operations which can be performed in the current system should be capable of being performed in the proposed system. For example, the history of loans of a copy of a video is required. Paper-based documents will be retained except that video cards are abolished.
I have started the database but there seems to be alot of errors, and because i am new to access i really need some help