Zebra0.com

Database Design

The Babysitter database is somewhat simplified. In real life, families can have some more complex problems. How would you handle each of the following situations?

• We have not included the relationship of the adult, such as guardian, father, mother, grandmother, stepmother, etc. What table would you put this in?
• One mother says that her daughter is lactose intolerant and gluten sensitive. Another tells you that her child is terrified of spiders.
• We have assumed that every child lives in one place. What if two parents have joint custody? How would the database handle that?

That's all! Congratulations on completing all of the lessons in systems!