I am building a database with the following tables:
Aluno: id_aluno, aluno_login, aluno_senha, aluno_nome, aluno_sobrenome, aluno_cidade
Aluno_Categoria: id_categoria_curso, id_categoria, id_aluno
Categoria (ou curso): id_categoria, categoria_nome, categoria_curso
Does curso have categoria or categoria have curso ? If I reverse the order has something to do or do we fall into that question "does not the order of the factors change the product?"
Why not both? That's why the database is relational, you make it as you want. So it is superior to other models in most cases. Relationship does not involve ownership but rather link.
I can not tell if the model is right because it always depends on well-done requirements collection. And the question is not there too well written, but the relationship is this ..
Hello, I understand that you should evaluate: 1- Can I have several course categories? Eg: 1.a) Database-: related courses: DB administration, BD programming, BD NoSQL, etc. 1.b) Software Engineering Category: related courses: Requirements Examination and Analysis, Dev Standards, etc.
2 - Are the categories in the course not better interpreted as modules? Eg: 2.a) Course Database: related modules: Installing the DBMS and configuring the environment, Creating the DB, Administering the DB, etc. 2.b) Programming Course OO: related modules: Concepts, Prog. Structured, Principles of OO, The Pillars of OO, etc.
In my view the relationship order in this case influences the final result, however you need to evaluate the need for your modeling.