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
-
1
votes1
answer263
viewsBD modeling for "multi-level marketing"
Personal talk, I’m working on an app that consists of people referral, same as so-called multi-level marketing. The general idea consists of: Person A indicates person B (LEVEL 1) if person B…
-
1
votes2
answers81
viewsIs it possible to make Postgresql database data visible or not, without erasing it?
I have an application where in addition to registering and consulting clients, it allows to issue reports with customer information, the problem is that many of these customers already registered do…
-
1
votes1
answer368
viewsHow to implement product returns?
I am having difficulties in implementing a requirement in database modeling, this requirement corresponds to product returns. This is the scenario that occurs the returns and the different modes of…
-
1
votes1
answer117
viewsWhat is the best way to post comments?
How can I organize a Mysql comment system An idea would be: id_post id_comentario id_user comentario Only it would take up a lot of space and it wouldn’t be so fast to process 2000 comments from…
-
1
votes0
answers75
viewsIs it wrong that each attribute of a table is a foreign key in another table pointing to it?
I’m making a stock system and modeling, instead of each item having its attributes defined I wanted to make four tables tags (tag_decimal, tag_data, tag_text, tag_boolean) that pointed to the item…
-
1
votes0
answers139
viewsCustomer-supplier relationship model
Long ago I asked a question here about modeling clients using object orientation. What I took from the answers is that customers, suppliers, and so on, rather than being characterized as entities…
-
1
votes2
answers245
views -
1
votes2
answers258
viewsUse of struct in C#
I have to record customer information. And I used struct to do this. Is it worth doing this? It is or is not a good practice?…
-
1
votes1
answer79
viewsConstruction of workflow project
I’m building a system where I need to record drives and display them to certain users as well as the progress of the process. Follow an example: Dep- Departamento. Equipe- pertence ao departamento.…
-
1
votes1
answer300
viewsReporting - Consistency of data when prices are changed
I have the following database: Requirements: the prices of the lunch boxes and the address of the customers can be amended as necessary. every week I need to generate a report from that database,…
-
1
votes1
answer1041
viewsHow to represent an N:N relationship in java?
I think it’s a very simple question, but I couldn’t find any example that would make that clear. I already made my database model in Postgresql and when it came to creating the classes I was a…
-
1
votes1
answer100
views -
1
votes1
answer362
viewsSplit the table in two?
I have a table with 25 columns (counting the FK) and two groups of users, one will access only 10 columns and the other will access almost all. Because I thought I had many columns in a single table…
-
1
votes1
answer1898
viewsDifference and use between Primary Key and Foreign Key
I did a database modeling relating some tables and at the end of everything I was told that I was wrong for not having PK and FK keys. The question is, how do I differentiate a Primary Key from a…
-
1
votes1
answer416
viewsRelational model for user login
I need to make a simple trademark registration system, but I would like the person who is registering a new brand to be logged in to the system, I have a difficulty where to fit the login table in…
-
1
votes1
answer118
viewsTable with primary key that never repeats
I have a table Produto (id, descricao, tipo) and that same table is on three different computers. All three write data to your machine and from time to time send the data to a server. What happens…
-
1
votes1
answer562
viewsA: singular gradient Matrix at initial Parameter estimates
When using the following command to estimate model parameters (bell_model): h <- c(43.34, 35.84, 33.45, 30.94, 27.35, 21.75, 13.75, 57.37, 48.36, 44.62, 41.05, 36.49, 29.92, 21.07, 66.65, 56.65,…
-
1
votes1
answer65
views -
1
votes0
answers44
viewsDSL Tools: Centralize an Shape in the diagram
I’m developing a DSL. In the main window, I have two panels (Panel): in a, a list (listbox) of shapes of the diagram, and in the other, the diagram itself. I would like, by clicking on an item in…
-
1
votes0
answers32
viewsHow to model system actions/processes
I will try to explain what I have in hand and what my doubt. I am modeling a system that will control all the contracts of the company I have already started to identify the objects of this system…
-
1
votes2
answers1305
viewsHow to store product lists of an order in a database table?
I have the following database modeling so far: I’m wondering how best to store the products in the order table. One string with Id of all products for each order in the table? I think very bad. What…
-
1
votes1
answer162
viewsSave user location
I am trying to save the user’s location in a database, to subsequently generate reports on users by country, state and region. Initially I downloaded bases that contained the name of all the cities…
-
1
votes1
answer282
viewsRelationship of tables with the same attributes
My system is for employee control. Where we have the following types of people(or positions): agent, analyst, supervisor, coordinator and manager. Like I did: I created a table for each type of…
-
1
votes2
answers63
viewsOptimization of database model
I’m making a system for a college and one of the subsystems that I’m building is the student report card. I put for when creating a new discipline in the "discipline" table this discipline is added…
-
1
votes3
answers951
viewsTable normalization for 2nd Normal Form
A relation is in 2FN if and only if it is in 1FN and not contains partial dependencies. From this definition I am normalizing a BD to 2FN. This BD has 2 tables, which illustrates the figure with…
-
1
votes1
answer54
viewsPayment details of installments of insurance policies
I am finding it difficult to model an "Payment Details" entity, where it contains the numbering of an insurance policy or endorsement, with information such as gross premium payable, IOF, total…
-
1
votes1
answer84
viewsAre inheritance derived classes different tables in Mysql?
If I use inheritance and have 4 derived classes and my parent class is abstract, these 4 derived classes will each have a different table in the Mysql database?
-
1
votes1
answer724
viewsExample and illustration about redundant relationships (MER)
Context Consider the sentence below: It is claimed: Relationships that are the result of a combination of other relationships between the same entities are called: redundant relationships Doubt…
-
1
votes0
answers59
viewsModeling relationship tables
Good evening, everyone! I’d like to ask you a question. Is it possible for multiple tables to reference a single foreign key from a table? Follow the example of the modeling where the table…
-
1
votes2
answers71
viewsHow to control version number on budget?
I’m racking my brain here to get to a common denominator, I have a system in Delphi with Postgresql, this system has a budget session I need to control the changes made in these budgets by placing…
-
1
votes1
answer74
views -
1
votes0
answers111
viewsIs requirement traceability matrix the same as bi-directional traceability between test cases and requirements?
Contextualizing When studying for certification CTFL - Certified Tester Foundation Level came across the following study. Below Basic Activities in the Test Execution Process Plan and control…
-
1
votes0
answers189
viewsImproving Modeling in an Order System
I developed a food ordering system, but I have doubts whether the way I modeled the database is the best in terms of performance and longevity (how the system was to behave with a lot of data). I…
-
1
votes1
answer208
viewsCorrect Nomenclature of User Groups of a System
I am designing a system that will have several modules. It is possible until these modules are separated into different applications. Then came a doubt I had before but I could not get the answer:…
terminology modeling pattern-design software-architectureasked 6 years, 5 months ago Please_Dont_Bully_Me_SO_Lords 516 -
1
votes1
answer75
viewsCreate a table or several in SQL Server?
I have tables in my database: Orcamento, Maquinas, Veiculos and Acessorios. I need to record the costs of each of them, for example each table will be recorded a daily cost I create a table called…
-
1
votes2
answers86
viewsUser with more than one profile
In the business rule of the system I am working on, a user can have more than one profile. Profiles are: administrator, evaluator and responsible. For example: So-and-so can be an administrator and…
-
1
votes1
answer74
viewsHow to determine the type of data to use in this flexible case?
The project consists of a database for RPG sheets (D&D and the like). It was like this: Database record sheet Tables character system raccoon class attribute personagem_attribute Relationships…
-
1
votes1
answer97
viewsModeling teaching offer database
I’m studying databases and I’ve come up with a problem that I’m not getting out of. The problem is: "A school conducts education level offerings annually. Each year, one or more levels of education…
-
1
votes0
answers43
viewsModeling Database
I am doing a modeling for company and I am an intern. I studied a lot on the site that is in English... When I finished modeling there I went to show my modeling and they say I’m doing something…
-
1
votes1
answer199
viewsWhat is the difference between parameters and attributes when creating tables in a system?
I am a data migrator and every day, I have the pleasure and displeasure to know numerous databases of the most varied commercial systems in the market. My doubt lies in the way people model the…
-
1
votes1
answer87
viewsDeclare a class as attribute or implement Abstract?
You have LG branded television. in this scheme I can have different types of televisions and different types of electronics (so that the system can grow and I can use it not only for the tracking of…
-
1
votes0
answers62
viewsData Modeling (Relay Scale System)
I’m developing a relay scale system. Think of it as a kind of calendar, where one day has multiple shifts, shift has multiple positions, and employee is scaled to the position. Employee may be on…
-
1
votes1
answer148
viewsIs there a performance problem in using many foreign keys (FK)? If so, is it bad to have foreign attributes without being FK?
To clarify how much can be "many foreign keys", I will explain the context: In a system, I want to store by whom a certain record has been edited ( updatedBy) or raised (createdBy). This can happen…
-
1
votes1
answer49
viewsProblems Adjusting Linear Regression in Stan
I’m having trouble adjusting a linear regression model in Stan. When observing the error message, note the identification in the part of the transformed parameters block. See below the structure of…
-
1
votes2
answers68
viewsWhat to use to store status in a database?
I am creating a database in Mysql and in it there will be a table to do point control: when the employee started working hours, when closed, when stopped for lunch and etc. I’ve been making a…
-
1
votes1
answer138
viewsCombine with grid.arrange two residue charts (lme vs. lm)
I’m trying to put in the same image, side by side, the residue graphs adjusted by the linear model and the mixed linear model. However, I consulted the following links below and still my error…
-
0
votes1
answer112
viewsRelationship of products in models and bank
I’ll try to be brief in my doubt. How can I model a class scheme that gives me some questions: This I will do in Rails 4.1, using Activerecord as ORM acting in Mysql. I’ll have an entity Person…
mysql ruby-on-rails modeling active-record abstractionasked 10 years, 5 months ago Bruno Casali 566 -
0
votes1
answer101
viewsDoubt about Entity Modeling
I have an entity called Requests that satisfies the following business: A request is made by an Employee(Entity), then it is changed by another Employee and then confirmed by a third Employee. In a…
-
0
votes0
answers66
viewsApplication with Drag and Drop and other effects
I am preparing to do my TCC and the result of it will be an application. In this application I will model objects. To model this object the application will provide some shapes. These shapes should…
-
0
votes0
answers636
viewsDatabase Modeling - Self Relationship
My Case I have a table empresa, this table has fields known as cnpj, razão social and login. This same company may register another in its catalogue of companies. The company registered by it will…