MySQL Forums
Forum List  »  Newbie

Re: Some topics appearing but others, not???
Posted by: gustavo woltmann
Date: November 17, 2021 01:18AM

o you see what I mean? Is it acceptable to use the first (top) method]? Or is that bad practice and the second method [Teacher_Proficiencies_Two] is always "usually" the best/proper way?

Another way, (according to my research) would be to name the columns themselves after the different proficiencies and use logic (0 or 1) along with the 'TINYINT' datatype (due to MySQL not having the boolean operator):

I.E:
Teacher_ID Tennis Badmington Football Dancing
50051 1 1 1 1
50052 0 0 1 0

But then a DB admin would be required to alter the table structure every time the School wanted to add a new activity -- at least in the second (middle) option, you could just add loads of columns (Proficiency1, Proficiency2, Proficiency3) etc and it would more than likely at least be enough until a next scheduled annual maintenance etc.


I hope you see what I mean? What would you recommend?

Thank you kindly,

Nick Peyton

Options: ReplyQuote


Subject
Written By
Posted
Re: Some topics appearing but others, not???
November 17, 2021 01:18AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.