ITSS 4300 (spring 2024)

Question 1

Named, two-dimensional tables with columns and rows into which data is organized.

Answer 1

relations

Question 2

Generic entity type related to one or more entity subtypes, Contains common characteristics

Answer 2

entity supertype

Question 3

Field or combination of fields that serves as the primary key of another relation in the database.

Answer 3

Foreign key

Question 4

is a comprehensive approach to promoting the accuracy, validity, and timeliness of the data.

Answer 4

data quality

Question 5

Links tables by selecting only the rows with common values in their common attributes

Answer 5

Natural Join

Question 6

a higher layer is perceived as the parent of the segment directly beneath it, which is called the child.

Answer 6

Hierarchical

Question 7

Links strong entities to weak entities.

Answer 7

Identifying relationship

Question 8

A nonkey attribute is functionally dependent on the primary key via another nonkey attribute.

Answer 8

Transitive dependency