**USE 1:1 AND RECURSIVE DATE MODELING, AND CROW'S FOOT NOTATION OR I WILL NOT THUMBS UP THE ANSWER**

Part I. Review examples on 1:1 and Recursive data modeling slides.

Part II. Please draw an ER Diagram and write Relational Data Model for the following scenarios: A dairy farmer has several herds of cows. He has assigned each cow to a particular herd. In each herd, the farmer has one cow that is the leader of the herd.

Design a database to store product details for a manufacturing plant. Some products are purchased from suppliers. A supplier can provide many products; a product, if it needs a supplier, can only be purchased from one supplier. A product can be (but is not always) a part of many other products and can be made up of many products. The following information for each product should be recorded: product number, product name, year of build.