Answer to Question #56415 in C# for jack moor

Question

Create a small Sports database with two tables: Team and Athlete. The Team table should include fields for the type of team (e.g., basketball), coach’s name (both last and first), and the season the sport is most active (S for spring, F fo Fall, or B for both). The Athlete table should include fields for student number, student first and last names, and type of sport. Use the same identifier for type of sport in both tables to enable the tables to be related and linked. Populate the tables with sporting teams from your school. The type of database (SQL Server or Access) will be determined by your instructor. Write a C# program that displays information about each team, including the names of the athletes.