INF503 Week 2 Quize’s

1._____ returns only the attributes requested, in the order in which they are requested.
The correct answer is: PROJECT

2.An entity is said to be _____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
The correct answer is: existence

3.A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes.
The correct answer is: candidate

4.A _____ is the primary key of one table that has been placed into another table to create a common attribute.
The correct answer is: foreign key

5._____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.
The correct answer is: Cardinality

6._____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.
The correct answer is: SELECT

7.A _____ contains at least all of the attribute names and characteristics for each table in the system.
The correct answer is: data dictionary

8.A _____ relationship exists when three entities are associated.
The correct answer is: ternary

9.A _____ is any key that uniquely identifies each row.
The correct answer is: superkey

10._____ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false.
The correct answer is: Predicate

11.A derived attribute is indicated in the Chen notation by a _____ that connects the attribute and an entity.
The correct answer is: dashed line

12.A _____ attribute is one that cannot be subdivided.
The correct answer is: simple

13.A(n) _____ is the set of possible values for a given attribute.
The correct answer is: domain

14._____ are especially useful when you are trying to determine what values in related tables cause referential integrity problems.
The correct answer is: Outer joins

15.A _____ relationship exists when an association is maintained within a single entity.
The correct answer is: unary

16.A _____ attribute can be further subdivided to yield additional attributes.
The correct answer is: composite

17.A relationship is an association between _____.
The correct answer is: entities

18._____ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.
The correct answer is: M:N

19.A _____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
The correct answer is: weak

20.A _____ key is defined as a key that is used strictly for data retrieval purposes.
The correct answer is: secondary

Other Links:

Statistics Quiz

Networking Quiz

See other websites for quiz:

Check on QUIZLET

Check on CHEGG



Leave a Reply

Your email address will not be published. Required fields are marked *