Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2007
    Posts
    3

    Unanswered: Hi I need help with a database scenario

    Here is the scenario:

    Current System
    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.

    Proposed System
    Functionality
    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
    Last edited by yeah; 03-08-07 at 16:32.

  2. #2
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    What class are you taking that gave this assignment?

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    We are happy to help you, but we're not going to do this for you.
    Ask any specific questions (making sure you include all the relative details) and we can see what's what!
    George
    Home | Blog

  4. #4
    Join Date
    Mar 2007
    Posts
    3
    HI,

    I have done my table but i need some help with the relationship and getting it to work using forms

    Thanks

  5. #5
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    What relationship are you refering to?

    To get a field to work with a form, you make the form the RecordSource for the form. See the properties dialog for the form, Data tab.

  6. #6
    Join Date
    Mar 2007
    Posts
    3
    Hi there,

    Thanks for the help so far, basically i need help with the whole of the scenario, here is my database so far



    Any help would be much appriciated
    Attached Files Attached Files

  7. #7
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by georgev
    We are happy to help you, but we're not going to do this for you.
    Ask any specific questions (making sure you include all the relative details) and we can see what's what!
    -cough cough-
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •