___________________________________________________________________
Unit 02 L.A. B & C:
Creating Systems to Manage
Information
___________________________________________________________________
Managing Information at the Wildlife
Park
Ghassan Sinno
, Designs for a relational database that meets client
requirements.
Animals
P/F Field name Description Data type Field size Example
P Animal_ID Animal Short Text 3 A15
Identification
Animal_name Name of animal Short Text 20 Laura
Gender Gender of anime Short Text 1 F
Year_Of_Arrival Year of arrival Date/Time 10 2017
F Species_Number Species Number Short Text 3 s15
F Diet_Number Diet Number Short Text 4 d22
F Keeper_ID Keeper Short Text 2 K3
Identification
F Enclosure_Number Enclosure Number Short Text 4 e22
Species
,P/F Field name Description Data type Field size Example
P Species_Number Species Number Short Text 3 s05
Species_ID Species Short Text 2 S1
Identification
Species_Type Species Type Short Text 15 Crocodile
Species_Group Species Group Short Text 7 Reptile
Lifestyle Lifestyle Short Text 10 Solitary
Conservation_Status Conservation Short Text 25 Threatened
Status
Diet
P/F Field name Description Data type Field size Example
P Diet_Number Diet Number Short Text 4 d06
Diet_ID Diet ID Short Text 2 D1
Diet_Type Type of diet Short Text 15 Herbivore
Feeds_Daily Number of feeds Number 2 6
per day
, Keepers
P/F Field name Description Data type Field size Example
P Keeper_ID ID of Keeper Short Text 3 K1
Keeper_Name Keeper Name Short Text 10 Kayde
Keeper_DOB Date of birth of Date/Time 10 09/08/1998
keeper
Keeper_Rank Rank of keeper Short Text 8 Senior
Enclosures
P/F Field name Description Data type Field size Example
P Enclosure_Number Number of Short Text 3 e01
enclosure
Enclosure_ID ID of enclosure Short Text 3 E4
Enclosure_Type Type of enclosure Short Text 6 Walled
Location Area of enclosure Short Text 5 East
according to the
park
Unit 02 L.A. B & C:
Creating Systems to Manage
Information
___________________________________________________________________
Managing Information at the Wildlife
Park
Ghassan Sinno
, Designs for a relational database that meets client
requirements.
Animals
P/F Field name Description Data type Field size Example
P Animal_ID Animal Short Text 3 A15
Identification
Animal_name Name of animal Short Text 20 Laura
Gender Gender of anime Short Text 1 F
Year_Of_Arrival Year of arrival Date/Time 10 2017
F Species_Number Species Number Short Text 3 s15
F Diet_Number Diet Number Short Text 4 d22
F Keeper_ID Keeper Short Text 2 K3
Identification
F Enclosure_Number Enclosure Number Short Text 4 e22
Species
,P/F Field name Description Data type Field size Example
P Species_Number Species Number Short Text 3 s05
Species_ID Species Short Text 2 S1
Identification
Species_Type Species Type Short Text 15 Crocodile
Species_Group Species Group Short Text 7 Reptile
Lifestyle Lifestyle Short Text 10 Solitary
Conservation_Status Conservation Short Text 25 Threatened
Status
Diet
P/F Field name Description Data type Field size Example
P Diet_Number Diet Number Short Text 4 d06
Diet_ID Diet ID Short Text 2 D1
Diet_Type Type of diet Short Text 15 Herbivore
Feeds_Daily Number of feeds Number 2 6
per day
, Keepers
P/F Field name Description Data type Field size Example
P Keeper_ID ID of Keeper Short Text 3 K1
Keeper_Name Keeper Name Short Text 10 Kayde
Keeper_DOB Date of birth of Date/Time 10 09/08/1998
keeper
Keeper_Rank Rank of keeper Short Text 8 Senior
Enclosures
P/F Field name Description Data type Field size Example
P Enclosure_Number Number of Short Text 3 e01
enclosure
Enclosure_ID ID of enclosure Short Text 3 E4
Enclosure_Type Type of enclosure Short Text 6 Walled
Location Area of enclosure Short Text 5 East
according to the
park
