I am stuck in this database question. Can you help me out. I have watched the question picture below. Students: We need to store information about students who participate on teams and the sports in whichthey participate, including the team. Students can sign up for more than one sport.Student and faculty IDs at AUAF are five digits.First and last names.ID numberNameHome phone number, cell phone number.Students must sign a waiver to play on a team; we must have this document onPhoneWaiverfile.Academic eligibilityStudents must be academically eligible to play sports by maintaining a C or bettergrade point average; we must check eligibility at registration.SportsNameSports 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, officenumber (such as BIT-231), office phone number, and cell phone number. Aperson can coach one or more teams over one or more seasons.CoachMin and max players | Each sport has a designated minimum and maximum number of players.Begin dateThe date each sport begins.A place to record notes about each sport.NotesEquipment: Teams or coaches check out the equipment they need for their sport's practice sessions.ID numberEquipment 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.DescriptionStorage buildingFields: 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.Courts, fields, and tables are assigned ID numbers. For example, BAS-CRT-1 is abasketball 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 andresolves problems with the court, field, or location. We will need to know themaintenance person's name, phone number, and office number.The seasons each field is available for use by a team (some fields are unavailableID numberТуреMaintenance contactSeasonoff-season for maintenance purposes). The seasons are fall and spring; somesports 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 areplayed, and the equipment needed for the game.2. For each entity you identified, determine the data type to assign to each field, andwhich attributes to use as the primary key.3. For each table you designed, use MS Excel to create table design so that you can enterfive sample records into it. After creating five records, determine whether you need tomake any adjustments in your table designs. If you need to make any changes to yourtable designs, do so on your MS Excel and add the necessary documentation to theexisting table designs. AUAF is a small liberal arts university in Kabul, Afghanistan. Because studentenrollment at AUAF is small, the university participates competitively only in footballand basketball. However, the sport department has been encouraging the university forthe past several years to develop an intramural department. After receiving a large cashendowment for the development of the intramural department, the university's board oftrustees agreed to its creation. The primary goal of the intramural department is toencourage students to participate in sports and activities that promote good health andstrong bodies.The intramural department will offer organized sports leagues for interested students. Thedepartment will create schedules fore each sport, assign players to teams, provide a coachand a student captain, and manage the team's playing locations. The department will alsooffer 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 thatstudents are using its service by participating on teams and using equipment. Theintramural department must provide reports each semester documenting which sports wereoffered, how many students participated in them and other information as requested by theboard. Admission counselors will also use these reports to show prospective student thatthere are many opportunities to participate in sports at the university.The university has appointed Dr. Sami as the director of the intramural department. Dr.Sami has hired you to develop and maintain the database that will manage thedepartmental activities and produce the required reports. Because the intramuraldepartment is new, Dr. Sami is not yet certain of the data the department needs to collectand manage. Initially, he wants the database to manage data about each sport offered bythe intramural department (including team assignments, coaches, and scheduling), thestudents who sign up for sports teams, and the equipment.Because you are the only person responsible for the database, there is a lot ofresponsibility on your shoulders to provide a database that works well for the department.Complete the following:1. Dr.Sami decides that the best way to get started planning the database is to prepare alist of all the data items that are needed to support the department. The table on thenext page shows his list, which he asks you to use when planning the database. Youwill need to identify the data to collect, attribute and entities.ItemDescription

Question

I am stuck in this database question. Can you help me out. I have watched the question picture below. Students: We need to store information about students who participate on teams and the sports in whichthey participate, including the team. Students can sign up for more than one sport.Student and faculty IDs at AUAF are five digits.First and last names.ID numberNameHome phone number, cell phone number.Students must sign a waiver to play on a team; we must have this document onPhoneWaiverfile.Academic eligibilityStudents must be academically eligible to play sports by maintaining a C or bettergrade point average; we must check eligibility at registration.SportsNameSports 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, officenumber (such as BIT-231), office phone number, and cell phone number. Aperson can coach one or more teams over one or more seasons.CoachMin and max players | Each sport has a designated minimum and maximum number of players.Begin dateThe date each sport begins.A place to record notes about each sport.NotesEquipment: Teams or coaches check out the equipment they need for their sport's practice sessions.ID numberEquipment 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.DescriptionStorage buildingFields: 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.Courts, fields, and tables are assigned ID numbers. For example, BAS-CRT-1 is abasketball 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 andresolves problems with the court, field, or location. We will need to know themaintenance person's name, phone number, and office number.The seasons each field is available for use by a team (some fields are unavailableID numberТуреMaintenance contactSeasonoff-season for maintenance purposes). The seasons are fall and spring; somesports run year-round, in which case the season is “always&#34;.Teams: For each team, we need to know the team number, captain, sport name, location where games areplayed, and the equipment needed for the game.2. For each entity you identified, determine the data type to assign to each field, andwhich attributes to use as the primary key.3. For each table you designed, use MS Excel to create table design so that you can enterfive sample records into it. After creating five records, determine whether you need tomake any adjustments in your table designs. If you need to make any changes to yourtable designs, do so on your MS Excel and add the necessary documentation to theexisting table designs. AUAF is a small liberal arts university in Kabul, Afghanistan. Because studentenrollment at AUAF is small, the university participates competitively only in footballand basketball. However, the sport department has been encouraging the university forthe past several years to develop an intramural department. After receiving a large cashendowment for the development of the intramural department, the university's board oftrustees agreed to its creation. The primary goal of the intramural department is toencourage students to participate in sports and activities that promote good health andstrong bodies.The intramural department will offer organized sports leagues for interested students. Thedepartment will create schedules fore each sport, assign players to teams, provide a coachand a student captain, and manage the team's playing locations. The department will alsooffer 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 thatstudents are using its service by participating on teams and using equipment. Theintramural department must provide reports each semester documenting which sports wereoffered, how many students participated in them and other information as requested by theboard. Admission counselors will also use these reports to show prospective student thatthere are many opportunities to participate in sports at the university.The university has appointed Dr. Sami as the director of the intramural department. Dr.Sami has hired you to develop and maintain the database that will manage thedepartmental activities and produce the required reports. Because the intramuraldepartment is new, Dr. Sami is not yet certain of the data the department needs to collectand manage. Initially, he wants the database to manage data about each sport offered bythe intramural department (including team assignments, coaches, and scheduling), thestudents who sign up for sports teams, and the equipment.Because you are the only person responsible for the database, there is a lot ofresponsibility on your shoulders to provide a database that works well for the department.Complete the following:1. Dr.Sami decides that the best way to get started planning the database is to prepare alist of all the data items that are needed to support the department. The table on thenext page shows his list, which he asks you to use when planning the database. Youwill need to identify the data to collect, attribute and entities.ItemDescription

Accepted Answer

Database is not mentioned here, so i define d the data type as per the MSSQL