Questions tagged as 'modelagem'

0
answers

Product modeling with multiple suppliers and different prices

In a stock control scenario where 1 product can be supplied by 1 or more suppliers and 1 supplier can contain 1 or more products, what to do on the following occasion: Product "X" has 2 items in stock provided by supplier "A" and has cost pri...
asked by 05.03.2017 / 18:43
0
answers

Good practices in data modeling

I'm an intern and I'm developing a small application to help the quality and development staff to register the use cases and etc, the application is very simple even, it is done in Angles with backend C #, however we arrived in a point of the ap...
asked by 15.05.2017 / 20:20
0
answers

Tool for modeling data

Is there a tool for free data modeling in which I can do a reverse engineering of a Sql Server bank (express 2012) without be the DBDesegner Fork ?     
asked by 15.06.2016 / 16:00
2
answers

Specialization and generalization in database and application development

I have a Livros table and I know that book specialization / generalization is Livros de Ficção , Livros de Drama and Livros de Suspense , for example. However, in the logical model, I do not know if I create a table...
asked by 08.07.2018 / 22:28
2
answers

Use Redis in practice

I'm having a hard time noticing in practice where to use Redis in an ecommerce, for example. I'm reading a book but I can not figure out what I have to take into account when deciding to use Redis or not. Should Redis be used for static da...
asked by 06.10.2014 / 18:19
2
answers

How to model the products table for an e-commerce?

I'm having a question about how to model the Produto table of a small e-commerce I'm doing. I've been seeing some e-commerces and I came across the following situation: mm same product can have different colors and sizes, so when the cust...
asked by 23.08.2017 / 14:28
3
answers

Can a primary key be used on a foreign key?

Can the following example occur? | Id | nome | data | qnt | PK -> Id FK -> (Id, qnt) Or are there any restrictions?     
asked by 16.10.2014 / 02:29
1
answer

Split table in two?

I have a table with 25 columns (counting the FK) and two groups of users, one will only access 10 columns and the other will access almost all. Because I thought I had many columns in a single table (and think of object orientation as well) I en...
asked by 13.12.2016 / 15:54
2
answers

Making PostgreSQL database data visible or not, without deleting, is it possible?

I have an application where in addition to registering and consulting clients, it allows to issue reports with the information of the clients, the problem is that many of these customers already registered do not have more importance for the cur...
asked by 01.12.2016 / 14:43
2
answers

Inverse process modeling

Always, or almost, if ER Conceitual is made to then model ER Lógico , in the Model BR < a> it is possible to create ER Conceitual and generate ER Lógico automatically, but when there is a need to do the reverse proces...
asked by 25.04.2016 / 00:20