Relational Database

Question 1

3 components of Relational Database

Answer 1

Data Structure
Data Manipulation
Data Integrity

Question 2

Columns/fields

Answer 2

Attributes

Question 3

Rows/tuples

Answer 3

Records

Question 4

Data organized in the form of tables, rows and columns

Answer 4

Data Structure

Question 5

Manipulate data in the relation usually through SQL

Answer 5

Data Manipulation

Question 6

Facilities are included to specify business rules that maintain the integrity of data

Answer 6

Data Integrity

Question 7

Relational Keys

Answer 7

Primary Key
Composite key
Foreign Key

Question 8

Serves as a unique identifier for a particular record

Answer 8

Primary Key

Question 9

Primary key that consists of more than one attributes

Answer 9

Composite Key

Question 10

Attribute or fields that is used to refer to data contained in another relation (reference key).

Answer 10

Foreign Key

Question 11

True or False:

Not all tables are relations

Answer 11

True

Question 12

Logical structure of a database

Answer 12

Schema

Question 13

Set of valid atomic values for a given attribute or field

Answer 13

Domain

Question 14

An empty value

Answer 14

Null

Question 15

Rules that apply to a particular relation

Answer 15

Specific Integrity Rules

Question 16

Rules that apply to all relations

Answer 16

General Integrity Rules

Question 17

Field that can possibly be
used as the primary key for the relation

Answer 17

Candidate Key

Question 18

2 requirements of Entity Integrity Rule

Answer 18

Uniqueness requirement
Minimality requirement

Question 19

“NO COMPONENT OF THE PRIMARY KEY OF
A BASE RELATION IS ALLOWED TO ACCEPT
NULLS”

The primary key cannot accept an empty value

Answer 19

Entity Integrity Rule

Question 20

True or False:

The primary key can accept null values

Answer 20

False

Question 21

Name the requirement:

No two tuples must have
the same value for the said field

Answer 21

Uniqueness requirement

Question 22

Name the requirement:

If the candidate key is
composite, then no field or any of its components can
be eliminated without affecting its uniqueness property

Answer 22

Minimality Requirement

Question 23

Rule expressing constraints/control of
organizational actions (business rule)

Answer 23

Action Assertion

Question 24

A relation whose tuples or records are
physically stored in a database

Answer 24

Base Relation

Question 25

“THE RELATIONS IN A DATABASE MUST NOT CONTAIN UNMATCHED
FOREIGN KEYS”

Answer 25

Referential Integrity Rule