Questions tagged as 'modelagem'

Tagged questions
3
answers

Database modeling, when it is possible to denormalize

I am modeling a database (MSSQL) and a question has arisen. In every customer business rule data is viewed vertically ex: Product, Original Price, Competitor Price01, Competitor Price02, Competitor Price03, Competitor Price04,...
asked by 11.01.2017 / 12:05
3
answers

How to relate tables in MySQL to more than one entity?

How can I relate a table (entity) to more than one entity in the MySQL database? following the following example ... I have the tables: fornecedores , clientes and telefones . fornecedores , may have more than one...
asked by 26.11.2015 / 02:11
1
answer

Modeling comments

I'm creating a comment structure similar to the # / p> NOTE: I'm calling in question and answer comments since it's basically this way that the Free Market model works. In red questions and green answers. There is only one le...
asked by 22.09.2015 / 14:59
1
answer

DER for student, subject and course

A student can only take one course. A course has multiple disciplines. The student can take various course subjects. My only question is how would this look in DER? Would it really be that way? Since the student only has one co...
asked by 09.01.2015 / 20:51
2
answers

How do you model a role in object orientation?

Some things are not very clear to me these days. How do you normally model a role in object orientation? It's through a composition, right? For example, to model that a% of performs the role of a Pessoa or Cliente , it is mo...
asked by 01.09.2018 / 15:40
2
answers

Using struct in C #

I have to record customer information. And I used struct to do this. Is it worth doing this? Is it good practice or not?     
asked by 02.06.2018 / 05:06
1
answer

Join or separate repeated columns in different tables

I created a tbl_users table. But I have Profissionais and Empresas that many columns are the same. Would it be interesting to use in the same table, or is it better to separate?     
asked by 18.05.2018 / 02:44
2
answers

Is there a design pattern that can help with this problem?

I have a problem that seems to me to be fairly common. The problem, in this case, is this: the user wants to register in the system the services available for sale together with the values. When you sell a service, you want the service to become...
asked by 19.04.2017 / 16:37
1
answer

Modeling Categories and sub-categories

I am modeling an e-commerce related database and am having a question in modeling product category and subcategory tables. At first I created two tables one of Categoria and another of Subcategoria . However, I found a article w...
asked by 20.08.2016 / 18:14
1
answer

Database for Poll

I'm doing a questionnaire system and I'm having trouble modeling the database. I need my system to be "smart" to the point of asking different questions according to the answers. For example, my first question will always be: Are you one?...
asked by 13.01.2016 / 12:53