Questions tagged as 'modelagem'

Tagged questions
2
answers

Database modeling

I created the following model: Would you like to know what can be improved? taking into consideration good practices for database? Explanation: In% of%, a person will create a login, which can be of type TBLogin or Pes...
asked by 25.09.2015 / 17:41
2
answers

How to model plots when you do not know how many?

Typically, when it comes to installment payments, you get the idea of 12 installments. So you soon create a table with 12 fields, one for each parcel. But I am faced with the situation where the customer is a consumer of continuous service...
asked by 18.09.2015 / 16:55
1
answer

Do all data persist as string is a problem?

Is there a problem in storing all the information in an application as a string in the database? Regardless of the application, the SGDB, the programming language used, etc. I ask more about data handling issues, in most languages I use man...
asked by 26.12.2014 / 23:14
1
answer

Is it a good practice to have the same name with the column name of the bank?

Let's say I have a input text de name="txtnome" , is it a good practice to have a column of the same name as this input in my table? Being that I'm using PDO for CRUD $st =$this->db->prepare("UPDATE $tabela SET yxtnome=:t...
asked by 11.05.2016 / 04:33
1
answer

How to model in a correct way

I have the following table structure: First: Is this modeling right? Second: is there any way to improve? Reduce the number of tables? The system will work as follows: Each Candidate has a Professional Purpose. And each Profess...
asked by 26.06.2016 / 22:20
1
answer

How to handle requirements that "mix" domain and interface?

Whenever I develop some software I try to leave the domain model without being influenced by issues relating to other layers of the application such as general technologies and interface issues. In fact, the domain model contains a code templ...
asked by 08.07.2016 / 04:35
1
answer

How to model a set of 1 to 4 default values

I'm modeling a MySQL database where key entities are documents. Among several other fields, these documents relate to one or more phases of a given project. There are 4 basic values (let's call them A, B, C and D), and the phase property...
asked by 19.11.2015 / 20:03
3
answers

How to represent "is-one" relationships in the logical model?

I'm creating a data model where a client entity is also a person, of the legal or physical type. However, in the state it is in, it will not be possible to implement it physically, since I can not create the logical model that correctly describe...
asked by 20.08.2015 / 16:28
2
answers

Displaying massive amount of data

From the moment we work with a very large amount of data (eg more than 3 million records), and we need to display this data on the screen while the user is using the page, always having the best performance possible. / p> Is partitioning thi...
asked by 26.09.2014 / 15:06
1
answer

Why normalized schemes up to 3FN do not have N: N?

Explanation of concept I understand that by definition a database schema is in 3FN , when it is in 1FN, 2FN and does not have transitive dependency. Transitive dependency is when a NOT attribute depends on a / strong> key. Examp...
asked by 02.11.2017 / 15:45