Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A database has been requested to keep all of the data required to support the organization of the Paris 2 0 2 4 Paralympic Games.
A database has been requested to keep all of the data required to support the organization of the Paris
Paralympic Games.
The database should keep data for:
The sports, in number, included in the organization.
The National Paralympic Committees, committees, who have at least one athlete who has
qualified for the Paralympics.
The athletes who will compete in the Paralympics; a total of 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 of the total mark for the course.
It should be completed on an individual basis or in small groups of persons.
The project should be implemented using SQL commands that could be issued from Microsoft
Access, ORACLE Live SQL ORACLE Database 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 handin date is as follows:
The Case Description. In 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 ie 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
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 ER diagram to include all entities and attributes and the maximum and
minimum cardinality for each pair of related entities.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started