Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Install
Faster access than browser!
 

Entity–relationship model

Index Entity–relationship model

An entity–relationship model (ER model for short) describes interrelated things of interest in a specific domain of knowledge. [1]

84 relations: Adjective, Adverb, Anchor modeling, Associative entity, Barker's notation, Bertrand Russell, Bijection, Binary relation, CACI, Cardinality (data modeling), Charles Sanders Peirce, Class diagram, Comparison of data modeling tools, Computer-aided software engineering, Concept map, Conceptual schema, Data architecture, Data modeling, Data structure diagram, Data warehouse, Database, Database design, Database index, Declarative programming, Domain of discourse, Enhanced entity–relationship model, Enterprise architecture framework, Entity, Epistemology, EXPRESS (data modeling language), First-class citizen, First-order logic, Foreign key, Gottlob Frege, IDEF1X, Information, Information engineering, Information system, Injective function, Intransitive verb, Is-a, Jackson structured programming, James Martin (author), Jean-Raymond Abrial, Logical data model, Master data, Merise, Metadata, Natural language, Noun, ..., Object-oriented programming, Object-role modeling, OLAP cube, Online analytical processing, Ontology (information science), Oracle Corporation, Peter Chen, Physical data model, Plato, Process modeling, Proper noun, Query language, Relational database, Relational model, Requirements analysis, Rudolf Carnap, Schema-agnostic databases, Semantics, Semi-structured data, Semiotics, Serial relation, Software engineering, Star schema, Structured entity relationship model, Structured systems analysis and design method, Surjective function, Table (database), Temporal database, Three-schema approach, Transitive verb, Unified Modeling Language, Unique key, Verb, Weak entity. Expand index (34 more) »

Adjective

In linguistics, an adjective (abbreviated) is a describing word, the main syntactic role of which is to qualify a noun or noun phrase, giving more information about the object signified.

New!!: Entity–relationship model and Adjective · See more »

Adverb

An adverb is a word that modifies a verb, adjective, another adverb, determiner, noun phrase, clause, or sentence.

New!!: Entity–relationship model and Adverb · See more »

Anchor modeling

Anchor modeling is an agile database modeling technique suited for information that changes over time both in structure and content.

New!!: Entity–relationship model and Anchor modeling · See more »

Associative entity

An associative entity is a term used in relational and entity–relationship theory.

New!!: Entity–relationship model and Associative entity · See more »

Barker's notation

Barker's notation refers to the ERD notation developed by Richard Barker, Ian Palmer, Harry Ellis et al.

New!!: Entity–relationship model and Barker's notation · See more »

Bertrand Russell

Bertrand Arthur William Russell, 3rd Earl Russell, (18 May 1872 – 2 February 1970) was a British philosopher, logician, mathematician, historian, writer, social critic, political activist, and Nobel laureate.

New!!: Entity–relationship model and Bertrand Russell · See more »

Bijection

In mathematics, a bijection, bijective function, or one-to-one correspondence is a function between the elements of two sets, where each element of one set is paired with exactly one element of the other set, and each element of the other set is paired with exactly one element of the first set.

New!!: Entity–relationship model and Bijection · See more »

Binary relation

In mathematics, a binary relation on a set A is a set of ordered pairs of elements of A. In other words, it is a subset of the Cartesian product A2.

New!!: Entity–relationship model and Binary relation · See more »

CACI

CACI International Inc is an American multinational professional services and information technology company headquartered in Arlington, Virginia, United States.

New!!: Entity–relationship model and CACI · See more »

Cardinality (data modeling)

In database design, the cardinality or fundamental principle of one data aspect with respect to another is a critical feature.

New!!: Entity–relationship model and Cardinality (data modeling) · See more »

Charles Sanders Peirce

Charles Sanders Peirce ("purse"; 10 September 1839 – 19 April 1914) was an American philosopher, logician, mathematician, and scientist who is sometimes known as "the father of pragmatism".

New!!: Entity–relationship model and Charles Sanders Peirce · See more »

Class diagram

In software engineering, a class diagram in the Unified Modeling Language (UML) is a type of static structure diagram that describes the structure of a system by showing the system's classes, their attributes, operations (or methods), and the relationships among objects.

New!!: Entity–relationship model and Class diagram · See more »

Comparison of data modeling tools

This article is a comparison of data modeling tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment.

New!!: Entity–relationship model and Comparison of data modeling tools · See more »

Computer-aided software engineering

Computer-aided software engineering (CASE) is the domain of software tools used to design and implement applications.

New!!: Entity–relationship model and Computer-aided software engineering · See more »

Concept map

A concept map or conceptual diagram is a diagram that depicts suggested relationships between concepts.

New!!: Entity–relationship model and Concept map · See more »

Conceptual schema

A conceptual schema is a high-level description of a business's informational needs.

New!!: Entity–relationship model and Conceptual schema · See more »

Data architecture

In information technology, data architecture is composed of models, policies, rules or standards that govern which data is collected, and how it is stored, arranged, integrated, and put to use in data systems and in organizations.

New!!: Entity–relationship model and Data architecture · See more »

Data modeling

Data modeling in software engineering is the process of creating a data model for an information system by applying certain formal techniques.

New!!: Entity–relationship model and Data modeling · See more »

Data structure diagram

Data structure diagram (DSD) is a diagram of the conceptual data model which documents the entities and their relationships, as well as the constraints that connect to them.

New!!: Entity–relationship model and Data structure diagram · See more »

Data warehouse

In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence.

New!!: Entity–relationship model and Data warehouse · See more »

Database

A database is an organized collection of data, stored and accessed electronically.

New!!: Entity–relationship model and Database · See more »

Database design

Database design is the organisation of data according to a database model.

New!!: Entity–relationship model and Database design · See more »

Database index

A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure.

New!!: Entity–relationship model and Database index · See more »

Declarative programming

In computer science, declarative programming is a programming paradigm—a style of building the structure and elements of computer programs—that expresses the logic of a computation without describing its control flow.

New!!: Entity–relationship model and Declarative programming · See more »

Domain of discourse

In the formal sciences, the domain of discourse, also called the universe of discourse, universal set, or simply universe, is the set of entities over which certain variables of interest in some formal treatment may range.

New!!: Entity–relationship model and Domain of discourse · See more »

Enhanced entity–relationship model

The enhanced entity–relationship (EER) model (or extended entity–relationship model) in computer science is a high-level or conceptual data model incorporating extensions to the original entity–relationship (ER) model, used in the design of databases.

New!!: Entity–relationship model and Enhanced entity–relationship model · See more »

Enterprise architecture framework

An enterprise architecture framework (EA framework) defines how to create and use an enterprise architecture.

New!!: Entity–relationship model and Enterprise architecture framework · See more »

Entity

An entity is something that exists as itself, as a subject or as an object, actually or potentially, concretely or abstractly, physically or not.

New!!: Entity–relationship model and Entity · See more »

Epistemology

Epistemology is the branch of philosophy concerned with the theory of knowledge.

New!!: Entity–relationship model and Epistemology · See more »

EXPRESS (data modeling language)

EXPRESS is a standard data modeling language for product data.

New!!: Entity–relationship model and EXPRESS (data modeling language) · See more »

First-class citizen

In programming language design, a first-class citizen (also type, object, entity, or value) in a given programming language is an entity which supports all the operations generally available to other entities.

New!!: Entity–relationship model and First-class citizen · See more »

First-order logic

First-order logic—also known as first-order predicate calculus and predicate logic—is a collection of formal systems used in mathematics, philosophy, linguistics, and computer science.

New!!: Entity–relationship model and First-order logic · See more »

Foreign key

In the context of relational databases, a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table.

New!!: Entity–relationship model and Foreign key · See more »

Gottlob Frege

Friedrich Ludwig Gottlob Frege (8 November 1848 – 26 July 1925) was a German philosopher, logician, and mathematician.

New!!: Entity–relationship model and Gottlob Frege · See more »

IDEF1X

Integration DEFinition for information modeling (IDEF1X) is a data modeling language for the development of semantic data models.

New!!: Entity–relationship model and IDEF1X · See more »

Information

Information is any entity or form that provides the answer to a question of some kind or resolves uncertainty.

New!!: Entity–relationship model and Information · See more »

Information engineering

Information engineering (IE) or information engineering methodology (IEM) is a software engineering approach to designing and developing information systems.

New!!: Entity–relationship model and Information engineering · See more »

Information system

An information system (IS) is an organized system for the collection, organization, storage and communication of information.

New!!: Entity–relationship model and Information system · See more »

Injective function

In mathematics, an injective function or injection or one-to-one function is a function that preserves distinctness: it never maps distinct elements of its domain to the same element of its codomain.

New!!: Entity–relationship model and Injective function · See more »

Intransitive verb

In grammar, an intransitive verb does not allow a direct object.

New!!: Entity–relationship model and Intransitive verb · See more »

Is-a

In knowledge representation, object-oriented programming and design (see object-oriented program architecture), is-a (is_a or is a) is a subsumption relationship between abstractions (e.g. types, classes), wherein one class A is a subclass of another class B (and so B is a superclass of A).

New!!: Entity–relationship model and Is-a · See more »

Jackson structured programming

Jackson structured programming (JSP) is a method for structured programming based on correspondences between data stream structure and program structure.

New!!: Entity–relationship model and Jackson structured programming · See more »

James Martin (author)

James Martin (19 October 1933 – 24 June 2013) was a British Information Technology consultant and author, known for his work on information engineering.

New!!: Entity–relationship model and James Martin (author) · See more »

Jean-Raymond Abrial

Jean-Raymond Abrial (born 1938) is a French computer scientist and inventor of the Z and B formal methods.

New!!: Entity–relationship model and Jean-Raymond Abrial · See more »

Logical data model

A logical data model or logical schema is a data model of a specific problem domain expressed independently of a particular database management product or storage technology (physical data model) but in terms of data structures such as relational tables and columns, object-oriented classes, or XML tags.

New!!: Entity–relationship model and Logical data model · See more »

Master data

Master data represents the business objects which are agreed on and shared across the enterprise.

New!!: Entity–relationship model and Master data · See more »

Merise

Merise is a general-purpose modeling methodology in the field of information systems development, software engineering and project management.

New!!: Entity–relationship model and Merise · See more »

Metadata

Metadata is "data that provides information about other data".

New!!: Entity–relationship model and Metadata · See more »

Natural language

In neuropsychology, linguistics, and the philosophy of language, a natural language or ordinary language is any language that has evolved naturally in humans through use and repetition without conscious planning or premeditation.

New!!: Entity–relationship model and Natural language · See more »

Noun

A noun (from Latin nōmen, literally meaning "name") is a word that functions as the name of some specific thing or set of things, such as living creatures, objects, places, actions, qualities, states of existence, or ideas.

New!!: Entity–relationship model and Noun · See more »

Object-oriented programming

Object-oriented programming (OOP) is a programming paradigm based on the concept of "objects", which may contain data, in the form of fields, often known as attributes; and code, in the form of procedures, often known as methods. A feature of objects is that an object's procedures can access and often modify the data fields of the object with which they are associated (objects have a notion of "this" or "self").

New!!: Entity–relationship model and Object-oriented programming · See more »

Object-role modeling

Object-role modeling (ORM) is used to model the semantics of a universe of discourse.

New!!: Entity–relationship model and Object-role modeling · See more »

OLAP cube

In database engineering in computing, OLAP cube is a term that typically refers to a multi-dimensional array of data.

New!!: Entity–relationship model and OLAP cube · See more »

Online analytical processing

Online analytical processing, or OLAP, is an approach to answering multi-dimensional analytical (MDA) queries swiftly in computing.

New!!: Entity–relationship model and Online analytical processing · See more »

Ontology (information science)

In computer science and information science, an ontology encompasses a representation, formal naming, and definition of the categories, properties, and relations of the concepts, data, and entities that substantiate one, many, or all domains.

New!!: Entity–relationship model and Ontology (information science) · See more »

Oracle Corporation

Oracle Corporation is an American multinational computer technology corporation, headquartered in Redwood Shores, California.

New!!: Entity–relationship model and Oracle Corporation · See more »

Peter Chen

Peter Pin-Shan Chen (Chinese: 陳品山, born in 1947) is a Taiwanese American computer scientist.

New!!: Entity–relationship model and Peter Chen · See more »

Physical data model

A physical data model (or database design) is a representation of a data design as implemented, or intended to be implemented, in a database management system.

New!!: Entity–relationship model and Physical data model · See more »

Plato

Plato (Πλάτων Plátōn, in Classical Attic; 428/427 or 424/423 – 348/347 BC) was a philosopher in Classical Greece and the founder of the Academy in Athens, the first institution of higher learning in the Western world.

New!!: Entity–relationship model and Plato · See more »

Process modeling

The term process model is used in various contexts.

New!!: Entity–relationship model and Process modeling · See more »

Proper noun

A proper noun is a noun that in its primary application refers to a unique entity, such as London, Jupiter, Sarah, or Microsoft, as distinguished from a common noun, which usually refers to a class of entities (city, planet, person, corporation), or non-unique instances of a specific class (a city, another planet, these persons, our corporation).

New!!: Entity–relationship model and Proper noun · See more »

Query language

Query languages or data query languages (DQLs) are computer languages used to make queries in databases and information systems.

New!!: Entity–relationship model and Query language · See more »

Relational database

A relational database is a digital database based on the relational model of data, as proposed by E. F. Codd in 1970.

New!!: Entity–relationship model and Relational database · See more »

Relational model

The relational model (RM) for database management is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in 1969 by Edgar F. Codd, where all data is represented in terms of tuples, grouped into relations.

New!!: Entity–relationship model and Relational model · See more »

Requirements analysis

In systems engineering and software engineering, requirements analysis encompasses those tasks that go into determining the needs or conditions to meet for a new or altered product or project, taking account of the possibly conflicting requirements of the various stakeholders, analyzing, documenting, validating and managing software or system requirements.

New!!: Entity–relationship model and Requirements analysis · See more »

Rudolf Carnap

Rudolf Carnap (May 18, 1891 – September 14, 1970) was a German-born philosopher who was active in Europe before 1935 and in the United States thereafter.

New!!: Entity–relationship model and Rudolf Carnap · See more »

Schema-agnostic databases

Schema-agnostic databases or vocabulary-independent databases aim at supporting users to be abstracted from the representation of the data, supporting the automatic semantic matching between queries and databases.

New!!: Entity–relationship model and Schema-agnostic databases · See more »

Semantics

Semantics (from σημαντικός sēmantikós, "significant") is the linguistic and philosophical study of meaning, in language, programming languages, formal logics, and semiotics.

New!!: Entity–relationship model and Semantics · See more »

Semi-structured data

Semi-structured data is a form of structured data that does not conform with the formal structure of data models associated with relational databases or other forms of data tables, but nonetheless contains tags or other markers to separate semantic elements and enforce hierarchies of records and fields within the data.

New!!: Entity–relationship model and Semi-structured data · See more »

Semiotics

Semiotics (also called semiotic studies) is the study of meaning-making, the study of sign process (semiosis) and meaningful communication.

New!!: Entity–relationship model and Semiotics · See more »

Serial relation

In set theory, a serial relation is a binary relation R for which every element of the domain has a corresponding range element (∀ x ∃ y x R y).

New!!: Entity–relationship model and Serial relation · See more »

Software engineering

Software engineering is the application of engineering to the development of software in a systematic method.

New!!: Entity–relationship model and Software engineering · See more »

Star schema

In computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts.

New!!: Entity–relationship model and Star schema · See more »

Structured entity relationship model

The SERM (structured entity relationship model) is an amplification of the ERM which is commonly used for data modeling.

New!!: Entity–relationship model and Structured entity relationship model · See more »

Structured systems analysis and design method

Structured systems analysis and design method (SSADM), originally released as methodology, is a systems approach to the analysis and design of information systems.

New!!: Entity–relationship model and Structured systems analysis and design method · See more »

Surjective function

In mathematics, a function f from a set X to a set Y is surjective (or onto), or a surjection, if for every element y in the codomain Y of f there is at least one element x in the domain X of f such that f(x).

New!!: Entity–relationship model and Surjective function · See more »

Table (database)

A table is a collection of related data held in a structured format within a database.

New!!: Entity–relationship model and Table (database) · See more »

Temporal database

A temporal database stores data relating to time instances.

New!!: Entity–relationship model and Temporal database · See more »

Three-schema approach

The three-schema approach, or three-schema concept, in software engineering is an approach to building information systems and systems information management that originated in the 1970s.

New!!: Entity–relationship model and Three-schema approach · See more »

Transitive verb

A transitive verb is a verb that requires one or more objects.

New!!: Entity–relationship model and Transitive verb · See more »

Unified Modeling Language

The Unified Modeling Language (UML) is a general-purpose, developmental, modeling language in the field of software engineering, that is intended to provide a standard way to visualize the design of a system.

New!!: Entity–relationship model and Unified Modeling Language · See more »

Unique key

In database relational modeling and implementation, a unique key (also known as a candidate key) of a relation is a minimal superkey for that relation; that is, a set of attributes such that.

New!!: Entity–relationship model and Unique key · See more »

Verb

A verb, from the Latin verbum meaning word, is a word (part of speech) that in syntax conveys an action (bring, read, walk, run, learn), an occurrence (happen, become), or a state of being (be, exist, stand).

New!!: Entity–relationship model and Verb · See more »

Weak entity

In a relational database, a weak entity is an entity that cannot be uniquely identified by its attributes alone; therefore, it must use a foreign key in conjunction with its attributes to create a primary key.

New!!: Entity–relationship model and Weak entity · See more »

Redirects here:

Chen notation, Chen's notation, Conceptual Entity Model, Crow's feet notation, Crow's foot notation, E-R diagram, E-r model, ER diagram, ER model, ERA model, Entity Relationship Diagram, Entity class, Entity relationship, Entity relationship attribute, Entity relationship diagram, Entity relationship diagrams, Entity relationship model, Entity relationship modelling, Entity relationship models, Entity-Relationship Diagram, Entity-Relationship Model, Entity-Relationship diagram, Entity-Relationship diagram (ERD), Entity-Relationship model, Entity-attribute-relationship model, Entity-relationship, Entity-relationship diagram, Entity-relationship diagrams, Entity-relationship model, Entity-relationship models, Entity-relationship-attribute, Entity–relationship diagram, Er diagram, Er model, Er modelling.

References

[1] https://en.wikipedia.org/wiki/Entity–relationship_model

OutgoingIncoming
Hey! We are on Facebook now! »