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
-
0
votes1
answer1470
viewsHow is a specialization implemented in a bank?
In my ER model and diagram I created a specialization for an entity called clients, where it relates to the physical and legal entities derived from this specialization. I simply create the…
-
0
votes1
answer1610
viewsDatabase for E-commerce site
Good morning before, some doubts arose when I was developing the database of my online sales site (only for lesson context...). It is the following, I have the products table, then I have the cart,…
-
0
votes1
answer126
viewsRelationship in database table
I have a registration form where contains personal information, professionals, additional, financial and production, my doubt, as it gives many columns, I believe that more than 50 fields. Is it…
-
0
votes0
answers490
viewsPhysical and Juridical Person
I have a field which can receive physical or juridical person, as you model it ? through interface, composition or heritage ? I have the following class structure: Contacts (PF only) -- belongs to a…
-
0
votes1
answer497
viewsDatabase structure for poll system
I have a project to develop an online polling system. I am concerned about how I will get the answers to the questions to show in a graph. Each graph is each question to be analyzed. Let’s see, if I…
-
0
votes1
answer79
viewsData modeling with people of different profiles
I need to create a system where people can play different roles. (e.g. They can be teachers, students and server). The main information is: Teacher profile: name, address, email, area of activity,…
-
0
votes1
answer1021
viewsINSERT and UPDATE in n:m relationship in Mysql
I need to create a n:m relationship in mysql, follow my example: I have a table called empresas and another representantes. An enterprise may have more than one representative, and a representative…
-
0
votes1
answer163
viewsDoubt in modeling Mongodb
From what I studied, when modeling an application using Mongodb one should always think about the application. Thinking about a system that has Promotion and Gender, where a promotion has a Gender,…
-
0
votes1
answer77
viewsUse Case in Tool Case
how we should create the use case diagrams, make a diagram encompassing all use cases or make several diagrams for each specific scenario. Ex.: I have within the system several lines of work, part…
-
0
votes1
answer6479
viewsGenerate MER from a Database
I have a Database backup and for lack of documentation I need to generate his MER. I remember reading somewhere that there are programs that do this reverse engineering and generate the MER. Could…
-
0
votes1
answer129
viewsColumn type for support table
I have a client table and would like to create a support table to avoid creating many columns (address, phone, phone1, email, Email1, Email2, car plate, mother’s name, etc.). The support table…
-
0
votes0
answers129
viewsHow to Model Tables to Store Tag
I have an SQL Server database where I have a table of videos linked to various tag s. How is done here in the forum where each post is linked to various tags. Best practice for modeling the…
-
0
votes1
answer173
viewsDoes System Modeling Need Java?
I used structured data diagrams more than 15 years ago. In 2002 I did not use POO. I want to relearn modeling systems using POO. Do they indicate any material? I need to learn Java or just POO in…
-
0
votes1
answer851
viewsModeling for student attendance
I have doubts about the structure of the database for a frequency system. I thought of two structures and when doing a search I saw that both exist and are used in different systems. 1 - The first I…
-
0
votes1
answer277
viewsLaravel Defender Trying to get Property 'name' of non-object
Is returning the following error of my assignment: $user->attachRole(12); Observing: if I use this way parameterized the normal functional defender models $user->roles()->attach(12); What…
-
0
votes0
answers287
viewsModeling Banks Financial Institution
I am starting a personal project for my learning, an application simulating a financial institution system, first using the following products: current account, credit agreement (loans). I came…
-
0
votes1
answer102
viewsRelationship MORPH
I’m modifying a table database, in case it is to be made a relationship Morph of the fields that are according to the image. I’m wearing the Laravel 5.6 How do I make this relationship within…
-
0
votes1
answer64
viewsData Modeling - Weak Entity
Hello I’m studying about Data Modeling and I was left with doubt about the concept of Weak Entity. I have already understood what is Weak Entity, which is an entity that needs keys from other…
-
0
votes2
answers49
viewsDoes table order make a difference in modeling?
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…
-
0
votes1
answer50
viewsHow to plot/map spatial random effects (Spatial Random Effects) in R?
I am working with visceral leishmaniasis data in census tracts of a Brazilian municipality. I ran a Baysian space model (CAR conditional autoregressible model) BYM from the Carbayes package in the R…
-
0
votes2
answers256
viewsHow do I make the program display a message once on the last day of the month?
I am working on the development of a financial program in Windows Forms and a requirement appeared that I am not yet knowing how to do. The requirement is as follows:: On the last day of the month…
-
0
votes1
answer2833
viewsConditional class relationship diagram
I made a diagram and modeled the Partners class to involve customers, suppliers, service providers, etc., which will inherit attributes from the abstract classes Pessoa->Física or…
-
0
votes1
answer40
viewsNumeric data type with Access characters
I have a bank in Ae I have several fields that are essentially numerical. Only that the numbers can contain the sign of < or >. These fields can be used for calculations so I didn’t want to…
-
0
votes2
answers509
viewsHow to map multivariate attributes?
I am trying to map this conceptual model to the logical, but I have doubts about how to map the multivariate attribute "palavra_chave" that will allow the registration of as many keywords as the…
-
0
votes1
answer134
viewsSyntax problem when compiling modeling in Lingo
I’m trying to solve the modeling of a linear programming exercise in Lingo and every time I have the software compile the code I get the error code: 11. INVALID INPUT. SYNTAX ERROR HAS OCCURRED.…
-
0
votes2
answers89
viewsCalculate number of sales of a seller
I’m doing academic work on comics, in this case I’m developing a database for a food distributor. I am in doubt as to how I can count the amount of sales that a seller has made in order to calculate…
-
0
votes1
answer1961
viewshow to calculate the storage volume of a database
The thing is, I’m having concerns about a database being used in a project. The project consists of the development of a software to unite the respective data to two solar spectrum sensors, and then…
-
0
votes0
answers163
viewsHelp with a MER
Well someone could help me with my MER I’m wondering if I’m using the correct logic in relationships and cardinalities: a report may have one or more services 1 - n a request has one or more reports…
-
0
votes2
answers593
viewsHow to model the products table for an e-commerce?
I have a question about how to model the table Produto of a small e-commerce I’m doing. I have been seeing some e-commerces and came across the following situation: mm same product can have…
-
0
votes1
answer117
viewsUse composite key as PK or not?
I have two tables: 1- Contracted Service 2- Payment Contracted Service 1 service may have N payments. I modeled the Contracted Service Payment class as follows: CREATE TABLE…
-
0
votes1
answer49
viewsWhat is the best way to save multiple image links in a database?
List<String> _lista = new List<String>(); [HttpPost] [ValidateAntiForgeryToken] public ActionResult Create(Veiculo veiculo, HttpPostedFileBase[] file) { for (int i = 0; i <…
-
0
votes2
answers154
viewsInheritance persistence, one-to-one relationship and manual primary key
I’m developing a heritage web project to finish my degree. I am using Java (IDE: Spring Tool Suite), Spring, Hibernate and Mysql. I’m having a data modeling problem that I’m having trouble solving:…
-
0
votes1
answer359
viewsRecover sequential auto increment after deleting some column
I am using SQL server and the scenario is that I have a table with an auto increment id field, for example I have 3 field inserted, in case there are the ids 1, 2 and 3, if I delete the column with…
-
0
votes0
answers29
viewsDoubt - UML - Use Cases
Hello, I would like to express that the use cases "View Patients", "Schedule Visit" and "Send Messages" necessarily need to be logged in beforehand in order to be executed and performed. Anyway,…
-
0
votes1
answer55
viewsRelationships between classes in the OO
For example, if I have a class Hospedagem and a class NotaFiscal, a lodging has a invoice and a receipt has a lodging. I need to put the attributes inside the two classes, the attribute NotaFiscal…
-
0
votes1
answer36
viewsData Modeling
Good afternoon, you guys, I am studying Data Modeling and I was left with doubt regarding how the data should be specified, for example what determines in a code if I use a string or an integer for…
-
0
votes0
answers36
viewsDoubt about a GLMM
I’m running this model on R: modelogeral<-lmer(lognplanta~Clas_renda*sexo*idade*ocupacao*escolaridade*Clas_npessoas*(1|comunidade),data=bruno) The following message appears: Fixed-Effect model…
-
0
votes0
answers19
viewsWhat is the relationship between EER and objects?
The EER (Enhanced Entity-Relationship) model has some concepts such as class, subclass, generalization, specialization. What is the relationship between these EER concepts and object orientation?…
-
0
votes1
answer66
viewsProblems with the lme function with nested variables (any(notIntX <- ! apply(X, 2, const))
I’m trying to adjust a mixed effects model in which I have covariables that are nested (Varx5 | Varx6) and are considered fixed effects. However, I am trying to adjust the data and the following…
-
0
votes1
answer68
viewsIs it possible to say that the scheme is normalized in 3FN?
Explaining the Context In the internet found an example of a scheme described in this way: account(num-conta, descr-conta, launching(num-lanc, tipolanc, data-lanc, valor-lanc)). Notice that the way…
-
0
votes1
answer1060
viewsERROR CODE 1215 - You cannot add foreign key
Table 1: Table 2: Commando: ALTER TABLE extras ADD FOREIGN KEY (login) REFERENCES usuario(login); Answer: Error Code: 1215. Cannot add foreign key constraint Cannot find an index in the referenced…
-
0
votes1
answer87
viewsBank modeling with classes with n relationship for n
Galera Good morning. I’m modeling a company that owns several branches. Basically I have information, of size, of the organization chart of each size, and of positions in the branches. For example…
-
0
votes0
answers102
viewsData Modeling - Relationship Optional
I need to do a database modeling for the following scenario: One Task(which is a ticket, a service request) will always have a Address, which is where this task will be attended to. To Task may be…
-
0
votes0
answers226
viewsSave a JSON to the database or create an intermediate table?
Good night! I am in a small Dilemma, I am building an application to control events,in this application I have an event that can have several guests in the Front end I am thinking of using a…
-
0
votes3
answers4060
viewsData modeling for products
I made a diagram in the Workbench according to the instructions above, it is about the sales control in a grocery store. My database teacher said something about not being able to visualize the…
-
0
votes1
answer40
viewsDoubt in self-relational table modeling
I need to make a system where the business rule is this: One card must duel against another card The same duel between two equal cards can happen more than once Each letter should contain only two…
-
0
votes1
answer101
viewsDeseasonalize PIM data with R
I’ll start by saying that I’m almost illiterate in programming so have a little patience. I am trying to deseasolize the historical series of PIM by r according to the IBGE instructions, for this I…
-
0
votes2
answers64
viewsHow to create some kind of "dynamic index" in the database
I have a table with 10000 records, but here I will represent with only 10 of them. +-------+---------+------------------+ | index | posicao | nome | +-------+---------+------------------+ | 1 | 0 |…
-
0
votes2
answers122
viewsIs using the Mariadb JSON type a good one for saving primary keys?
I’m developing a database for a local travel agency: I need to pick up all the passengers and store them in one entity Viagem, so that in the "passengers" field of the latter would be of the JSON…
-
0
votes1
answer64
viewsSoftware Modeling
A software that has the option of registering projects and that each project has its specific working days (working days), which by default is Monday to Friday, but can be changed by project…