The Relational Model Flashcards
The column’s range of permissible values is known as its
Domain
It is the state in which knowing the value of one attribute makes it possible to determine the value of another.
Determination
It means that the value of one or more attributes
determines the value of one or more other attributes.
Functional Dependence
The attributes whose value determines another is called the?
Determinant/key
The attribute whose value is determined by the other attribute is called?
Dependent
It is an attribute or group of attributes that can determine the values of other attributes. Therefore, keys are determinants of functional dependencies.
Key
It is an attribute or combination of attributes that uniquely identify any given row.
Primary Key (PK)
It is a key that is composed of more than one attribute. An attribute that is a part of a key is called a key attribute.
Composite Key
It is a key that can uniquely identify any row in the table.
Super Key
It is a minimal superkey—that is, a superkey without any unnecessary attributes.
Candidate Key
is the condition in which each row (entity instance) in the table has its own unique identity
Entity integrity
It is the absence of any data value, and it is
never allowed in any part of the primary key.
Null
It is the primary key of one table that has been placed into another table to create a common attribute
Foreign key (FK)
Foreign keys are used to ensure?
Referential Integrity
It is defined as a key that is used strictly for data retrieval purposes
Secondary Key
