Scenario - Children's Playgroup
A local community center is establishing a children's playgroup that will introduce children in the neighborhood to other parents and children. This playgroup will sponsor weekly play sessions with a structured activity and free play time each week. If this program is successful, the community center would like to offer this play session on a daily basis. The following information needs to be considered, a parent can have more than one child, the parent information, including name, phone number, and mailing address need to be tracking. Child's name, gender and age need to be tracked. The ability to track one or more sessions, including date, time, location and session type. Eventually the community center would like to add additional special "activities" that the parents and children would be interested.
Assingment:
• Identify the entities that need to be modeled
• Identify the attributes that each entity will include
• Identify the relationships as required.
• Identify the primary keys (identifier attributes)
• Identify any business rules or assumptions that are associated with your data
Use this data model that you designed. This data model will be reviewed and taken from the conceptual model to logical or physical model status.
Make sure you define the following:
1. Select database management system (Oracle, SQL Server, MYSQL, etc) and identify the data types and sizes for all attributes.
2. Make sure all relationships have been addressed and corrected.
3. Review data model to make sure data model is in at least 3rd normal form (as defined by the normalization process).