Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help- using Oricle SQL datamodeler - what entities/relationships would this subview contain? and what attributes would be in each entity? I am lost county

image text in transcribed

Please help- using Oricle SQL datamodeler - what entities/relationships would this subview contain? and what attributes would be in each entity? I am lost

county stores information about food facilities doing business in the county. WILL NOT STORE ANY INFORMATION UT THE MAP DISPLAY included on the first screenshot. See the screenshot Sub-view 1 on the next page of this gnment. Additional Business Rules: 1. Each facility has a unique street address. The individual details of the address must be saved in separate fields - i.e. street, street part 2, city, state, and zip code. 2. Facilities may have the same names but not the same addresses. 3. Each facility has a single point of contact person, including the first and last name, phone number, and email information of the contact. 4. Each facility may be inspected multiple times by the Douglas County Health department, but only once on the same day. 5. For the purpose of this assignment - Inspected items during each inspection include the following 6 items: 1-Safe food source and storage, 2-Proper food temperature control, 3-Employee health, and personal hygiene practices, 4-Cleaning and sanitation practices, 5-Insect and Pest control, 6-Waste disposal a. Sanitation ratings are based upon a standardized statewide inspection system. 6. Each of the 6 inspected items will be assigned a rating of Superior, Excellent, Standard, and Fair. 7. An overall sanitation rating of Superior, Excellent, Standard, or Fair is recorded for the facility. Note that the sanitation ratings are provided for reference only. Note a domain for these values will be defined in Part 2 of the project. 8. All new facilities are given an initial rating no higher than "Standard" and may move to a higher sanitation rating on subsequent inspections, based upon performance. 9. Facility Risk is assigned to each facility according to the type of food prepared at the facility, how it is prepared, and the chance of cross contaminating the food. The higher the facility's risk, the greater the chance of transmitting a foodborne illness. Note that the risk levels are provided for reference only. Note a domain for these values will be defined in Part 2 of the project. a. A "High Risk" facility prepares foods to cook, cool, and reheat before selling. For example, a "fullservice restaurant" is a "high" risk facility. b. A "Medium Risk" facility sells limited preparation, processed foods. For example, a "fast food restaurant" is a "medium" risk facility. c. A "Low Risk" facility sells prepackaged foods that require no food preparation. For example, a "convenience store, mini-mart, or bodega" is a "low" risk facility. At a minimum, you should have the following entities with relationships and attributes for this External Model (Sub-View): 1. Facility 2. PointOfContact 3. Inspection 4. Optional: Risk_Level which would include ONLY the risk name and the risk description

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases On The Web Designing And Programming For Network Access

Authors: Patricia Ju

1st Edition

1558515100, 978-1558515109

More Books

Students also viewed these Databases questions