Question 1

______________________________ values waste memory space and may cause problems when running queries.

Accepted Answer

The answer of ______________________________ values waste memory space and may...

Question 2

REA stands for ______________________________, ______________________________ and ______________________________.

Accepted Answer

The answer of REA stands for ______________________________, ______________________________ and ______________________________....

Question 3

The ______________________________ specifies how many occurrences of an entity can participate in the given relationship with any one occurrence of the other entity in the relationship.

Accepted Answer

The answer of The ______________________________ specifies how many occurrences of...

Question 4

A set of data that describes a single instance of the entity represented by a relation is known as a(n) ______________________________.

Accepted Answer

The answer of A set of data that describes a...

Question 5

A(n) ______________________________ relationship occurs between two different instances of an entity.

Accepted Answer

The answer of A(n) ______________________________ relationship occurs between two different...

Question 6

______________________________ specifies that for every attribute value in one relation that has been specified to allow reference to another relation, the tuple being referenced must be intact.

Accepted Answer

The answer of ______________________________ specifies that for every attribute value...

Question 7

A(n) ______________________________ is a primary key that is inserted into other tables to establish links among the tables.

Accepted Answer

The answer of A(n) ______________________________ is a primary key that...

Question 8

______________________________ uses state-of-the-art information technologies for storing and analyzing data to help managers make the best possible decisions for their companies.

Accepted Answer

The answer of ______________________________ uses state-of-the-art information technologies for storing...

Question 9

The ______________________________ is specified to uniquely identity each tuple in the relation.

Accepted Answer

The answer of The ______________________________ is specified to uniquely identity...

Question 10

A(n) ______________________________ of an entity is one specific thing of the type defined by the entity.

Accepted Answer

The answer of A(n) ______________________________ of an entity is one...

Question 11

Queries of a database are driven by ______________________________ commands.

Accepted Answer

The answer of Queries of a database are driven by...

Question 12

A(n) ______________________________ a simplified representation of a complex entity or phenomenon.

Accepted Answer

The answer of A(n) ______________________________ a simplified representation of a...

Question 13

______________________________ systems have existed in an organization over a long period of time and were developed using an organization's previous computer hardware and software platforms.

Accepted Answer

The answer of ______________________________ systems have existed in an organization...

Question 14

______________________________ is a powerful database language that can be used to define database systems, query the database for information, generate reports from the database, and access databases from within programs using embedded commands.

Accepted Answer

The answer of ______________________________ is a powerful database language that...

Question 15

The notation 1:N is used to specify the relationship type of ______________________________.

Accepted Answer

The answer of The notation 1:N is used to specify...

Question 16

The ______________________________ command demonstrates one of the weaknesses in most forms of SQL because the database will not enforce referential integrity.

Accepted Answer

The answer of The ______________________________ command demonstrates one of the...

Question 17

The ______________________________ command is used when we want to change one or more attribute values for one or more tuples in a table.

Accepted Answer

The answer of The ______________________________ command is used when we...

Question 18

The ______________________________ command is used to add new tuples to a relation.

Accepted Answer

The answer of The ______________________________ command is used to add...

Question 19

The ______________________________ specifies the degree of minimum participation of one entity in the relationship with the other entity.

Accepted Answer

The answer of The ______________________________ specifies the degree of minimum...

Question 20

A collection of data representing multiple occurrences of a resource, event, or agent is known as a(n) ______________________________.

Accepted Answer

The answer of A collection of data representing multiple occurrences...

Quiz 6: Relational Databases and SQL