|
- ISBN #
- A ten digit number unique to a specific book title but
not to any one specific book. The number has the form
of D-DD-DDDDDD-D, where D is a decimal digit from 0 - 9.
- Call number
- A unique number that specifies a specific book in the
database. The call number is of the form DDDDDDDDD,
where D represents a digit from 0 - 9. Call numbers
can vary in length and range from 0 - 999999999, and
are generated automatically when the book is added to
the database.
- Title
- A string with a maximum length of 150 characters.
Each title does not have to be unique.
- Author
- A string with a maximum length of 120 characters.
The typical format of each author's name is as
follows:
lastname, firstname givenname(s)
and if there are more than one author, the authors'
will simply be entered in sequence. The authors'
names do not need to be unique.
- Publisher
- A string with a maximum of 150 characters. Each
publisher does not have to be unique.
- Subject
- A string with a maximum of 100 characters. The
subject field contains subject key word(s) that are
used to desribe the subject category of the book. If
more than one key word is entered, they should be, but is not
necessary to be, unique between them. Subject
keyword(s) between books do not need to be unique.
- Book Category
- A pull-down menu containing the choices:
{overnight, two week, reserved}
Only one of the three choices can be selected. This
list will be expandable.
- Media Type
- A pull-down menu containing the choices:
{Book, CD, CD-ROM, Film, Laserdisk, Journal}
Only one of the three choices can be selected. This
list will be expandable.
- Cost
- A dollar figure representing the value of the book.
Assumed to be either in American or Canadian funds.
- Version (optional)
- A decimal number of the form DDD, where the D
represents a digit from 0 - 9. Thus, the version is a
number from 0 - 999. This number is not mandatory.
- Edition (optional)
- A decimal number of the form DDD, where the D
represents a digit from 0 - 9. Thus, the edition is a
number from 0 - 999. This number is not mandatory.
- Number of Copies
- A decimal number of the form DDD, where the D
represents a digit from 0 - 9. Thus, there could be
from 0 - 999 copies of one particular book.
This number generated automatically when the book is
added to the database.
- Location
- A pull-down menu containing all of the branches that
belong to the Springfield Library. This menu
currently contains only the main branch, but is
expandable as the Springfield Library expands.
- Floor
- A decimal number of the form DD, where D represents a
digit from 0 - 9. Thus, a particular book can only be
on a floor from 0 - 99.
- Circulation Status
- A pull-down menu containing the choices:
{available, on loan, overdue, on hold, out of circulation}
Only one of these choices can be selected.
|