/EventsDatabase

PostgreSQL Database

Primary LanguageSQL

Athletic Events Scheduling Database and Its Entity Relationship Diagram (ERD)

Introduction

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.

Events Entity Relationship Diagram via Visual Paradigm

Miscellaneous: ERDs for Other Databases

Expense Reports Entity Relationship Diagram via Visual Paradigm

Home Purchase Entity Relationship Diagram via Visual Paradigm

Order Placement Relationship Diagram via Visual Paradigm

Vehicle Purchase Relationship Diagram via Visual Paradigm