Design a database based on client requirements

Assignment Help Computer Engineering

Reference no: EM132088470

Part 1- OBJECTIVE:

Part 1- SCENARIO FOR CLIENT

A high school wants to hold a fundraiser called a Golfathon. In this fundraiser, the school asks volunteer golfers to play 100 holes of golf on a specific date. The volunteers sign up to play golf as a way to raise money for one of the school's sports teams.

The volunteer golfers get donors to sponsor them. The donors are asked to pledge a specific amount of money for each hole that the golfer plays

. For example, if the donor pledges $1 per hole and the golfer plays 100 holes of golf, then the donor will donate $100 to the school. Your job is to design a scalable, normalized database to track data about this fundraiser.

DATA REQUIREMENTS:

The database must track the golfers that are participating in the Golfathon

Each golfer will play for only one sports team

More than one golfer can play for the same team

A donor can sponsor more than one golfer

A donor will pledge an amount per hole of golf for each golfer that he/she sponsors

A donor can pledge different per hole amounts for different golfers

For each golfer, you need to track their name, email, and shirt size, and the team that they are playing for.

For each donor, you need to track their name, email, golfers they are sponsoring, the pledge amount for each golfer, the amount of the pledge that has been paid, the payment date, and the payment method.

For each sports team you need to track the sport (e.g. volleyball, golf, etc.) the level (freshman, Junior Varsity, Varsity), and gender of players (boys vs. girls).

Part 2- INSTRUCTIONS

Start with the script created for part 1 of the Database Design Assignment. Add the following to this script:

Insert date into each of your database tables. Be sure to insert at least 5 golfers, at least 3 teams and at least 10 donors. Also be sure to insert at least 1 donor who is sponsoring multiple golfers for different pledge amounts.

Write a query to return the total amount pledged for each sports team. Remember, the pledge amount is per hole played and the goal is to play 100 holes of golf. Show the sports team name, level, and gender. Order the results by total pledged amount from highest to lowest amount.

Write a query to return the total amount pledged for each golfer. List the golfer name, spots team that he/she is playing for, and the total amount pledged. Order the results to show the golfers with the most to the least amount pledged.

Write a query to list the sponsors for each sports team. List the team sport, team level, and team gender. List the sponsor name and total amount pledged for the team. Order the results by Team ID.

Reference no: EM132088470

Questions Cloud

Write a cpu class that has one member function : Write a CPU class that has one member function, ‘Execute,' which simply gets called to execute the process.

What does a vertex in your state traversal tree represent : Present this result in terms of n and p where nxn is the size of the Sudoku board and p is the number of possible numbers (1-9) permitted in a square.

What are follicle cells : What are follicle cells? What hormone is secreted by developing follicle cells?

Anatomy and physiology : If a section of a DNA template stand contained the sequence TGAGAC, what would be the sequence of bases of the complementary mRNA strand

Design a database based on client requirements : The volunteer golfers get donors to sponsor them. The donors are asked to pledge a specific amount of money for each hole that the golfer plays.

Complexity stephen carver and harvey maylor : PPMP20014 - Complex Project Management - Complexity Stephen Carver and Harvey Maylor apply a flying analogy of four generic types of management

Blood and the amount of carbon monoxide in blood : How is the amount of oxygen limited in its bonding to HB by the pH of the blood and the amount of carbon monoxide in blood

Amount of oxygen in human blood : How does the amount of oxygen bond to HB vary with the amount of oxygen in human blood, such as in the partial pressure exerted by oxygen?

What is the spatial resolution of the panchromatic band from : Add the three bands to the composer: display the first band (njolo1) and then add the others by right clicking on their names in the IDRISI explorer.

User Account

All Pages