Question: Databases MySQL Diagram Question: This is what I have so far: Any help would be appreciated. Thanks in advance! A chain of daycare center has

Databases MySQL Diagram Question: Databases MySQL Diagram Question: This is what I have so far: Any

This is what I have so far:

help would be appreciated. Thanks in advance! A chain of daycare center Any help would be appreciated. Thanks in advance!

A chain of daycare center has hired you to design a database management system. After meeting with the owners, you have come up with the following initial set of entities and attributes: Daycare Parent DayCarelD Manager Address (street, city, state, zipcode) Telephone ParentID Name Address (street, city, state, zipcode) Telephone CellPhone Child ChildID Name DOB Age Gender DietaryRestrictions (may be more than 1) Relative RelativelD Name Telephone CellPhone After further conversations, you have learned the following: 1. 2. 3. 4. 5. 6. A daycare center can have 1 or more children. A child can be only at one day care center A daycare center has 1 or more parents, a parent can only use 1 daycare center A parent can have multiple children and must have at least 1 child A child can have 1 or 2 parents A child can have 0,1 or more relatives, who can pick the child up in an emergency A relative can be for one or more children

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!