entity relationship

[EN-tuh-tee rih-LAY-shun-ship]
nounpl: entity relationships
relacionamento entre entidades
1. A conceptual model used in database design that describes how entities (objects or things) relate to and interact with one another
The entity relationship diagram shows how customers relate to orders in our database.
O diagrama de relacionamento entre entidades mostra como clientes se relacionam com pedidos em nosso banco de dados.
2. In data modeling, the association or connection between two or more entities defined by cardinality and participation constraints
The entity relationship defines a one-to-many connection between a teacher and their students.
O relacionamento entre entidades define uma conexão um-para-muitos entre um professor e seus alunos.
3. A fundamental concept in relational database architecture representing how different data objects connect and depend on each other
Understanding entity relationships is crucial for proper database normalization.
Compreender os relacionamentos entre entidades é crucial para a normalização adequada do banco de dados.
This is a technical term primarily used in software development, database administration, and IT education contexts. It originated from Chen's entity-relationship model (1976) and remains fundamental in both American and Brazilian tech industries. The term is widely recognized in both English and Portuguese-speaking tech communities, though many professionals use the English abbreviation 'ER model' regardless of their native language.
Synonyms / Sinônimos
entity-relationship modelER modelrelationship modeldata relationship

Regional Variations

General Brazilian
relacionamento entre entidades / modelo entidade-relacionamento
Standard term used in IT and database courses
Rio de Janeiro
relacionamento entre entidades
Same as general Brazilian usage
São Paulo
relacionamento entre entidades / modelo ER
Tech industry commonly uses the English term or abbreviation ER
Portugal
relação entre entidades / modelo entidade-relação
Slight variation in terminology preference

Related Words

entityattributecardinalitydatabase schemanormalizationprimary keyforeign keyrelational database

Related Idioms & Phrases

model the relationships
define entity relationships
map out entity connections
Look up more words on Fala2Me
The free English-Portuguese dictionary with real Brazilian accents, NYC slang, conjugator and more
Open Fala2Me →