Reference no: EM13755227
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).
|
Utilize a minimum of 2 scholarly resources to support
: Instructions: Complete the case study below by answering each question. Utilize a minimum of 2 scholarly resources to support responses to Part I of the case study. For Part II show all calculations. This is not a formal written paper; however, an AP..
|
|
Uses the perpetual inventory system
: Hitzu Co. sold a copier costing $4,500 with a two-year parts warranty to a customer on August 16, 2013, for $9,000 cash. Hitzu uses the perpetual inventory system. On November 22, 2014, the copier requires on-site repairs that are completed the same ..
|
|
Confidence interval of the mean score
: Question: A sample of 93 golfers showed that their average score on a particular golf course was 89.33 with a standard deviation of 6.43.
|
|
A company produces to a seasonal demand
: A company produces to a seasonal demand, with the forecast for the next 12 months as given below. Month Demand January 600 February 700
|
|
Identify the data types and sizes for all attributes
: Select database management system (Oracle, SQL Server, MYSQL, etc) and identify the data types and sizes for all attributes
|
|
Scheme of pollution regulation in the united states
: Which of the following best describes the overall scheme of pollution regulation in the United States?
|
|
Write research paper about data communication
: Write research paper about Data Communication
|
|
Write article review on industrial revolution by david
: Write article review on Industrial Revolution by David Christian of c. 1750-1900 and how it marked another threshold in human history.
|
|
Demonization of minority groups
: Martin argues that with or without ethnocentrism, social identity based in group membership is inevitably associated with the demonization of minority groups. Who is correct?
|