In: Computer Science
You are volunteering for a local children's softball league. They asked you to create an app or a Web application to help in their operations. You decide to create a database. The league consists of several teams. Players are assigned to teams at the start of the season. It also collects parents' contact information, and charges season and optional equipment rental fees. League volunteers include officials, referees, coaches, and first aid attendants. Parents also volunteer to help at individual practices and games. The teams meet for regular practices at several ballparks at public parts; practices are scheduled, and permits are obtained from the city. Regular season and playoff games are scheduled at some or all of these ballparks; results and player statistics are collected.
For the first draft of your system:
1) Identify business rules your design will capture.
2) Identify entities, keys, and constraints. Create an ER diagram (format and software package up to you). You can also design your database directly in terms of DB tables. (one possible tool: https://sqldbm.com/Home/ ).
3) Based on ER model, design a database (skip this step if your design is already in DB-specific terms). Suggest foreign key constraints and indexes.
4) Is your design in 3rd Normal Form. If so, explain. If it is not, revise your design until it is in 3NF.
5) Generate or write SQL DDL statements that create your database objects.
Answer:
1.All the required business rules that will captured by the project design should be:
2.
3.
4.The relation is in 3NF because non prime attribute can be identify by a prime attribute and X->Y where X is a prime attribute.
5.I already run DDL commands in answer 2.
Hope this will be helpful for you...............Thanks