https://github.com/alejandromumo/projectbd
Database lab class project
Science Score: 13.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
○CITATION.cff file
-
✓codemeta.json file
Found codemeta.json file -
○.zenodo.json file
-
○DOI references
-
○Academic publication links
-
○Committers with academic emails
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Low similarity (6.9%) to scientific vocabulary
Repository
Database lab class project
Basic Info
Statistics
- Stars: 0
- Watchers: 1
- Forks: 0
- Open Issues: 0
- Releases: 0
Metadata Files
README.md
ProjectBD
This project refers to the course Databases from the Universidade de Aveiro in 2017/2018. It was implemented in the scope of the laboratory classes. In this project, a database containing football entities (i.e. players, clubs, leagues, etc) is desgined and implemented.
DB design
The database's design starts by analysing a set of requirements simulating a real world's process that begins with stakeholders. The design takes in to consideration a set of practices to reduce redundancy such as normalization.
DB implementation
The implementation's provides features such as:
- Access control mechanisms, namely stored procedures.
- Defensive programming in the stored procedures to ensure database's robustness.
- Transactions that guarantee the database's integrity.
- Authentication.
- Indexes to improve efficiency and provide faster response to common queries.
The database was implemented using SQL and it was hosted in a Univeristy's cluster running SQL Server.
DB's .NET interface
In order to connect to the database and access it, a .NET interface was implemented. Its main function is to expose the database's public stored procedures to the visual application that the user is running.
Visualization
The visual application developed for this project is not in the scope of this repository. Nonetheless, it was built using a Model-view-viewmodel pattern in C#. Refer to the project https://github.com/rodrigogonegit/ihcprojectUI
Data
Data was extracted and parsed from kaggle's SOFIFA data set (https://www.kaggle.com/thec03u5/fifa-18-demo-player-dataset)
Owner
- Name: Manuel Alejandro
- Login: alejandromumo
- Kind: user
- Location: Geneva, Switzerland
- Company: CERN
- Repositories: 10
- Profile: https://github.com/alejandromumo
Computer Engineer | CERN Open Science Repositories | @inveniosoftware @zenodo
GitHub Events
Total
Last Year
Committers
Last synced: about 1 year ago
Top Committers
| Name | Commits | |
|---|---|---|
| alejandromumo | m****7@g****m | 26 |
Issues and Pull Requests
Last synced: about 1 year ago
All Time
- Total issues: 0
- Total pull requests: 0
- Average time to close issues: N/A
- Average time to close pull requests: N/A
- Total issue authors: 0
- Total pull request authors: 0
- Average comments per issue: 0
- Average comments per pull request: 0
- Merged pull requests: 0
- Bot issues: 0
- Bot pull requests: 0
Past Year
- Issues: 0
- Pull requests: 0
- Average time to close issues: N/A
- Average time to close pull requests: N/A
- Issue authors: 0
- Pull request authors: 0
- Average comments per issue: 0
- Average comments per pull request: 0
- Merged pull requests: 0
- Bot issues: 0
- Bot pull requests: 0
Top Authors
Issue Authors
Pull Request Authors
Top Labels
Issue Labels
Pull Request Labels
Dependencies
- Dapper 1.50.4