smagara / smagara/AgilitySports_data
Normalize the AgilitySports database model
Open
@smagara is already working on this.
Since Nov 2, 2025.
documentation
enhancement
SQL
- Dominant language
- TSQL
- Stars
- 0
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
Task Description
Currently the tables in the Agility Sports database are denormalized dumps of information scraped from the Web for each sport. Create a normalized schema to store this information more efficiently and logically. Also provide a Diagram.
Acceptance Criteria
- API layer is updated to consume the new Model
- Existing web functionality is unchanged, or improved
- Roster data is refreshed for the most recent sports season
Technical Details
- Rather than separate Roster tables per sport. Create a Player table, a Team Table, etc as appropriate
- Check in all DDL and SQL scripts to populate the new schema
- Regression test all API endpoints and website screens
Related Issues
- Many Subissues to handle the various layers involved (See below).
- Database schema diagram and/or documentation
- AgilitySports_API changes to consume the new schema unit test successfully.
- Azure deployment adjustments
- Docker support
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.