Design and Create a database for a dog show using MYSQL or SQL Server.

Each dog has a breed, a category, and a handler and some descriptive data.

Handler's have names, gender, addresses, etc. A handler may handle more than one dog.

Breeds fall into one of the following categories

Group 1, Sporting Dogs.

Group 2, Hounds.

Group 3, Working Dogs.

Group 4, Terriers.

Group 5, Toys.

Group 6, Non-Sporting.

Group 7, Herding.

Each contest has a win, place, and show (1st, 2nd, 3rd)

Each dog participates in a contest that is restricted to it's own category

Each contest has three judges. The judges each judge 2 contests but no more. A judge cannot be handler.

show your code for creating the database.