Models
This modeling language was developed for software engineering of large systems using object-oriented programming languages. We use it for modeling the enterprise.
Unified Modeling Language (UML)
This is any "thing" in the enterprise that is to be represented in the database by an ER model.
Entity (Entity Type)
This contains information about one individual in a database table. (It is called a tuple in the relational model.)
Row
This can be any set of attributes in a relation whose values, taken together, guarantee uniqueness of the rows in a table.
Super key
The minimum and maximum number of individuals of one entity that may be associated with a single member of another entity.
Cardinality
This model is similar to UML, but is used primarily in database development rather than software engineering.Entity-Relationship (ER) model
Entity-Relationship (ER) model
This is related to two or more distinct entities with a specific meaning that is to be represented by an ER model.
Relationship (Type)
This function assigns a constant value from the attribute domain to each attribute in a relation scheme. (It is called a row in the table model.)
Tuple
This minimal super key can't have an attribute deleted without losing the super key property, or added without losing its distinction.
Candidate key
The way that two entities are functionally connected to each other.
Relationship
This is the formal mathematical model of a relational database.
Relational Model
This is one piece of information that characterizes each member of a class or entity type.
Attribute
This set of rows represents all of the individual in a class. (It is called a relation in the relational model.)
Table
This candidate key is picked by the database designer to guarantee uniqueness of each row in a table.
Primary key
This relationship has a maximum of 1 to each other.
One-to-one relationship
This formal language is used to symbolically manipulate objects of the relational model.
Relational Algebra
This is an attribute that have a unique value for each entity in ER model.
Key attribute
This set of tuples contains the information for all individuals in a class. (It is called a table in the table model.)
Relation
This made-up several primary keys has no descriptive value about an individual.
Surrogate key
This relationship has a maximum multiplicity of 1..*
One-to-many relationship
This is the informal set of terms for relational model objects, used most often in database work.
Table
This is a notation of ER model that represent entities as boxes, and relationships as lines between the boxes.
Crow Foot
This special constant value is compatible with any data type and means "this field doesn't have any value assigned to it."
NULL
This is a constraint involving two relations and used to specify a relationship among tuple in two relations.
Referential integrity constraint
This set of attributes is copied from the PK of a parent table into the scheme of a child table.
Foreign key