Problem
Approach the project as any other ER Modeling quiz or assignment and follow the same format. 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 a 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.
Task
i. From information in the narrative description of the case, draw a preliminary entity-relationship diagram to enable Ron and his team to design the data base appropriately.
ii. Construct a conceptual model to represent the data processing requirements outlined in the case. Express the model as a: a. Set of third normal form relations b. Network model
iii. Using the statistics provided in the case and any further assumptions that you might care to make, add data volumes and usages to the conceptual model. Develop a preliminary estimate of the total size of the data base.