Draw data models for the following entities. In each case, make certain that you show the attributes and identifiers. Also, create a relational database (write a code) and insert three rows for each of the tables that you create. The data can be anything you create that fits within any constraints specified in the problem.

1. A farmer can have many cows, but a cow belongs to only one farmer. For each cow the farmer keeps track of the cows name, breed, and date of birth. For each farmer we need to track the farmers first name, last name, street address, city, state, and zip code.
2. An aircraft can take many flights, but each flight is on only one aircraft. A flight can have many passengers, but a passenger can be on only one flight at a time. For each aircraft we want to track the make, model, and year manufactured. For each flight we want to track the origin, destination, date, departure time, and arrival time. For each passenger we want to track the passengers last name, first name, street address, city, state, zip code, seat number, and class (e.g. first, business, or coach).