Relational Database

Question 1

invented the relational model for database management

Answer 1

Dr. E.F. Codd,

Question 2

represents the database as a collection of relations, with relations pertaining to tables with rows and columns.

Answer 2

RELATIONAL MODEL

Question 3

used extensively in mathematics to provide a framework in which an assertion (statement of fact) can be verified as either true or false.

Answer 3

Predicate logic

Question 4

a part of mathematical science that deals with sets, or groups of things, and is used as the basis for data manipulation in the relational model.

Answer 4

Set theory

Question 5

a type of database management system that stores information in tables- rows and columns of data.

Answer 5

RELATIONAL DATABASE

Question 6

the rows of a table

Answer 6

records

Question 7

the columns of a table

Answer 7

fields

Question 8

as a two-dimensional structure composed of rows and columns

Answer 8

table (relation)

Question 9

Each blank represents data about an entity

Answer 9

row (tuple)

Question 10

Each table column represents an blank , and each column has a distinct name.

Answer 10

attribute

Question 11

Each blank of a row and column represents a single data value.

Answer 11

intersection

Question 12

All values in a column must conform to the same data format. Each column has a specific range of values known as the blank

Answer 12

attribute domain

Question 13

serves as the unique identifier of a specific tuple in a relation

Answer 13

Primary key

Question 14

a pool of legal values for a given attribute

Answer 14

Domain

Question 15

a field in one table whose values are constrained to be values of the primary key in another table

Answer 15

Foreign key

Question 16

refers to the trustworthiness of system resources over their entire life cycle

Answer 16

DATA INTEGRITY

Question 17

four essential qualities or core attributes of data integrity

Answer 17

• completeness
• currency / timeliness
• accuracy / correctness
• validity / authorization

Question 18

Types of Data Integrity Rules

rules that apply to a particular database

Answer 18

Specific Integrity Rules

Question 19

rules that apply to all relational database

Answer 19

General Integrity Rules

Question 20

Types of Integrity Constraints

states that every table must have a primary key and that the column or columns chosen to be the primary key should be unique and not null

Answer 20

Entity Integrity Constraint

Question 21

any foreign key value can only be in one of two states the database must not contain any unmatched foreign key

Answer 21

Referential Integrity Constraint

Question 22

a set of mathematical principles that form the basis for manipulating relational table contents.

Answer 22

RELATIONAL ALGEBRA

Question 23

The use of relational algebra operators on existing relations (tables) produces new
relations is called blank

Answer 23

closure

Question 24

The condition to be evaluated is also known as blank

Answer 24

predicate

Question 25

# fundamental relational operators retrieves subset of rows

Answer 25

SELECT

Question 26

retrieves a subset of columns

Answer 26

PROJECT

Question 27

Merges two union-compatible tables into a new table, dropping the duplicate rows

Answer 27

UNION

Question 28

Retrieves rows that are common to two union-compatible tables

Answer 28

INTERSECT

Question 29

Retrieves rows from one table that are not found in another unioncompatible table

Answer 29

DIFFERENCE

Question 30

Retrieves possible pairs of rows from two tables (Cartesian Product)

Answer 30

PRODUCT

Question 31

Retrieves rows from two tables based on criteria

Answer 31

JOIN

Question 32

Retrieves unique column values that are associated with all the unique values of another table’s column

Answer 32

DIVIDE