Most voted "modeling" questions
Modeling means creating a model that explains the working and behavior characteristics of a software from which it will be created, facilitating its understanding and its design, through the main features that will avoid programming errors, design and operation.
Learn more…321 questions
Sort by count of
-
2
votes0
answers672
viewsDoubt PF and PJ database modeling
I have a system that has a table called client, but this client can be Individual or Legal Person, in this case not to create a table for each of the client type PF and PJ, even because I have…
modelingasked 7 years, 2 months ago Marcelo José Lustosa Rodrigues 41 -
2
votes1
answer439
viewsStore vector in Sqlite
I am creating an application in C# that must have a database. At first I’m thinking of using Sqlite for simplicity. But for each data entered in my bank must have : Identifying (int, char, bool)...…
-
2
votes1
answer392
viewsHow to model Product/Stock?
I started a modeling for Products thinking of the same as: Purchased for Resell Produced for Sale Perishable or not So far so good, but when I started thinking about stock control based on this…
-
2
votes2
answers56
viewsField of type time or decimal, how to solve?
I have in the system that I am developing a field called flow, which can be filled either with a decimal value like 0.5 and 2.4 or with a value of time, like 15 min and 5 h. What is the best…
-
2
votes1
answer51
viewsJoin or separate repeated columns in different tables
I created a table tbl_users. But I have Profissionais and Empresas many columns are the same. It would be interesting to use in the same table, or it is better to separate?…
-
2
votes2
answers254
viewsDifference between relational table and online record
I have a structure of companies and categories organized in 3 tables: empresa -> Registration of all registered companies. categoria -> Registration of all registered categories.…
-
2
votes2
answers5168
viewsRelational database model with SKU
I am creating a system for selling products and I need that these products can have different prices according to their size or color, for this I am using SKU, I am creating the relational model of…
-
2
votes3
answers1106
viewsClasses with associations in UML
I’m from the time of structured programming and now I’m returning and trying to fit in with OOP. I made a diagram below. I’m on the right track? I created this class Empresa thinking of not having…
-
2
votes2
answers85
viewsModeling of Models 1 to n
I’m modeling a system for academies. I created 2 models, Modality public class Modalidade { [Key] public int ModalidadeId { get; set; } [MaxLength(200)] public string Nome { get; set; }…
-
2
votes2
answers129
viewsBest way for database normalization
What would be the best way forward regarding data normalization? The system will have basically three types of "people": Agency Collaborator Client These entities have some common properties, for…
-
2
votes1
answer51
viewsHow to obey the Open/Closed principle in this situation?
I have a situation where the solution that I have clearly identified violates the Open/Closed principle and I would like to find a better solution that does not violate that principle. Obviously my…
.net oop modeling software-architecture software-engineeringasked 7 years, 10 months ago SomeDeveloper 18,074 -
2
votes2
answers192
viewsDoubt visibility of attributes in class diagram
We recently had a discussion in class on the question of the visibility of attributes in the class diagram. Some have stated that in the diagram (as well as in the code) all attributes must be…
-
2
votes1
answer91
viewsWhat are the terms Weak Entity, Weak Relationship and One Optional/Mandatory?
I’m using an online tool yEd Live to model a MER diagram. However, there are some elements that use terms in which leave me with some doubts. Those terms are: Weakentity (rectangle) Weakrelationship…
-
2
votes2
answers108
viewsIs there a Pattern design that can help with this problem?
I have a problem that seems fairly common to me. The problem, in the specific case, is the following: the user wants to register in the system the services available for sale along with the values.…
oop modeling software-architecture software-engineering dddasked 7 years, 9 months ago SomeDeveloper 18,074 -
2
votes0
answers401
viewsGood practices in data modeling
I am an intern and I am developing a small application to help the staff of the quality and development to register the use cases and etc, the application is very simple, it is made in Angularjs…
-
2
votes0
answers4066
viewsSequence Diagram with MVC facing the web!
Good afternoon guys, I’m having doubts about some sequence diagrams I’m developing for a college job. In theory I already know what a sequence diagram is, what it does and what its purpose, but the…
-
2
votes1
answer168
viewsWhat is a static table in SQL Server?
What is a static table in SQL Server? I can’t understand this concept by internet searches.
-
2
votes0
answers33
viewsi wanted to make a query that returns me the following data in mongodb
COLECTION GAMES { id : 10, casa : "Sport", visitante : "Chapecoense", horario : "2017-07-20 11:00:00" } GAMBLER COLLECTION { nome : "wedson", apostas : [ { idjogo : 10, opcao : 1, valores : 1 } ] }…
-
2
votes1
answer118
viewsRelational databases and relational object
What are the differences between relational databases and object-relational databases?
-
2
votes1
answer83
viewsModeling - Model
I’m having trouble creating my models. Let’s imagine that I have 4 different types of products (Here as A,B,C and D) public class Produto { public int ProdutoId { get; set; } public TipoProduto…
-
2
votes1
answer39
viewsOptimizing columns of Mysql tables that receive only two different values
I have a Mysql table with 30 columns, and 25 can receive only one of the following values: Not or Yes. Currently they are defined as char(3). In case I convert these char columns to tinyint,…
-
2
votes2
answers1707
viewsTable structure in user questions and answers template
I have a doubt in the structure of some tables and I hope you can clarify in detail below. Setting The system will generate a way to create forms and questions dynamics, in order to be answered by…
-
2
votes3
answers120
viewsProperty defined in constructor only returns zero value
I created a Web API in C# that returns me a list of products in JSON. However, the property PrecoVenda is always returned with the value zero and I noticed that this occurs because in the class…
-
2
votes2
answers207
viewsPHP - Trait or Extended Class
Good afternoon, you guys, I have a trait that format data from Models in a MVC system, the system works correctly, however came to me a doubt in relation to Pattern design and performance, in case,…
-
2
votes1
answer90
viewsCreate recycle bin table
I have the database tables to store the data, but I want to add one to save the data of deleted rows from the other tables, I thought of four ways to do this: Create a table lixeira that will save…
-
2
votes2
answers891
viewsDatabase modeling of a banknote system
I need to create a database for a banknote system, but I’m terrible with data modeling. I did the modeling but I don’t know if it’s correct. The fields are not yet definitive, I just want to know if…
-
2
votes1
answer83
viewsWhat would be the ideal unique natural key associated with a person?
I’m developing a system whose one of the tables represents people. Of course, the most accurate document to represent only one person is CPF. However, the system provides for the possibility that…
-
2
votes1
answer39
viewsDiagnostic analysis in mixed effects models via Plot Half-Normal chart
I am intending to perform the Plot half-normal chart for a mixed effects model that has been adjusted using the package lme4. To visualize the diagnostic analysis of this model, I intend to use…
-
2
votes1
answer36
viewsHeterocesarean mixed effects model via lmer function
I am adjusting a mixed effects model which due to observed heterocedasticity was necessary to include an effect to accommodate it. For this purpose, using the function lme package nlme this was easy…
-
1
votes1
answer97
viewsHow do you model 1x0 relations. 1 (optional one-to-one) in the Entity Framework Code First?
When an Entity CAN have one (and only one) instance of another Entity, but the second entity must have the first, as the Entities modeling is done?
-
1
votes1
answer185
viewsShould I create a table by category, or a single table?
I want to set up a classified site and I have a question: how can I create the categories in the comic book? Create an ad table for each category? Or create a table Categorias with them inside?…
-
1
votes1
answer150
viewsInterface to build relationships between tables
I am developing an application where basically the user will interface between Mysql tables. For example: table A (Products) table B (Photos) Table C (Price history). Basically in the application…
-
1
votes1
answer74
viewsData modeling for user-favorite tasks
I have an application where the user can create a task. The task in turn can be public or private. If it is public, other users may see it and favorite it. That is, many users may prefer the same…
modelingasked 10 years, 5 months ago noob-rails 127 -
1
votes3
answers906
viewsCan a primary key be used on a foreign key?
The following example may occur? | Id | nome | data | qnt | PK -> Id FK -> (Id, qnt) Or is there some kind of restriction?
-
1
votes1
answer238
viewsRelationship Tables
I have a table Endereco which serves as much to Funcionario how much for Supplier: 1 Funcionario possui 1 Endereco 1 Fornecedor possui 1 Endereco How I create this relationship without having…
-
1
votes1
answer100
viewsLogic for Directory System
I have a directory system in the bank ex table directory: id parentDirID Parent dir means q is a subdirectory. What would the function of "copy" directories look like in the system? move directories…
-
1
votes2
answers794
views -
1
votes1
answer691
viewsBetter cardinality for a table with many relationships
Well, I have a table of cash flow, this table can be related to a process, request, bill to receive, bill to pay... among several other tables that relate and that can result in a launch in the box,…
-
1
votes1
answer108
viewsHow to model a comment system
I am developing an application in Rails. I would like to know how to model the comments part. There is a table for the calls( Helpdesk system ), and the same relates to the history table, which are…
-
1
votes1
answer58
viewsWhat software do I use to model images of this type?
I am looking for a software for modeling 3D structure/forms, of simple preference, one that does not require deep knowledge in computer graphics... but at the advanced user level. Image example:…
-
1
votes1
answer2143
viewsDatabase modeling helps you!
I need to make a library system for book loans, in which I drew up this database diagram. The professor said that this diagram is inconsistent. What needs to be done, it’s just these tables that I’m…
-
1
votes1
answer2277
viewsCreating dynamic ng-model with angular
I need to create a model name dynamically, but when creating obj the angular does not accept that I try to create the obj name dynamically. Has anyone ever done this or knows how to proceed? The…
-
1
votes0
answers178
viewsHow to get modeling result
I have a modeling and I’m trying to get information about it, but I’m not getting it, I need to show the user tasks separated by Tipo de Atividade, the user is in the table WFPessoaTarefa field…
-
1
votes0
answers70
viewsExport XPDL file to Camunda Modeler
Does anyone know if it is possible to export a file in XPDL format from a diagram made in Camunda Modeler?
-
1
votes2
answers1520
viewsHow to model with inheritance a structure of People?
Hi, I’m having a hard time doing my Pessoa modeling. Theoretically it seems a very simple thing, but I can’t find a way to follow, say, "good programming practices". My problem is this: In my system…
-
1
votes1
answer389
viewsMulti-action and content notification system
I am trying to understand how best to make a notification scheme for multiple actions and nodes. Basically one should notify someone whenever an action of the type message or enjoy is performed.…
-
1
votes1
answer2399
viewsMER - Entity and relationship model
I wonder if my MER is correct and if it is possible to make a relationship N:N between animals and schedules. Specifications I created for the system: Computerize the scheduling of a bath and Osa,…
-
1
votes2
answers595
viewsDatabase in Android
Hello! A few days ago, in a question I asked here at Stackoverflow, I said I was starting to develop for the Android platform. This week has been very productive and I already have some ideas to…
-
1
votes1
answer168
viewsHow to know the contents of a foreign key for filling another table?
I will give as an example 2 tables of a database: User and Address. where the user has the idEndereco attribute as a foreign key to the address table. The ids are with AUTO INCREMENT, yet, how do I…
-
1
votes1
answer90
viewsHow to register each new relationship between two entities
Considering a scenario where a member has a account, personal profile, academic profile and may vary between status (between pre-defined status: teacher, student and collaborator) within the system.…