For each request, write the relational algebra and SQLstatement that will fulfil the request. Note that there are Microsoft Access and MySql sampledatabases for each example if you want to use it to test the syntax of your SQL queries (thoughthe sample may not produce a result in all cases).AKC Registration1)List all dogs born to a white sire.

Individual Homework: Complex QueriesThe goal of the homework is to apply your query understanding to more complex problems thatapproach those commonly found in the workplace. You will be provided with the naturallanguage request related to one of the data models from the set of examples provided to youthrough the class Google Drive. A copy of each model can be found after the homeworkquestions for your convenience. For each request, write the relational algebra and SQLstatement that will fulfil the request. Note that there are Microsoft Access and MySql sampledatabases for each example if you want to use it to test the syntax of your SQL queries (thoughthe sample may not produce a result in all cases).AKC Registration1)List all dogs born to a white sire.2)List Golden Retriever owners with their dogs who live in Washington State.3)Which dame gave birth to the most total puppies?4)Which owners have ownership of more than one registered dog?Beer Wine Application Permit5)What brands of wine are associated with any permit request?6)How much money was raised from the permitted events for recipients that occurred inJuly 2020?7)Which applicants held an event hosted at their place of business (assuming that theiraddress is their place of business)?8)Show all multiple day permitted events held during 2020 along with their location andstart / end dates.

AKC Logical Data Model