Question 2. Entity Relationship Diagram (ERD) (10 marks)   Can…

MateFogElephant23 Question 2. Entity Relationship Diagram (ERD) (10 marks)   Can…Question 2. Entity Relationship Diagram (ERD) (10 marks) Can anyone draw a Table of Entity Relationship diagram with crow foot notation as well as Primary Key and Foreign Key? I am confused about which one is FK and the cardinality among each entity. Drawing a table with attributes and crow foot notation would be greatly helpful. Thank you 🙂 Both restaurant chains – ‘Lord of the Fries’ and ‘Pie In The Sky’ – require an application to manage food wastage. The Application Architect has analysed both sets of requirements and found a common application will work for both companies. You have been commissioned to draw the Entity Relationship Diagram (ERD) for the application. The Architect as analysed the requirements and rationalised the entities for the core data of the application. The core data will store Recipes, Shopping Lists, and record what Food a restaurant currently has on hand in the Refrigerator, Freezer and Pantry. The companies have multiple places they shop for food, so separate Shopping Lists need to be catered for. The application will then work with this data to help manage the food wastage in the restaurants. Architect Notes: The central Entity is Food. It requires a Primary Key – FoodID – that will be used in the relationships to the other Entities. The Food Entity requires an Attribute for the Name as well as ContainsGulten, ContainsDairy and ContainsNuts to record possible allergies. The second Entity is Recipe. It requires a Primary Key – RecipeID – for use in. Q2.1: Draw the Entity Relationship Diagram based on the requirements above. Generate the ERD diagram with whatever method you are most comfortable with – Pen and Paper is an acceptable option. Submit a signed and dated version of your diagram. The Data types for the attributes is NOT REQUIRED. Make sure your diagram has a good, clean layout and clearly indicates the Primary and Foreign Keys in the entities. Consider well the relationships between the entities and draw the appropriate Crows Foot notation required. Make sure you note the other Attributes for the Entities in your diagram (ie RecipeMethod entity has a Method attribute) (10 marks) From my understanding: entity is Food, Recipe, Storage, Recipe Method, Recipe Ingredients, Shopping lists, and Shopping list itemsImage transcription textBoth restaurant chains — ‘Lord of the Fries’ and “Pie In The Sky’ —require an application to manage food wastage. The ApplicationArchitect has analysed both sets of requirements and … Show more… Show moree.g.Image transcription textPolicyEditLog Policy Bill Coverage PK ID PK ID PK PK ID FK1Polley_ID CoverageName FK1 Polley_ID PolicyNumber DueDateCoverageGroup Edited TableName Do PolicyEffective… Show more… Show more BusinessBusiness – Other