Create a small sports database with two tables

Assignment Help Computer Engineering

Reference no: EM131851445

Problem

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 for 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.

Reference no: EM131851445

Questions Cloud

Create a small database to include customer data : Create a small database to include customer data. Include the customer numbers, customer names, and customer directional location.

What elements need to be present for your defense : A customer is injured by you product and files a product liability suit against you.....what possible defenses could you raise?

Create a books database to include two tables : Create a Books database to include two tables: BookTable and CourseBookTable. The BookTable table should have fields for ISBN number, title and copyright date.

What roles does each play within the organizational setting : In a lenglthy peice explain what are the six major functions of human resource management as identified by the Society for Human Resource Management (SHRM)?

Create a small sports database with two tables : 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).

How does an unbalanced concentration of wealth occur : How in a free society like the U.S., can a small group of people continually control so much of the wealth?

Create small bank account database with one account table : Create small Bank Account database with one Account table. Account table should have field for account number customer last and first names and current balance.

Critical analysis of research sources : Choose five of the summaries of readings, either from your set text or from your electronic readings, that you have been preparing each week

Create a small family database with one table : Create a small Family database with one table to include data about members of your family. Include data fields such as family member number and first name.

User Account

All Pages