Data Store Descriptions

Data Stores (Databases)

There are two main data stores in the system BOOK and BORROWER. There is as well an associate data store FINES which has some of the same attributes as the first two plus the amount outstanding in the amount area. The FINES data store if for ease of use for the system and storage of the amount owed.

The primary types in this system are as follows:

• Integer is denoted by the mathematical definition. (A whole Number)
• String is a string of characters including alphanumeric and punctuation.
• Date in the form DD/MM/YY where DD is day MM is month and YY is year.
• Currency is a real number in the form of DOLLARS.CENTS where DOLLARS is of the form of an integer and CENTS is an integer no larger than 99.
• Memo is a character string that is up to 250 characters long.

Book Data Store:

BOOK=@call#+title+author+subject+location+type+cost+status+fee+borrowed+ publisher+publishing_date+discription

The fields for this data store are saved in this form in the database:

• title="string"
• author="string"
• subject="string"
• call#="integer"
• publisher="string"
• publishing_date="date"
• location="string"
• type="char"
• cost="currency"
• fee="currency"
• status="string"
• discription="memo"
• borrowed="integer"

Borrower Data Store:

BORROWER=@Id#+first+middle+last+address+city+prov/state+code+phone+address+city2+prov/state2+code2

The fields for this data store are saved in this form in the database:

first="string"

middle="string"

last="string"

address="string"

city="string"

city2="string"

prov/state="string"

prov/state2="string"

code="string"

code2="string"

phone="string"

Id#="integer"

Fine Data Store:

FINE=@Id#+@call#+due+amount+returned+out_on

Id#="integer"

call#="integer"

out_on="date"

due="date"

returned="date"

amount="currency"

The data stores are related in a form that requires a table to allow for further explanation on their form, therefore we have:

@ is a way to show a primary key for a Data Store

+ is a way to denote aggregation of terms to show that the field includes these or this.

= is to denote that the data is made of this/these.

# means the word number.

" " denotes a simple data type (these have been previously defined).

Back to the Overall Design Index