# 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…