Question: Assignment: ER Modeling Create an ER model for each scenario. Make sure that you read the description carefully. Your diagram should reflect a entities, attributes,

 Assignment: ER Modeling Create an ER model for each scenario. Make
sure that you read the description carefully. Your diagram should reflect a

Assignment: ER Modeling Create an ER model for each scenario. Make sure that you read the description carefully. Your diagram should reflect a entities, attributes, and relationships in the description. You should make sure each entity has primary key (a unique identifier). Use the relationship types we used in class (one-to-one, one to many, or many to-many). Don't forget, attributes can describe both entities and relationships. You must submit your diagrams electronically, and they cannot be hand-drawn. Use ERDPlusto create your diagrams (http://www.erdplus com). It is free and it is easy to use You must submit your diagrams electronically in single Word document. You must include your name at the top of the Word document. Your diagrams should be emailed, as a single attachment, to your instructor with the subject: 2502: ER Modeling Assignment The email must be sent by the start of class the daythe assignment is due. you do not follow these instructions, your assignment willbe counted lote. Your diagrams will be graded using several factors: The correct identification of entities and attributes. The correct identification of relationships between your entities. The identification of cardinality between entities. 1: Safety Incident Database for Schuffyland Park Schuffyland Park is a amusement park in suburban Philadelphia. The park is required to provide periodic safety reports to the Commonwealth of Pennsylvania certifying its rides have passed inspection. They must also keep a record of all safety related incidents (such as accidents) for each ride. This information also has to be ready for "surprise audits that can occur any time. An incident involves both a ride and an operator. All operators and rides are included in the database whether or not they've been involved in a safety incident, and the date and shift are recorded each time an operator runs a rideat the park. A ride is described by a name and type.Anoperator is described by their first and last name. When an incident occurs, its date and time are recorded along with a description of the incident. Operators must be trained and certified on the rides they operate.An operator can be certified for multiple rides, and the certification is valid fortwo years from the date they complete their training. The title of the certification indicates the ride for which they are certified. When an incident occurs it is important that the park produce a list of current certifications for the operator (problem description continues on next page. Inspection records are also recorded in the database. An inspection occurs at a particular date and time, with a numeric score from 1 to 5, and notes about the outcome of the inspection. There is only one ride per inspection, even if multiple inspections are done by the same inspector on the same day and time. The information that needs to be recorded about the inspector istheir first and last name. 2:Tracking Trips for the Schuber Taxi Service

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!