I design my database and have 3 tables:
Authors table has ID, Name, Surname, and Paper_ID.
Name and Surname combination is unique.
Topics table has TopicName, SOTAResult, and Paper_ID.
TopicName, SOTAResult are unique.
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.