Question: can someone answer this using datamodeler please Task 1 - Sub-view 4/External Schema 4: Complaints and Responses ( 20 points) Any consumer may file a

can someone answer this using datamodeler please can someone answer this using datamodeler please

Task 1 - Sub-view 4/External Schema 4: Complaints and Responses ( 20 points) Any consumer may file a complaint against a food facility. See the screenshots on the next 3 pages for additional information. Additional Business Rules: 1. For each customer filing a complaint, the county needs to record the name, address, phone, e-mail address, age, and gender. 2. For each complaint, the county needs to record the date of the complaint, the facility for which the complaint applies, the text of the complaint (or comments left by the customer filing the compliant), and the type of complaint (Illness, Sanitary Conditions, Employee Conduct, Other) Note this domain will be defined in Part 2 of the project. a. Each complaint is for one of the following 3 types: foodborne illness (Illness) contracted at the facility, the sanitary conditions (Sanitary Conditions) of the facility, or the conduct of an employee at a facility (Employee Conduct). Note this domain will be defined in Part 2 of the project. 3. If the complaint type is "Illness", the county needs to record the Causative Pathogen, the number of people ill, if the person is still ill (yeso), and the date symptoms started. a. You do not need to store the symptoms reported by the customer as shown in the table labeled "Sub-view Table 4a on the next page of this assignment. b. Each illness complaint can only match a single illness. 4. Each complaint is filed by one person and is about a single facility. 5. A single person can file multiple complaints about different facilities. 6. A facility may have many complaints filed against it. 7. Illness information: For each type of illness, store the Causative Pathogen, Incubation Time, and the Length of Illness for each type of illness. See the table labeled "Sub-view Table 4a on the next page for sample data. At a minimum, you should have the following entities for this External Model (Sub-View): 4. Customer 5. Complaint 6. Illness_Information 7. Facility Ensure you include attributes for each entity and any relationships that exist between the entities. Reminder: Do NOT create duplicate entities. Drag-and-drop previously created entities from the navigation pane to the model 'work area', then add any new attributes/fields and relationships mentioned for this sub-view

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 General Management Questions!