This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1. Introduction | |
| This report presents the physical database design for a multi-sport tournament management system. The system is modelled after real-world events such as the Commonwealth Games and the European Championships (European Athletics, 2025). The design covers data management across multiple sports, scheduling, results recording, standings calculation, and performance reporting. | |
| The physical model has been developed in accordance with the requirements of the assignment brief and is presented as a crow's foot Enhanced Entity-Relationship Diagram (EERD) created using Lucidchart. This report accompanies that diagram and provides the design assumptions, rationale, and justification for key architectural decisions including the chosen inheritance strategy, denormalisation approach, and non-key indexing. | |
| 2. Design Assumptions and Rationale | |
| A number of assumptions were made during the design process to resolve ambiguities in the scenario and to reflect realistic tournament management requirements. These ar |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| . Inheritance Strategy: Concrete Table Inheritance | |
| The scenario requires managing sport-specific player statistics that vary significantly in structure between sports. For example, a football player accumulates yellow and red cards and shots on target, while a swimmer is measured by stroke type and best time in seconds, and an athletics competitor has a personal best distance or time per event type. | |
| https://martinfowler.com/eaaCatalog/inheritanceMappers.html | |
| Three primary strategies exist for mapping object inheritance to relational tables: Single Table Inheritance, Class Table (Joined) Inheritance, and Concrete Table Inheritance. | |
| 1 Strategies Considered | |
| Single Table Inheritance | |
| All subtypes are merged into one table with nullable columns for subtype-specific attributes. This was rejected because it would require storing NULL values for every column irrelevant to a given sport. With three sports and six to eight unique columns each, the resulting table would contain a large number of NULL entries per row, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Ciclul hamiltonian se poate determina folosind spatiul permutarilor filtrate de matricea de adiacenta a grafului. | |
| Input: | |
| numar de noduri si nodul de start | |
| 5 1 | |
| 0 1 0 0 1 | |
| 1 0 1 1 0 | |
| 0 1 0 1 1 | |
| 0 0 1 0 1 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Un graf este reprezentare abstracta a conectivitatii folosind Nodes si Edges; | |
| - 1...N | |
| - Nodurile si Muchiile sau arcele au informatii | |
| - grafurile : orientate si neorientate | |
| - edges conecteaza m perechi de noduri | |
| Graf = orice multime finita V (Vertices), prevazuta cu o relatie binara interna E |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #include <iostream> | |
| class DoublyLinkedList { | |
| struct Node { | |
| int data; | |
| struct Node *next; | |
| struct Node *prev; | |
| Node(int d): data(d), next(nullptr), prev(nullptr){} | |
| }; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| I'm a highly skilled Front End / Back End Developer coupled with a keen enthusiasm for Design Patterns, learning and using new technologies. I have a passion for breaking down complex technical concepts and presenting them in an understandable format to various audiences. My interests lie at the intersection of algorithm design techniques and optimization, where I am passionate about developing efficient solutions to complex computational problems. I'm Interested in design and implementation of programming languages , categorical semantics, theory of computation ( Big O Notation, Computability), Distributed Processing, Data Mining, Advanced Topics in Machine Learning, Deep Learning, IaaS, PaaS, SaaS, functional programming, Natural Language Processing (parsing, mathematical developments and applications, pattern interpretation, tree-controlled grammars), statistics. | |
| I contributed to MooTools Plugins as part of the development of the MooTools Forge package repository https://mootools.net/forge/profile/thinkp |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import javax.swing.*; | |
| import java.awt.*; | |
| import java.awt.event.ActionEvent; | |
| import java.awt.event.ActionListener; | |
| public class Main extends JFrame implements ActionListener { | |
| int choice = 0, choice1 = 0, choice2 = 0; | |
| JFrame f1, f2; | |
| JPanel p1, p2, p3; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import java.util.*; | |
| public class Graf { | |
| private final int[][] mat; | |
| public final boolean[] vizitat; | |
| private final int n; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Grafuri | |
| ------- | |
| Graf <=> orice multime finita V, prevazuta cu o relatie binara interna E | |
| G = (V,E) | |
| V = numarul de noduri | |
| E = numarul de muchii |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import java.io.*; | |
| public class editDistance { | |
| static void main(String[] args) { | |
| BufferedReader br = new BufferedReader(new InputStreamReader(System.in)) ; | |
| BufferedReader s = br.readLine(); | |
| BufferedReader d = br.readLine(); |