You are volunteering for a local children's softball league. They asked you to create an app...

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.

Solutions

Expert Solution

Answer:

1.All the required business rules that will captured by the project design should be:

Facts relating terms to each other:Facts can be documented as natural language sentences or as relationships, attributes, and generalization structures while designing a database for a project.
Secondly, all the constraints that are applied on a database which relate one entity to another and it provide easily and efficient access to data.
Here we have entities namely player, parents, coaches, team and have relationships among them.So, by considering all these elements of database we need to design an efficient database management system.

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

venereology answered 5 months ago

Next > < Previous

Related Solutions

While volunteering at an assisted living facility, you are asked to participate in the care of...

While volunteering at an assisted living facility, you are asked to participate in the care of an 82 year-old female resident with limited mobility. When you are first introduced to Gladius Claymore, you notice she often rubs and taps at the side of her left hip, but still greets you with a welcoming smile. Gladius often spoke of experiencing shooting pain, numbness, and weakness on her lower back, the posterior side of her left buttocks, and her posterior lower limb....

Your friend Victoria runs a parrot rescue organization and has asked you create an app that...

Your friend Victoria runs a parrot rescue organization and has asked you create an app that will help her keep track of the parrots that have been in the rescue. For each parrot, Victoria needs to know the parrot’s name (pName), type of parrot (pType), age (pAge) and whether it has been adopted (isAdopted). She needs to be able to feed the parrot and bathe the parrot. You will write two classes for this app: the Parrot class and ParrotDriver...

PYTHON IS3073 1. A group of statisticians at a local college has asked you to create...

PYTHON IS3073 1. A group of statisticians at a local college has asked you to create a set of functions that compute the median and mode of a set of numbers, as defined in Section 5.4. Define these functions in a module named stats.py. Also include a function named mean, which computes the average of a set of numbers. Each function should expect a list of numbers as an argument and return a single number. Each function should return 0...

You are chairperson of the investment fund for the Continental Soccer League. You are asked to...

You are chairperson of the investment fund for the Continental Soccer League. You are asked to set up a fund of semiannual payments to be compounded semiannually to accumulate a sum of $220,000 after nine years at a 12 percent annual rate (18 payments). The first payment into the fund is to take place six months from today, and the last payment is to take place at the end of the ninth year. Use Appendix A and Appendix C for...

Android Programming Create an app called GuessWho. The point of the app will to have the...

Android Programming Create an app called GuessWho. The point of the app will to have the user play a guessing game based on a displayed image. The user will be greeted with a screen that has an image of a person, four buttons and a next button. The four buttons should each have a different name on it. One of the names will be the actual name of the person in the image. Your guess who quiz should consist of...

Suppose that you produce and sell children's tables in a local market. Past experience enables you...

Suppose that you produce and sell children's tables in a local market. Past experience enables you to estimate your demand and marginal cost schedules. This information is presented in the accompanying table. Complete the following table by computing the total cost of producing each quantity. Then, compute the total revenue earned at each price level and the marginal revenue earned at each price level. Price Quantity Demanded Fixed Cost Total Cost Marginal Cost Total Revenue Marginal Revenue ($ per table)...

"swift Create a SwiftUI project named DogBreeds based on the Contacts app. The app should be...

"swift Create a SwiftUI project named DogBreeds based on the Contacts app. The app should be named DogBreeds. The app will display 10 dog images and names in a lis"

Create a simple python app that allows the user to create a roster of students and...

Create a simple python app that allows the user to create a roster of students and their grade on CUS-1166. Moreover the app needs to calculate the average grade of students added to the roster. 1-To begin with, create a new file n the same working folder as part A (i.e. cus1166_lab1) and name it app.py. Moreover, create a subfolder and name it mymodules. 2-Within mymodules create the files __init__.py , models.py , math_utils.py . 3-In the models.py file define...

I am designing cost comparing/ order app. Can anyone create prototype of this app include that...

I am designing cost comparing/ order app. Can anyone create prototype of this app include that features: cost comparing, offer& coupons, user reviews, order tracking , interactive buttons, design.

You are an IT manager for a small business. You are being asked to create a...

You are an IT manager for a small business. You are being asked to create a network security plan both for internal IT workers and for the company in general. You are to put together a network security plan that addresses each of the following components : Explain the use of virtual private networks (VPNs) and their security benefits and drawbacks. Create a standard procedure for adding new users to a network. Create a summary of a network plan, including...

Subjects