Questions tagged as 'cardinalidade'

1
answer

What is the cardinality between a request and the services included in it?

I have class Solicitacao and class Servicos . After insertion into the database I want to retrieve in a query all the services associated with that request. For example, on one screen I insert the request and several services. Wh...
asked by 14.08.2015 / 16:18
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
1
answer

Cardinality Class Diagram

When I make a Class Diagram or MER, the cardinality must be defined. As an example: A doctor consults from 0 to n patients; a patient is consulted by 0 or 1 physician. Why 0?     
asked by 24.09.2015 / 23:05
3
answers

How to find relationship and cardinality in MySQL?

The image below shows a relationship between two tables created from the MySQL Workbench. What I need to know is how I can find this information inside the database. I need to know exactly what type of cardinality (1: 1 or 1: n). I've a...
asked by 29.09.2015 / 00:21
2
answers

Creation of tables with cardinality 1: N

I have two tables, PRODUTOS and INSUMOS . To create a precise product of various inputs, I would like to know how to proceed with this relationship in MySQL. Should I create a table called COMPOSICAO and work on it only with...
asked by 30.08.2018 / 20:26
1
answer

Cardinality in Database - Relationship One to ONE

I am studying database, and at the moment beyond the definitions of bank, type of models I am seeing Cardinality! I have doubts in this exercise below: My doubts are as follows    How do I identify the origem and destino...
asked by 13.06.2018 / 17:52
1
answer

Make relationship (0,1) in mysql workbench

I'm doing a project and started by modeling the database was all right up to the point of users that I was confused. Rules: general admin (access to all), admin company (access to all company events) and user (access to only one event). In th...
asked by 02.03.2016 / 13:46
0
answers

Minimum Cardinality and Maximum Cardinality in Database

Good afternoon! I'm trying to understand about Cardinalidade Minima and Cardinalidade Máxima between different entities! What I know so far is:    A Cardinalidade Minima can be a Atributo Opcional(0) or a...
asked by 13.06.2018 / 18:37