Mysql table structure design for economic data
Dear all Mysql experts I am very new for Mysql, please providing me some guides here. I have data as shown in picture above, and I am trying to design table structure of Mysql to store those data and the data will be added over the years, which i dont want to record same indicator multiple times. at the moment i was thinking about split the data into 3 tables: indicator table to hole indicator name, data value table to hold data value and year and the geography table to hold provinces but i am not quite sure if that approach is right please giving me some shade of light. Thank you very much.
Because its a simple question that deserves a simple answer, here is a suggestion. As per the comments, the sample data you have given is ambiguous, but with assumptions this is it.
From your data, it looks like Indicator, Category and Source are all attributes of the same entity. It also looks like there are an arbitrary number of provinces. If so then you are likely to have three tables
Indicator(IndicatorID,IndicatorText,Category,Source)
Province(ProvinceID,ProvinceName)
YearValue(IndicatorID,ProvinceID,Year,Value)
You would probably not store the national value, just add up the provinces.
- Altering table to add column before specific column
- What is the difference between latin1_general_ci and utf8_bin in MySQL
- Splitting huge sql dump file in smallest chunks possible
- count with load Laravel
- MySQL: How to convert seconds to mm:ss format?
- Get mySQL MONTH() to use leading zeros?
- Enable password and unix_socket authentication for MariaDB root user?
- sequelize error: missing index for constraint
- How can I access ddev's database with external database browsers or similar tools?
- Laravel: String data, right truncated: 1406 Data too long for column
- MySQL database connection error: ManagedConnectionFactory is null
- Sequelize select * where attribute is NOT x
- Error: secretOrPrivateKey must have a value
- Retrieve last inserted id with Mysql
- Event Color based on Resource / Room Color - Fullcalendar.js PHP MySQL
- MySQL/Amazon RDS error: "you do not have SUPER privileges..."
- How to select Users who have not received notifications using SQL?
- How to do this in Laravel, subquery where in
- php scrape to write to mysql database error
- php mysql connect and create table with no error but no data
- What is the output of mysqli_query?
- Delete, Truncate or Drop to clean out a table in MySQL
- Modify string from one column before inserting into another
- Innacurate query with LIKE statement
- How to display data using where condition in MySQL
- Data from SQL table will not be passed over to pandas dataframe
- How to find entries in a Column - where an adjacent column switches value, and then reverts back to the original value?
- MySQL workbench table data import wizard extremely slow
- Brand name whose amount is increasing every year
- Where is MySQL's my.ini located on Windows?