This is the anthletics events database consisting of 8 tables and their ERD. The PostgreSQL pgAdmin was used to create tables, insert data into tables, and process the data. Visual Paradigm was used to create the ERD. In summary, ERD is planning and description of the database where Customer
can request an EventRequest
, the EvenPlan
for which is managed by an Employee
(who can manage zero or multiple EventPlan
(s)). Each EventPlan
has an EventPlanLine
or time line (weak entity: identifying relationship). Zero or one resource are provided for each EventPlanLine
. Each EventPlanLine
has a Location
, which is in a Facility
and Facility
number is referenced in the EventRequest
.