Below are 2 entities which contain the primary keys only. State what kind of relationship exists between these entities. Explain your answer Recipe Ingredient PK Recipe Key PK Ingredient key 1. Create a diagram that shows how you would resolve the relationship in the diagram above. 2. A Professor needs a relational database to store grades. She has identified the following three entities. Course, Student and Assignment. What kind of relationship exists between these entities? 3. Create an ERD for the Professor's database. You are not required to add the attributes but each entity must hav primary key. Remember to resolve any many to many relationships. 4. For this part you will participate in a discussion which will require you to start a new thread and add 1 tool which be used to create an "ERD" preferably an open source tool OR a link to a website which provides a tutorial on how create ERDS