Hello,
Anyone can help me to solve this problem?
I need to refer to the lookup table for each keyword inserted by user
to compare query and record in database and find the similarity.
this similarity is then times by the weight chose by user.
How can we refer to this lookup table ?
(separate lookup table for each field)
I have several tables.
1. the main table namely lesson contains several fields that used for searching.
2. weight is assigned by users for each keyword for searching purpose.
3. users' keyword will be compared with the record in the database. each of them has their own similarity.(like lookup table)
table1- lesson
field: form - subject - skills - time - ability
table 2.
similarity table for form
fields: query- case -similarity
e.g : form1 form1 1
form1 form2 0.67
table 3.
similarity table for subject
fields: query- case - similarity
e.g : science science 1
science math 0.3
table 4- similarity table for skills
table 5- similarity table for time
table 6- similarity table for ability
many thanks for the help
