Zebra0.com

Case Study: Babysitter Database, What if?

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?

NEXT: Normalization in DBMS