Questions tagged as 'modelagem'

Tagged questions
1
answer

I create a table or several tables 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 to each table will be recorded a cost daily I create a table called Custo...
asked by 08.07.2018 / 17:35
1
answer

Best cardinality for a table with many relationships

Well, I have a cash flow table , this table can be related to a process, order, account receivable, payable ... among several other tables that relate to and which can result in a posting in the box, the problem is when creating the relationshi...
asked by 08.01.2015 / 21:53
1
answer

Problems in declaring a structure

I am creating a simple Poker game, in this game I defined that the cards would be structs . According to my business rules, each card has a value , a name and a suit . The Valor property corresponds to the range of 2 to 14 (this...
asked by 25.02.2018 / 23:01
1
answer

Relationship 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. How I did it: I have created a table for each type of these, plus a user table that cont...
asked by 02.09.2017 / 22:30
1
answer

Table with primary key that never repeats

I have a Produto (id, descricao, tipo) table and this same table is on three different computers. All three write data to your machine and from time to time send data to a server. What happens is this: let's say that PC1 and PC2 wri...
asked by 17.04.2017 / 21:20
1
answer

DB modeling for "multilevel marketing"

Personal speech, I'm working on an app that consists of people referencing, just like so-called multilevel marketing. The general idea is to: Person A indicates person B (LEVEL 1) if person B indicates person C (person N1 of person B a...
asked by 10.11.2016 / 16:51
1
answer

Construction workflow project

I'm building a system where I need to log drives and display them for certain users as well as for the progress of the process. Here is an example: Dep- Departamento. Equipe- pertence ao departamento. Dep1 - register request Dep2 - Make...
asked by 28.09.2016 / 19:02
1
answer

How to know the contents of a foreign key to fill in another table?

I will give 2 tables of a database: User and Address. where the user has the idEndereco attribute as the foreign key of the address table. The ids are with AUTO INCREMENT, yet, how do I know what the foreign key value of the address is? Will I h...
asked by 21.05.2016 / 20:23
1
answer

What software do I use to model images of this type? [closed]

I'm looking for software to model structure / 3D shapes, preferably simple, one that does not require deep knowledge in computer graphics ... but at the advanced user level. Image example:     
asked by 05.05.2015 / 04:30
1
answer

How to model a feedback system

I'm 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 it is related to the history table, which is the comments. My question is, how can I find out who...
asked by 02.04.2015 / 21:40