Problem
Identify the one-liners (relationship statements). Your identification must be comprehensive and complete so that all reports can be produced. REMEMBER that reports themselves are NOT entities. Determine the relationship type: Binary 1:1 (one-to-one), 1:M(one-to-many), or M:N(many-to-many) or recursive(unary) 1:1, 1:M or M:N or superclass/subclass. Write the four statements of cardinality. For superclass/subclass show descriptive paragraph explaining whether it is Mandatory/Optional or And/OR and mark this on the diagram.
Draw the ER Diagram as usual and determine the number of tables. USE draw.io to draw your diagrams.
Pay special attention to the injuries report. Make sure you have all the entities and relationships necessary to produce this and other reports.
Write the SQL necessary to create the tables.
There is no need to combine all the ER diagrams into one master diagram (Enterprise ER Model) as shown in the book.