Create a logical entity-relationship diagram (ERD) using Crow’s Foot notation that illustrates the relational database design described by the comprehensive business rules established in Exercise #1 above.All entities should be normalized to BCNF.

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

Learning Goal: I’m working on a information technology exercise and need an explanation and answer to help me learn. Section One Introduction The Happy Animals Zoo currently tracks its animals using a spreadsheet and wants to upgrade to a relational database. You have been tasked with converting the current flat field design into a relational database design. The zoo has given you its current spreadsheet design, which contains the following columns: Animal ID
Animal Name
Birth Date
Acquisition Date
Species Scientific Name
Species Common Name
Species Description
Daily Food Need in Pounds
Food Purchased Through Date
Exhibit 1 Name
Exhibit 1 Revenue
Exhibit 1 Participated
Exhibit 2 Name
Exhibit 2 Revenue
Exhibit 2 Participated
Exhibit 3 Name
Exhibit 3 Revenue
Exhibit 3 Participated
The zoo has also given you the following business rules, which are incomplete and are not all necessarily structural: The date each animal is acquired by the zoo is recorded.
Every animal has a species.
Every species requires an average number of pounds of food per day.
Food is purchased in bulk for each animal, and the zoo tracks how long the food will last for the animal.
Three special fundraising exhibits are offered each year.
Animals are selected to participate in the fundraising exhibits, and whether or not each animal participated in an exhibit is tracked.
Exercises Exercise 1 Create a comprehensive list of business rules that specifies all entities, relationships, optionality constraints, and plurality constraints.Your proposed business rules must make provision for both the existing data and the provided business rules. Exercise 2 Create a logical entity-relationship diagram (ERD) using Crow’s Foot notation that illustrates the relational database design described by the comprehensive business rules established in Exercise #1 above.All entities should be normalized to BCNF. Recall that logical ERDs must contain SQL-based constraints on the attributes, including primary and foreign key constraints. Section Two Introduction The following incomplete list of business rules describes the relationships between different types of food-related businesses: Restaurants can be diners, pizzerias, delis, or none of these
Restaurants and grocery stores are food businesses, but not all food businesses are restaurants or grocery stores.
Some delis and pizzerias are take-out restaurants.
Some restaurants are sit-down only restaurants, but not all restaurants are sit-down only.
Supermarkets and supercenters are grocery stores, but not all grocery stores are supermarkets or supercenters.
Food manufacturers are food businesses, and can be canneries, packaging plants, both or neither.
All relationships described in these rules are specialization-generalization relationships. These rules also reflect the entities and relationships that exist in the real-world. Exercises Exercise 1 Create a complete list of business rules that are consistent with the incomplete list given above. Try to order the rules logically, either starting at the bottom of the hierarchy working upward, or from the top of the hierarchy working downward. This list should make provision for all entities and relationships given in the above list, and there can be many solutions that do so correctly. Exercise 2 Develop an extended entity-relationship diagram (EERD) that illustrates the relational database design described by the business rules in #1. The diagram should include the primary key of each table in order to demonstrate correct implementation of specialization-generalization. While EERDs may well contain other attributes, in this assignment you need not include them because they are not described in the business rules. You should use legal database identifiers such as Sit_Down_Restaurants or Food_Manufacturers in your EERD.
Requirements: 4 pages

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services