A database has been requested to keep all of the data required to support the organization of the Paris

$2024$ Paralympic Games.

The database should keep data for:

$$ The sports, $28$ in number, included in the organization.

$$ The National Paralympic Committees, $91$ committees, who have at least one athlete who has

qualified for the $2024$ Paralympics.

$$ The athletes who will compete in the $2024$ Paralympics; a total of $4,400$ of the world's most

outstanding Paralympic athletes.

$$ The organization of the games.

$$ The performance of the athletes.

$$ The metals awarded to the athletes and the countries.

$$ World, Paralympic and personal records of the athletes.

Once the database is implemented, you should add realistic sample data and implement, using SQL$,$

realistic sample queries for potential users.

Enjoy!!

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$$ This project assignment is worth $20\%$ of the total mark for the course.

$$ It should be completed on an individual basis or in small groups of $2$ persons.

$$ The project should be implemented using SQL commands that could be issued from Microsoft

Access, ORACLE Live SQL$,$ ORACLE Database $11$g Express Edition, MySQL$,$ Microsoft SQL

Server, or some other SQL environment.

Deliverables:

The list of deliverables to be handed in on or by the hand$-$in date is as follows:

The Case Description. In $2-3$ pages, produce a description of the case under study, along with

some expected realistic user requests.

The data model $($Entity Relationship Model plus supporting narrative, including any assumptions

made$).$ For the design of the ERM you should use an appropriate CASE tool.

A Relational Schema $($database design$),$ which comprises listings of table definitions clearly

identifying primary keys and foreign keys, a description of the data attributes, and minimum

cardinality actions$$ tables for all of the relationships.

The code and results of data definition and manipulation $($i$.$e$.,$ table creation, data insertion and

data extraction SQL statements$)$ including the appropriate test data.

A more detailed description of the above deliverables is following.

Requirements for the case study $($deliverables in detail$)$

$1.$ Develop a data model and database design to support the case requirements. You may be

required to make some assumptions. Please state and explain these in your documentation.

Your deliverables should include:

I. A data model as an E$-$R diagram to include all entities and attributes and the maximum and

minimum cardinality for each pair of related entities.