Many to many relationship optimization
I'm working on a system where I hava a table for storing student languages competencies to manage this we created the following architecture :
the table STD_LANGUAGE_COMPETENCIES is representing the associative entity . of a many to many relationship between the STD_LANGUAGE ( french , english, arabic ...) table and STD_LANGUAGE_SKILL ( reading , speaking , writing , teaching) the problem is that STD_LANGUAGE and STD_LANGUAGE_SKILL are not updated by a normal user of the system( student ) they are added by system administrator , and when I try to fetch language competencies for a student the architecture oblige me to do a join on two table in order to get the name of the language and the name of the skill . is there anyway to optimize this schema .
If the language skills are for example: "reading", "writing", "conversation", ecc., without sovrapposition of names, without limit of time for skills, and management client modules, you can put the description directely in STD_LANGUAGE_COMPETENCE table, and remove the foreign key cstraints, while you keep the skills table for combo items to assign or search(by text).
In this way you can avoid a join..
- Will modifying the primary key type using ALTER in MySQL reset the auto-increment value to 0?
- Auto-increment is not resetting in MySQL
- Php update database if checkbox is not checked
- Retrieve 10 records from MySQL?
- how to use str_to_date (MySQL) to parse two-digit year correctly
- sum column value(s) if previous values has same value with current value from the same table in mysql
- JDBC connection without database definition
- Checking connection to MySQL (Java)
- WARN: Establishing SSL connection without server's identity verification is not recommended
- how to solve django.db.utils.NotSupportedError in django
- How to make an Inner Join in django?
- Can I order by a conditional combination of fields in MySQL?
- Select from 2 tables in the last 30 days, return 0 if null/not exist
- Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (38)
- Access denied for user 'root@localhost' (using password:NO)
- Watching a table for change in MySQL?
- table is specified twice both as a target for INSERT and as separate source of data
- Python Mysql, "commands out of sync; you can't run this command now"
- Does Laravel's "soft_delete" need index on MySQL?
- How do I access a field from the main query inside a sub query in mySQL?
- Not getting unpaid or partially paid records some can help me?
- Warning: The post-install step did not complete successfully when trying to install mysql using brew in Mac OS High Sierra
- MySQL Entity Attribute Value table structure proposal
- CodeIgniter SELECT query on table with JOIN and WHERE IN a subquery
- is there a MYSQL tables schema for storing raw material, intermediate and final products?
- MySQL: Total GROUP BY WITH ROLLUP curiosity
- Problem with pip install mariadb - mariadb_config not found
- nodejs mysql memory leak on large volume of high frequency queries
- `MODIFY COLUMN` vs `CHANGE COLUMN`
- Displaying BLOB image from Mysql database into dynamic div in html