Database Answers Shark !!!

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Library for Lawyers
Back to the Data Model.

The Draft Business Rules have been defined and are listed below.
The Area being Modelled is :-
A Library of Reference Documents for Lawyers.

The User Requirements have been defined as follows :-
A Database is needed for a law firm to archive their references.

References are one of 3 types:- articles, books and collective works.

There are common attributes to the 3 types, such the Call number, title, date and place of publication.

However, there also attributes that are different. eg : books have an author, physical description, publisher.
Articles have an author, source(where they appear), and page of start and end.
References have subjects or topics for searching.

B. The Things of Interest, ('THINGS'), include :-
B.1 Articles
B.2 Books
B.3 Collective Works
B.4 References
B.5 Topics

C. These THINGS are Related as follows :-
C.1 A REFERENCE can be either an ARTICLE, BOOK, or COLLECTIVE WORK.
D. Other Characteristics of these THINGS include :-
D.1 A COLLECTIVE ARTICLE has more than one Contributor.

E. Sample Data includes :-
E.1 To be determined

F. Typical Enquiries include :-
F.1 To be Determined
  Barry Williams
1st. May 2004
Principal Consultant
Database Answers
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map