How yanfrog/database_implementation works
Project type and purpose
• This is a data‐centric project built around a local SQLite database (“Group_HW.db”) that holds financial/trading data.
• Its primary purpose is to store and manage user, account, stock, trade and dividend records. The CSV files under version control are the original data sources or exports of each table.
File structure
• Top-level files:
• USER.csv, ACCOUNT.csv, STOCK.csv, TRADE.csv, DIVIDENT.csv: raw data dumps or seed files for each table.
• Group_HW.db: the SQLite database file.
• README.md: describes the schema and relationships.
• No separate code directories or scripts; the “ETL” or import step is done via DB Browser or similar tooling.
README for additional insights
• Defines five relational tables and their columns.
• Lists primary key and foreign-key relationships:
• USER.PID ← ACCOUNT.Cd_account
• ACCOUNT.AccountID ← TRADE.AccountID
• STOCK.StockID ← TRADE.StockID
• STOCK.StockID ← DIVIDENT.StockID