ERD

[ajhaller]

Objective

As a data scientist, I want to create an ERD diagram to visualize our raw data schema, allowing us to understand how to use our data and for new repo viewers to understand our data better.

Acceptance Criteria

• Add fault, SCADA, and status raw data table
• Add merged (fault and SCADA) data table
• Add ERCOT market data table?

[JavierACM]

I added a new "Calendar" table and committed the Status table as per the last team meeting since we won't use it for our model. Please let me know if you want to see something else or if I need to change anything before committing to our repo. @ntuziyihuang @rr-85 @gibby-ci

[gibby-ci]

@JavierACM try to put in a user story format. using INVEST method. why are you investing your time into this documentation. how does it help your project?

the output looks good - but what is the acceptance criteria? what are you expecting this output to deliver?

[JavierACM]

@gibby-ci Thank you! I just created a user story on this ticket.

[JavierACM]

To-Do:

• Include the status raw data table, even though we won't be using it for our model
• Test if fault and SCADA tables have a one-to-one join relationship
  • If YES, delete the Calendar table because we'll be adding Date and Month columns to the merged table
  • If NO, keep the Calendar table to reduce redundancy