Create codes for a relational data base and sql for populating the table in oracle and sql codes for quesries and debug the codes

Create a visual for the ER Diagram with the crow foot notations Use the following to create business rules and Entity Relationship Model to create an ER Diagram showing the relationships using the crow foot notation "Step $1$: Create Business Rules

Business Rules:

Each athlete must have a unique AthleteID.

An athlete can belong to one or more functions.

Each athlete is assigned accommodation and transport logistics$.$

Each function is unique and has a specific role and description.

Each event is uniquely identified and has details like name, date, and location.

Logistics schedules must link athletes, functions, and events.

Accommodation and transport details must be captured for each athlete.

Step $2$: Create an Entity$-$Relationship Model $($ERM$)$

Initial ERM with Supertype$-$Subtype Relationships:

Entities:

Athlete $($Supertype$)$

Attributes: AthleteID $($PK$),$ Name, Nationality, Sport, Gender, DateOfBirth

Subtypes: Swimmer, Runner, Gymnast, etc.

Event

Attributes: EventID $($PK$),$ EventName, EventDate, EventLocation

Function

Attributes: FunctionID $($PK$),$ FunctionName, FunctionDescription

Role

Attributes: RoleID $($PK$),$ RoleName, RoleDescription

LogisticsSchedule $($Header$-$Detail$)$

Attributes: ScheduleID $($PK$),$ AthleteID $($FK$),$ EventID $($FK$),$ FunctionID $($FK$),$ StartTime, EndTime, Location

Accommodation

Attributes: AccommodationID $($PK$),$ Name, Address, Capacity

Transport

Attributes: TransportID $($PK$),$ TransportType, Capacity, ScheduleDetails

AthleteAccommodation

Attributes: AthleteID $($PK$,$ FK$),$ AccommodationID $($PK$,$ FK$),$ CheckInDate, CheckOutDate

AthleteTransport

Attributes: AthleteID $($PK$,$ FK$),$ TransportID $($PK$,$ FK$),$ DepartureTime, ArrivalTime" This is the iniatial ER Diagram $+-------------------+$

$|$ Athlete $|$

$|-------------------|$

$|$ AthleteID $($PK$)|$

$|$ Name $|$

$|$ Nationality $|$

$|$ Sport $|$

$|$ Gender $|$

$|$ DateOfBirth $|$

$+--------+----------+$

$|$

$+--------|---------+$

$|||$

$+----$v$----+|+-----$v$-----+$

$|$ Swimmer $|||$ Runner $|$

$|---------|||------------|$

$|$ AthleteID $|||$ AthleteID $|$

$|$ Specialization $||$ Specialization $|$

$+----------+|+-------------+$

$|$

$+-----$v$-----+$

$|$ Gymnast $|$

$|------------|$

$|$ AthleteID $|$

$|$ Specialization $|$

$+-------------+$

$+------------------+$

$|$ LogisticsSchedule $|$

$|------------------|$

$|$ ScheduleID $($PK$)|$

$|$ AthleteID $($FK$)|$

$|$ FunctionID $($FK$)|$

$|$ EventID $|$

$|$ StartTime $|$

$|$ EndTime $|$

$|$ Location $|$

$+--------+---------+$

$+------------------+$

$|$ Accommodation $|$

$|------------------|$

$|$ AccommodationID $($PK$)|$

$|$ Name $|$

$|$ Address $|$

$|$ Capacity $|$

$+------------------+$ and this is the final $+-------------------+$

$|$ Athlete $|$

$|-------------------|$

$|$ AthleteID $($PK$)|$

$|$ Name $|$

$|$ Nationality $|$

$|$ Sport $|$

$|$ Gender $|$

$|$ DateOfBirth $|$

$|$ Specialization $|$

$|$ AccommodationID $($FK$)|$

$|$ CheckInDate $|$

$|$ CheckOutDate $|$

$+-------------------+$

$+------------------+$

$|$ LogisticsSchedule $|$

$|------------------|$

$|$ ScheduleID $($PK$)|$

$|$ AthleteID $($FK$)|$

$|$ FunctionID $($FK$)|$

$|$ EventID $|$

$|$ EventName $|$

$|$ EventDate $|$

$|$ EventLocation $|$

$|$ StartTime $|$

$|$ EndTime $|$

$|$ Location $|$

$+--------+---------+$

$+------------------+$

$|$ Accommodation $|$

$|------------------|$

$|$ AccommodationID $($PK$)|$

$|$ Name $|$

$|$ Address $|$

$|$ Capacity $|$

$+------------------+$