Topic 3: Relational Database Model

Question 1

These are used to ensure that each row in a table is uniquely identifiable

Answer 1

Keys

Question 2

Functional Dependence

Answer 2

If Column A determines one and only one value in Column B, B is functionally dependent on A

Question 3

These are two or more attributes used to define functional dependence

Answer 3

Composite Key

Question 4

Full Functional Dependence

Answer 4

– Need Explanation

Question 5

It is the key that uniquely identify the rows

Answer 5

Superkey

Question 6

It is a superkey without unnecessary attributes

Answer 6

Candidate key

Question 7

It refers to the candidate key chosen to be the unique row identifier

Answer 7

Primary Key

Question 8

It is a textual representation of the database tables

Answer 8

Relational Schema

Question 9

It is an attribute whose value match the primary key values in the related value

Answer 9

Foreign Key

Question 10

Explain Referential Integrity

Answer 10

When foreign Keys contains a value that refers to an existing valid tuple in another relation

Question 11

It is the key used strictly for data retrieval purposes

Answer 11

Secondary Key

Question 12

It provides a detailed description of all tables found within the user/designed-created database

Answer 12

Data Dictionary

Question 13

It is a detailed system data dictionary that describes all objects within the database

Answer 13

System Catalog

Question 14

It indicates that the use of the same attribute name to label different attributes

Answer 14

Homonyms

Question 15

It indicates that the user of different names to describe the same attributes

Answer 15

Synonym