using the information below, write an SQL code for a pet database

It is difficult to track all the volunteers and call them, since the forms filled by the volunteers are lost often.

It is difficult to track an animal in the foster care, when the foster care does not submit the monthly reports.

It is difficult to show all the animals available to adapt, to an adapter. Since the data is gathered through paper, it is tuff to track all these things.

3. Make a list of all the nouns in the description of the shelter.

Animal, Foster Care givers, Adapters, Adaptions, and Reports

4.Take the list from 3, and determine what you think would be the major entities.

Animal, Foster care givers

5.For each entity you listed in 4. list the attributes for each of the entities.

Animal: species, breed, name, condition

Foster Care givers: Animal name, breed, Contact number

1.) animal_data - This table will contain details of all the animals. We are gonna assign a id for each animal to identify them

uniquely. then we will store their details like - name, species, breed, condition, age, adopted ( whether adopted by someone

or not). Our primary key will be animal_id.

2.) volunteer_data - This table will contain details of all the volunteers. volunteer_id will be given to each and every volunteer and this will help us identify volunteers uniquely. Other details include - name, phone, address, SSN, interest,

allocated ( whether they have any animal adopted) , likes_dislikes.