wbrown_3

Our group will have the following tables in our project:

1.) Animals 2.) Client 3.) Shelter 4.) Employee

These are very general tables that will have multiple subtables, but it will make it easier for someone to access the information and not have to do search after search if they want the whole thing.

(*NOTE*): Anything not specifically listed as Administrator Access is open to employees.

1.) Animals
 * Animal ID
 * Breed of pet
 * List of siblings (yes this does help)
 * Medical history (diseases, shots that need to be given, shots already given, etc.)
 * Shelter information (adress of shelter,

2.) Client

Administrator Access
 * Name
 * Contact Number
 * Client ID
 * Adress
 * Criminal record (if necessary, don't want an adoptee who abuses pets)
 * Pre-existing client ( if this client has other animals from this shelter or others, and details surrounding it)

3.) Shelter
 * Shelter ID
 * Adress of the Shelter
 * Animal housing (what animals do these shelter's offer)