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: 
This is what I have so far:
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
Get step-by-step solutions from verified subject matter experts
