Questions tagged as 'modelagem'

1
answer

Domain Modeling - Forms of payment

I'm modeling the sales part of my system and I came across the following situation. I have created a payment method record and the MONEY payment method is standard and can not be changed, deleted, etc. I use this form of payment in opening cas...
asked by 30.04.2015 / 18:50
2
answers

Mounting database, how do I make this relationship?

I am putting together the EER diagram of an ERP. Virtually all tables have a column named "id_company" that relates to the "companies" table. This is because the user can manage one or more company, and I want every record of the other tables to...
asked by 04.02.2015 / 21:30
2
answers

Data Modeling: Integrity vs. Performance

In the company I work for, there is a data architecture I've never seen before, and I wonder if this is common, or if it's a new market trend. Just to mention the bank is Oracle. Here are some points: There is almost no relationship between...
asked by 03.05.2018 / 16:36
3
answers

MER - Cardinality temporal confusion

I have some temporal doubts. Example: [FUNCIONÁRIO]------<PERTENCE>------[DEPARTAMENTO] In this case it is obvious: each employee belongs to one department, and each department has N employees (either currently or over time)....
asked by 28.08.2015 / 10:41
2
answers

What is the concept and how to implement an anemic domain model?

I would like to resolve the following doubts about the Anemic Model: What is the Anemic Domain Model ? What are the implementation differences of this template compared to the Object Oriented Model ? If possible, present a small exampl...
asked by 15.10.2014 / 13:23
2
answers

Is the following database modeling in my head?

I created this modeling (just an idea), so that it does not have null / white fields. I have not completely revised it. There may be fields that would be blank. The matrix table was Entities and through the needs of there being no blank field...
asked by 30.06.2016 / 20:42
1
answer

Index cardinality does not update

I'm creating a program that connects to a MySQL database online, and when I start it it creates a table with an index if it does not exist. To check if everything is ok I am analyzing the database by phpMyAdmin from the server, but when I che...
asked by 09.08.2015 / 02:59
2
answers

Conceptual Model

I was looking at the conceptual model diagrams, I saw some that contains the Attributes and Entities like this: AndothersthatonlyhavetheEntity: Which model is correct? or are the two of you? Is it necessary to identify attributes in...
asked by 30.04.2016 / 02:42
3
answers

Working with ID boundaries in large volumes

I have in mind some questions about large volumes of data in MYSQL , referring to the ID limit. I'll give an ID type tinyint as an example to simplify the explanation. In the example the field tinyint accepts 127 records....
asked by 06.08.2015 / 19:05
2
answers

Values that can be entered as primary key

I have a company code for the product that consists of two letters and four numbers (example: XX0000), it is advisable to use this code as the primary key or to create another column with a code field and put unique to this code?     
asked by 22.06.2016 / 02:38