Bowser is the best boy! We$$ve been tasked with keeping a database of dogs. For all dogs we

need the name of each dog, the dog$$s breed and a DogID. Dogs are either sporting dogs or

non$-$sporting dogs. For all dogs we need their Agility Performance Score $($APS$),$ Scent Test

Score $($STS$)$ and their Child Affinity Score $($CAS$).$

Dogs may $($but don$$t have to$)$ participate in dog shows that are held at different venues. A

venue is a specific place that a show is held, like the OKC Convention Center or the BOK Center

in Tulsa. Venues may host many dog shows over time but we only keep track of venues that

have hosted, will host or are hosting dog shows. When a dog participates in a dog show we

record the date of the show and what place the dog took $(1$st$,2$nd$,$ etc.$).$ Venues have an

address and also a unique name. Dogs might end up returning to the same venue so be sure

to keep the dog show data historical. In other words, dogs show up at many venues $($or none

at all$)$ and venues are host to one or more dogs. Dog shows are the coming together of dogs

and venues.

A city may have many different venues but certainly at least one. For each city we need to

capture the city name, state, country and population. Each city is identified by a combination

of the city name and the state. Obviously, a venue can exist in only one city.

A city might be a $$sister city$$ to one or more other cities. Did you know that Stillwater OK is

a sister city to Kameoka in the Kyoto Prefecture of Japan? For sister city pairs we will keep

track of the date they originally signed the agreement and the type of agreement $($cultural$,$

commercial, etc.$)$

We will also keep track of any awards won by a dog. Some dogs haven$$t won an award and

that$$s ok$.$ Each award is given to a single dog. For dogs that have won an award we will need

to retain the award name, the date it was awarded and the AwardID. Dog owners can contact

us and request that we remove their dog from our database. In this case we would want to

automatically remove any associated award records.