SQL Database - Taking one columns max value for another table column


5 weeks ago


13 time


I design my database and have 3 tables:

1) Authors table has ID, Name, Surname, and Paper_ID. Name and Surname combination is unique.

2) Topics table has TopicName, SOTAResult, and Paper_ID. TopicName, SOTAResult are unique.

3) Papers table has Title(unique), Result, Abstract.

I design it like that way because a paper has multiple authors and multiple topics but 1 result. My question is, I want to assign max value from results column in Papers table to SOTAResult column in Topics table. I also wonder did I build correctly this database according to my necessity or should I change something specifically.

0 answers