tpham16 / TKH-Social-Media-Engagement-Analytics

A capstone project that analyzes The Knowledge House's Social Media Engagement
4 stars 2 forks source link

Set up fb database #41

Closed F-said closed 1 year ago

F-said commented 1 year ago

(this is a want, not a need. Nice to have, but shouldn't be essential for project)

Related to PR https://github.com/tpham16/TKH-Social-Media-Engagement-Analytics/pull/32

After PR merged. We should implement a fb relation in the market schema and push relevant data. DB must be normalized.

Definition of done: Market schema is not dropped; fb schema implemented.

We could even simply run this script in pgAdmin, and just integrate this SQL CREATE TABLE query in the schema without necessarily running it via the python script.