Database Answers Header
FACTS for a Database for a Library

Bienecke Rare Manuscripts Libray, Yale University

PURPOSE OF THESE FACTS :-
These FACTS define the functional requirements which the Database must meet.
They form the basis for agreement between the User and the Database Designer and are
written in a form of structured English which is clear and unambiguous.
The Draft FACTS
have been defined and are detailed here ...
A. The Area being Modelled is :-
A Teachers Resource Library.
Dennis says :-
Hi Barry 
Thanks for the info. 
As I have only done a partial course in Access and not likely to complete it I am 
not fully conversant with all aspects yet. I am planning to educate myself in this 
very interesting topic so all the help I can get would be appreciated. 
I have been going over my old lecture notes to get a grasp on your postings. 
Looking at your FACTS sheet I stay with the entities I need. 
What I need to see in the form that will be used by the borrowers is the Teachers(Borrower) ID 
I have got this as a text file which I import to the Borrower Table. 
This includes Borrower Name in one column and ID number in another. 
I've attached the text files for the staff and the books if you want to get a better picture of what I need. 
I need to be able to have the book titles brought up with the find element. 
I am having trouble importing the books text file into the table in the model you sent me, keep getting error messages.Possible queries could be how many books taken out by individuals and which are overdue. I don't know what your position is with your company as to supplying info before charging so I must tell you that I am on a disability pension and do not have a credit card. I work only part-time at our school feeding the farm animals. I have a book that I used in my course called 'Nene Guide to Access 2000'. This is an Australian publication and there are download files at 
www.nenepress.com.au  
It is quite a useful publication but I can't imagine that it would be available where you are. 
Trust I am not asking too much of you. 
Regards 
Dennis 


The database is for a teachers resource library. Fields needed are :-
  • Book Title
  • Borrower ID (number)
  • Borrower Name
  • Date Out (default)
  • Date returned. I need a form that allows me to have the Title put in by selection from the book table, maybe a list box? And the Borrower id + Borrower name the same. I don't know if you can understand my explanations so I'll leave it in your obviously capable hands.
    The Facts from here need to be reviewed ... B. The Things of Interest, ('THINGS'), include :- B.1 Authors B.2 Books B.3 Book Categories B.4 Books Out on Loan B.5 Users B.6 User Borrowings C. These THINGS_OF_INTEREST are Related as follows :- C.1 An AUTHOR can write many BOOKS. c.2 A BOOK can have many AUTHORS. C.3 A BOOK can be in many CATEGORIES. C.4 A USER can be associated with zero or many BOOKS_OUT_ON_LOAN. C.5 A BOOK_OUT_ON_LOAN must always be associated with one and only one USER. E. Sample Data includes :- To be determined F. Typical Enquiries include :- F.1 How many BOOKS are overdue ? F.2 Do we have any BOOKS by Charles Dickens ? Barry Williams Principal Consultant Database Answers 14th. June 2003

  • [ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Search & Site Map ]

    © IceBreaker WebDesigns 2001