it 240 final project

Zihan Wang

I. Ideation

Hawkins Soccer Club is a community-based soccer club for the youth aged 15 to 35 years. The club is managed by a team manager with the help of several other personnel. The team includes the head coach, assistant coach, and goalkeeper coach who specially trains the goalkeeper. The club has a well thought program of recruiting its players. The players undergo medical tests including blood pressure test, heartbeat rate, assess previous medical history, plus other key physical examinations. Players are signed up according to the position they play in line with standard soccer game formation. In its daily operations, Hawkins Soccer Club records the matches attended, match captain, player substitutions, goals scored, penalty shootouts, disciplinary cards issued, and injuries incurred during matches.

The purpose of this study is to design a relational database management system for Hawkins Soccer Club. The database would be developed procedurally from conceptual model, logical model, physical model in MS Access, and eventually testing with real-world data to ascertain conformance to relational Standard Query Language rules.

II. Problem Definition

Wish to solve the problem of data redundancy and inconsistencies associated with data manipulation anomalies. Hence, the aim is to organize and structure Hawkins Soccer Club data for efficient and consistent management.

A. Problems and concerns to be addressed

Insert: When inserting new records into the current Excel sheet, there is risk of mismatch between excel rows and the column headers. As such, inconsistencies exist between highly segmented Excel tables. For example, when adding new players; player address information can be mixed up with player personal information.

Update: Data modification in Excel is achieved by search and replace method. It can be done per workbook, worksheet, or per column containing specific information. The problem is the columns are not interlinked with related data. Hence either part of the records is updated, or wrong records updated.

Delete: Since several tables have been created in a single Excel sheet, deletion of specific information is tedious and time consuming. Caution has to be exercised not to delete records in other tables lying in the same Excel sheet row.

Below is attached spreadsheet table sampled from the current Hawkins Soccer Club data, it forms the basis of this study.

B. Examples of the current approach

The current approach involves entry of data in spreadsheets using Microsoft Excel. Workbooks exist that contain various worksheets of data. The data is organized in tables and columns that describe the rows of data inserted. Information stored include biodata of the players, matches, and individual player performance.

C. The new approach

The new approach will organize existing data into six entities namely: players, player details, addresses, matches, match captains, and goals. The players table would store basic information about player including name, joining date, and player position. Players table is linked to player details that further stores more detailed biodata related to each player. Moreover, every player has got specific address information that is stored in the address table. The attached sample data describes segmentation and relation of the three tables.

PLAYERS(PlayerID, LastName, FirstName, JoinDate, PlayerPosition) Comment by Evelyn Lulis: Use this format, do nto copy and paste from Access

PLAYER_DETAILS( ALL of the fields here belong in the player table

Who are the address for?

Try:

The PLAYER table should include all the info ab out a player.

Not certain Position should be in this table

Players( PlayerID, LastName, FirstName, JoinDate, PlayerPosition, DOB, gender, martital status, etc.

You need more info.

Perhaps a table of COACH, billing/fee info such as Account,