E-R Relationship for the Cooking Show

Question: Discuss about the E-R Relationship for the Cooking Show. Answer: Introduction: Explanation Cooking show has been explained with this Entity Relationship diagram shown above. We have taken 5 entity named as () 1. Administrator 2. Chef 3. Viewer 4. Recipe 5. Show After that, it has been explained by their attributes The attributes are the one which describes the entity with their name, id, ph.no. , ref.id, etc. For example: As in this case the viewer is considered as an entity and the viewer_id, viewer _age, viewer_ name, viewer_CNIC are their attributes. Relationship Relationship indicates how the entities are connected with each other. In this, the chef has a relationship with the recipe as the recipes are made by the chef. Then the viewers are connected with the show as the show is watched by the viewer. Like this, all are connected to one or other in cooking show. The cooking show is the main entity in through which all are connected. I have created a relationship between the Entities as each one of them are interlinked. Conclusion The following E_R Diagram is made for the Cooking show which is presented by a Host and different viewers are watching the show. The administrator is responsible for the broadcasting of the show for the viewers and the Chef or Host is creating the recipes. They are connected to each which I have shown in the E_R Diagram. Reference Beynon, .D, (2004). Database Systems. Basingstoke, UK: Palgrave: Houndmills Barker et.al, (1990). CASE Method: Entity Relationship Modeling. Addison-Wesley