The primary goal of the intramural department

The primary goal of the intramural department.

Health Information management
All you are doing in setting up a data base identifying the item and description (look at example provided).

1) Define each element being used.

2) List out all specifics about database.

Students please be creative with this. Pick something that you have been doing for a long time, it will be easy.

Also refer to the book for how the data base should be organized.
this is an example:
Database Assignment Example

Database Design
Hershey College is a small liberal arts college in Hershey, Pennsylvania. Because student enrollment at Hershey College is small, the college participates competitively only in football and basketball. However, the athletic department has been encouraging the college for the past several years to develop an intramural department. After receiving a large cash endowment for the development of the intramural department, the college’s board of directors agreed to its creation. The primary goal of the intramural department is to encourage students to participate in sports and activities that promote good health and strong bodies.

The intramural department will offer organized sports leagues for interested students. The department will create schedules for each sport, assign players to teams, provide a coach and a student captain, and manage the team’s playing locations. The department will also offer sports equipment that teams can check out and use for practice and games.
Part of the mandate set by the board for the intramural department is to demonstrate that students are using its service by participating on teams and using equipment. The intramural department must provide reports each semester documenting which sports were offered, how many students participated in them and other information as requested by the board. Admission counselors will also use these reports to show prospective student that there are many opportunities to participate in sports at the college.

The college has appointed Marianna Fuerntes as the director of the intramural department. Marianna has hired you to develop and maintain the database that will manage the departmental activities and produce the required reports. Because the intramural department is new, Marianna is not yet certain of the data the department needs to collect and manage. Initially, she wants the database to manage data about each sport offered by the intramural department (including team assignments, coaches, and scheduling), the students who sign up for sports teams, and the equipment.
Because you are the only person responsible for the database, there is a lot of responsibility on your shoulders to provide a database that works well for the department.

Complete the following:

1. Marianna decides that the best way to get started planning the database is to prepare a list of all the data items that are needed to support the department. The table on the next page shows her list, which she asks you to use when planning the database. You will need to identify the data to collect, group fields into tables, normalize the data, and relate the tables.

For example

Item Description
Students: We need to store information about students who participate on teams and the sports in which they participate, including the team. Students can sign up for more than one sport.
ID number Student and faculty IDs at Hershey are five digits.
Name First and last names.
Phone Home phone number, cell phone number.
Waiver Students must sign a waiver to play on a team; we must have this document on file.
Academic eligibility Students must be academically eligible to play sports by maintaining a C or better grade point average; we must check eligibility at registration.
Sports
Name Sports including basketball, football, ping pong, pool, soccer, softball, swimming, tennis, track, and wrestling.
Coach Each sport has an assigned coach. We need to know the coach’s name, office number (such as JK-18), office phone number, and cell phone number. A person can coach one or more teams over one or more seasons.
Min and max players Each sport has a designated minimum and maximum number of players.
Begin date The date each sport begins.
Notes A place to record notes about each sport.
Equipment: Teams or coaches check out the equipment they need for their sport’s practice sessions.
ID number Equipment is assigned an ID number using a sport abbreviation and a number (BAS = basketball, FTBL = football, PNG = ping pong, POL = pool, SOC = soccer, SOF = softball, and TEN = tennis). For example, BAS-1 is a basketball. Some equipment ID numbers indicate a collection of items. For example, BAS-BAG-3 is three basketballs.
Description A description of the equipment.
Storage building The building where the equipment is stored, such as SB-1.
Fields: Different courts, fields, and tables are available for practice and games.
ID number Courts, fields, and tables are assigned ID numbers. For example, BAS-CRT-1 is a basketball court, SOC-FLD-2 is a soccer field, and POL-TBL-2 is a pool table.
Type Identify the court field, or table type (basketball, softball, and so on).
Maintenance contact Each court, field, and table has an assigned maintenance person, who manages and resolves problems with the court, field, or location. We will need to know the maintenance person’s name, phone number, and office number.
Season The seasons each field is available for use by a team (some fields are unavailable off-season for maintenance purposes). The seasons are fall and spring; some sports run year-round, in which case the season is “always”.
Teams: For each team, we need to know the team number, captain, sport name, location where games are played, and the equipment needed for the game.

The primary goal of the intramural department