Q1) These following questions require to you to create entities and their relationship using the Crow's Foot notation suitably. Write out the business rule along with the diagram. If you encounter a many to many relationship, illustrate that first, then the corrected one after that. Indicate the appropriate keys along with the attributes.

a) Farmer Bob, Farmer Jane and Farmer Jose run a cow farming co-op. For every cow they keep the cow's name, age (or date of birth), breed and numbered plastic ear tag. The each of the three farmers own many cows and share some of the cows with one another.

b) An art researcher has asked you to design a database to record details of artists and the museum in which their paintings are displayed. For each painting, the researcher wants to know the size of the canvas, year painted, title, and style. The nationality, date of birth and death of each artist must be recorded. For each museum, record details of its location and specialty, if it has one.

c) A hamburger shop makes several types of hamburgers, and the same ingredient can be used with several types of hamburgers. This does not literally mean the same piece of lettuce is used many times, but that lettuce is used with several types of hamburgers.