Questions tagged as 'modelagem'

Tagged questions
2
answers

Modeling a friend system database

Hello, I'm developing an application where there will be an option to add friends, it's very simple, it's not social network, but you have to add a friend. I have the user table. Which tables and which relationships do I have to create to add fr...
asked by 10.11.2014 / 18:18
2
answers

Doubt in class diagram

Good afternoon. Here's the class diagram question with the diagram I've been able to do. Describe the class diagram for a simple system of reservation and occupation of rooms to a hotel. The system must store reservations made by an employ...
asked by 11.04.2017 / 19:53
1
answer

Modeling for Shared Address Table

I have 3 entities: Point, Requester and Service. Each one has its own address, but it is possible that all three have the same address. If an entity changes its address, it should not change the address of other entities, even if they have th...
asked by 27.04.2016 / 22:37
0
answers

UML - Use Case

Hello, I am a doubt about the elaboration of a use case, and I wonder if I can apply Generalization / Specification in cases of uses or is it just in the actors? Example 1 (No Generalization / Specification) Inthiscaseofuse,theofficialActorc...
asked by 30.06.2018 / 18:27
1
answer

What are the recommended values for MySQL database (id, user, password and email)?

I created a user table with the following values: Tipo = 'MyISAM' ID = 'int, PRIMARY, AI'; Usuário = 'varchar, 16'; Senha = 'varchar, 16'; Email = 'varchar, 100'; Are these values recommended? Insurance?     
asked by 24.05.2014 / 20:46
2
answers

What is the difference between MER (Relationship Entity Model) and DER (Entity Relationship Diagram)?

What is the difference between a diagram of the MER and one of the DER, with examples.     
asked by 09.09.2018 / 20:12
3
answers

Property set in constructor only returns zero value

I created a Web API in C # that returns me a list of products in JSON. However, the PrecoVenda property is always returned with a value of zero and I noticed that this occurs because in the constructor of the Produto class, Prec...
asked by 28.05.2018 / 01:00
2
answers

Modeling Models 1 to n

I'm modeling a system for Academies. I created 2 models, Modality public class Modalidade { [Key] public int ModalidadeId { get; set; } [MaxLength(200)] public string Nome { get; set; } [Newt...
asked by 22.09.2016 / 14:43
2
answers

Comprehensive Entity Enrollment Modeling

I am creating a database modeling in the most comprehensive way possible. The entities are Person, Individual, Legal Entity, Supplier and Customer Below the person entity. I add the person's contact information and address to facilitate futur...
asked by 14.04.2016 / 23:35
2
answers

Add a login field to existing users table

What would be the best way to add a login field to an existing database table with more or less 10,000 users. I am currently using MySQL and would like to give a remodeled user table, at the moment the table contains name, email, password, and...
asked by 05.03.2015 / 06:31