You have been hired as an intern at the local community center. The center has a number of sports programs for youth. You have been asked to create a database to keep track of the programs and the youths who participate in these sports activities. The Community Center database must support the following requirements:i. For an activity, store its number and name, for example, 051, Track. Each activity has a cost associated with it.ii. For a participant, store his or her number, first name, and last name as well as the name, home telephone number, and cell telephone number of the parent or guardian primarily responsible for the participants.iii. One participant can enroll in many activities, and one activity can include many participants. One parent/guardian can have many participants.Based on these requirements:1. Identify and list the entities and attributes of those entities. 2. Identify and list the functional dependencies. 3. Without creating a set of dependency diagrams, write the relational schema that meet 3rd NF requirements.
You have been hired as an intern at the local community center. The center has a number of sports programs for youth. You have been asked to create a
i. For an activity, store its number and name, for example, 051, Track. Each activity has a cost associated with it.
ii. For a participant, store his or her number, first name, and last name as well as the name, home telephone number, and cell telephone number of the parent or guardian primarily responsible for the participants.
iii. One participant can enroll in many activities, and one activity can include many participants. One parent/guardian can have many participants.
Based on these requirements:
1. Identify and list the entities and attributes of those entities.
2. Identify and list the functional dependencies.
3. Without creating a set of dependency diagrams, write the relational schema that meet 3rd NF requirements.
Step by step
Solved in 2 steps