relational database model Flashcards
Browse 500 sets of relational database model flashcards
Study sets
Diagrams
Classes
Users
Primary key (PK)
Determination
Functional dependence
Determinant
Attribute or combination of attributes that uniquely identifie…
State in which knowing the value of one attribute makes it pos…
Value of one or more attributes determines the value of one or…
Attribute whose value determines another
Primary key (PK)
Attribute or combination of attributes that uniquely identifie…
Determination
State in which knowing the value of one attribute makes it pos…
data dictionary
Data Storage
data transformation
data integrity
is a set of database tables used to store information about a…
Translates the program's logical/request/structural view of da…
Process of changing the data from their original form to a for…
ensures all tables are successfully updated completely by a pr…
data dictionary
is a set of database tables used to store information about a…
Data Storage
Translates the program's logical/request/structural view of da…
predicate logic
set theory
relational database is auto transmission
relation
statements of fact can be verified as either true or false
A part of mathematical science that deals with sets, or groups…
view the data logically rather than physically
a table
predicate logic
statements of fact can be verified as either true or false
set theory
A part of mathematical science that deals with sets, or groups…
predicate logic
set theory
primary key
key
used extensively in mathematics to provide a framework in whic…
A part of mathematical science that deals with sets, or groups…
In the relational model, an identifier composed of one or more…
One or more attributes that determine other attributes.
predicate logic
used extensively in mathematics to provide a framework in whic…
set theory
A part of mathematical science that deals with sets, or groups…
relational model
predicate logic
set theory
tuple
based on predicate logic and set theory
- used in math... - provides framework for assertions (statements…
- mathematical science deals with sets... - basis for data manipu…
- table row... - a single entity occurrence w/in entity set
relational model
based on predicate logic and set theory
predicate logic
- used in math... - provides framework for assertions (statements…
Attribute domain
Key
Use of Keys
Primary Key (PK)
Specific range of values of each column in a relation.
Consist of one or more attributes that determine other attribu…
- Ensure each row in the able is uniquely identifiable... - Estab…
Attribute or combination of attributes that uniquely identifie…
Attribute domain
Specific range of values of each column in a relation.
Key
Consist of one or more attributes that determine other attribu…
predicate logic
set theory
tuple
attribute domain
used extensively in mathematics to provide a framework in whic…
part of mathematical science that deals with sets, or groups o…
in the relational model, a table row
in data modeling, the construct used to organize and describe…
predicate logic
used extensively in mathematics to provide a framework in whic…
set theory
part of mathematical science that deals with sets, or groups o…
Attribute Domain
Keys
Dependency
Determination
A column data type's specific range of values
Attributes that determine other attributes, ensure that each r…
The value of one depends on others; describes relationship bet…
Knowing the value of one attribute makes it possible to determ…
Attribute Domain
A column data type's specific range of values
Keys
Attributes that determine other attributes, ensure that each r…
Predicate Logic
Set Theory
The Relational Model
Table
Used extensively in mathematics to provide a framework in whic…
A part of mathematical science that deals with sets, or groups…
- Introduced by E.F. Codd in 1970... - Enables you to view data l…
- two-dimensional structure composed of rows and columns... - per…
Predicate Logic
Used extensively in mathematics to provide a framework in whic…
Set Theory
A part of mathematical science that deals with sets, or groups…
predicate logic
set theory
tuple
domain
Used extensively in mathematics to provide a framework in whic…
A part of mathematical science that deals with sets, or groups…
In the relational model, a table row
In data modeling, the construct used to organize and describe…
predicate logic
Used extensively in mathematics to provide a framework in whic…
set theory
A part of mathematical science that deals with sets, or groups…
relational model
predicate logic
set theory
tuple
based on predicate logic and set theory
- used in math... - provides framework for assertions (statements…
- mathematical science deals with sets... - basis for data manipu…
- table row... - a single entity occurrence w/in entity set
relational model
based on predicate logic and set theory
predicate logic
- used in math... - provides framework for assertions (statements…
Relational Model enables...
3 Table characteristics
Attribute Domain
Key
Enables us to view data logically rather than physically
1. Has advantages of structural and data independence... 2. Resem…
Specific range of values in an attribute column
Consists of one or more attributes that determine other attrib…
Relational Model enables...
Enables us to view data logically rather than physically
3 Table characteristics
1. Has advantages of structural and data independence... 2. Resem…
Logical view
Relational model
Table
Table
Emphasize designer to focus on the logical representation of t…
Enables to view data logically rather than physically
Plays such a prominent role in designing relational model
Perceived as a two-dimensional structure composed of rows and…
Logical view
Emphasize designer to focus on the logical representation of t…
Relational model
Enables to view data logically rather than physically
Primary key (PK)
Functional dependence
Determinant
Dependent
Attribute or combination of attributes that uniquely identifie…
Value of one or more attributes determines the value of one or…
Attribute whose value determines another
Attribute whose value is determined by the other attribute
Primary key (PK)
Attribute or combination of attributes that uniquely identifie…
Functional dependence
Value of one or more attributes determines the value of one or…
Multi-valued attribute
Composite attribute
Weak relationship
Partial completeness
An attribute that may take on more than one value for a given…
A composite attribute had multiple components, each of which i…
A relationship that exists when the PK of the related entity d…
Not every supertype occurrence is a member of a subtype
Multi-valued attribute
An attribute that may take on more than one value for a given…
Composite attribute
A composite attribute had multiple components, each of which i…
The practical significance of taking th…
You can think of a table as a persisten…
The order of the rows and columns is im…
Character data can contain any characte…
True
True
False
False
The practical significance of taking th…
True
You can think of a table as a persisten…
True
key
superkey
candidate key
primary key (PK)
One or more attributes that determine other attributes.
An attribute or attributes that uniquely identify each entity…
A minimal superkey; that is, a key that does not contain a sub…
In the relational model, an identifier composed of one or more…
key
One or more attributes that determine other attributes.
superkey
An attribute or attributes that uniquely identify each entity…
business rule
candidate key
composite entity
composite key
A description of a policy, procedure, or principle within an o…
A minimal superkey; that is, a key that does not contain a sub…
An entity designed to transform an M:N relationship into two 1…
a multiple-attribute key
business rule
A description of a policy, procedure, or principle within an o…
candidate key
A minimal superkey; that is, a key that does not contain a sub…
Super Key
Candidate Key
Foreign Key
Domain
An attribute or set of attributes that uniquely identify a tup…
A minimum set of attributes that uniquely identify a tuple
- used to reference another relation... - attributes of FK have…
- set of atomic valid values of one or more attribute... - may b…
Super Key
An attribute or set of attributes that uniquely identify a tup…
Candidate Key
A minimum set of attributes that uniquely identify a tuple
3 key terms used extensively in relatio…
Tuples
database schema
Relational algebra
relations, attributes, and domains.... A relation - table with co…
Another name for rows in a relational database
a set of related tables and other database objects, is a funda…
consists of a set of operations for manipulating one or more r…
3 key terms used extensively in relatio…
relations, attributes, and domains.... A relation - table with co…
Tuples
Another name for rows in a relational database
Associative Entity?
Attribute Domain?
Bridge Entity?
Candidate Key?
See composite entity.... *An entity designed to transform an M:N…
See domain.... *In data modeling, the construct used to organize…
See composite entity.... *An entity designed to transform an M:N…
A minimal superkey; that is, a key that does not contain a sub…
Associative Entity?
See composite entity.... *An entity designed to transform an M:N…
Attribute Domain?
See domain.... *In data modeling, the construct used to organize…
Associative Entity
Attribute Domain
Bridge Entity
Candidate Key
An entity designed to transform an M:N relationship... into two 1…
Each column has a specific range of values known as the attrib…
aka composite entity, aka associative entity
A minimal superkey; that is, a key that does... not contain a sub…
Associative Entity
An entity designed to transform an M:N relationship... into two 1…
Attribute Domain
Each column has a specific range of values known as the attrib…
Relation
Primary Key
Composite Key
Foreign Key
A named two-dimensional table of data
An attribute or a combination of attributes that uniquely iden…
A primary key that consists of more than one attribute
An attribute in a relation that serves as the primary key of a…
Relation
A named two-dimensional table of data
Primary Key
An attribute or a combination of attributes that uniquely iden…