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 AUAF are five digits. Name First and last names. Home phone number, cell phone number. Students must sign a waiver to play on a team; we must have this document on Phone Waiver 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. Each sport has an assigned coach. We need to know the coach's name, office number (such as BIT-231), office phone number, and cell phone number. A person can coach one or more teams over one or more seasons. Сoach Min and max players Each sport has a designated minimum and maximum number of players. Begin date The date each sport begins. A place to record notes about each sport. Notes 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, BASBAG-3 is three basketballs. Description Storage building Fields: Different courts, fields, and tables are available for practice and games. A description of the equipment. The building where the equipment is stored, such as SB-1. 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. Identify the court field, or table type (basketball, softball, and so on). 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. 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". Туре Maintenance contact Season 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. 2. For each entity you identified, determine the data type to assign to each field, and which attributes to use as the primary key. 3. For each table you designed, use MS Excel to create table design so that you can enter five sample records into it. After creating five records, determine whether you need to make any adjustments in your table designs. If you need to make any changes to your table designs, do so on your MS Excel and add the necessary documentation to the existing table designs.