MidTerm1jeopardyV2

Question 1

The term referring to an item existing in the real world that you want to track in a database is called ________.

Answer 1

Entity

Question 2

To be in 3rd Normal Form all non-key attributes must depend on

Answer 2

The key, whole key, and nothing but the key (so help me Codd (1970))

Question 3

The term used to describe the characteristics of interest for an entity _____________.

Answer 3

Attribute

Question 4

After conceptually designing your database, the information contained in a single entity would be stored in a _________________.

Answer 4

Table

Question 5

The attribute (or set of attributes) that uniquely identifies each row in a table is called the ___________________.

Answer 5

Primary Key

Question 6

The ability to modify the data structure and not have to change the programs using that data is called _____________________.

Answer 6

Data independence

Question 7

Metadata is ________________?

Answer 7

data about the data, often in the data dictionary

Question 8

The processing that is done by the DBMS is typically referred to as ________________.

Answer 8

back-end processing

Question 9

db2 400

Question 10

Specifying a zero (0) for the minimum cardinality on an ER Diagram indicates that the item is

Answer 10

optional

Question 11

—————-db3 100

Question 12

Data integrity can be improved by ____________.

Answer 12

incorporating business rules when defining the data

Question 13

Database system modelers use this type of diagram to graphically represent both the data structure and how the different objects are interrelated.

Answer 13

ERD or class diagram

Question 14

Business rules are often represented in the database through ________________.

Answer 14

relationships

Question 15

What is the special association that indicates that one entity can be broken down into multiple special cases?

Answer 15

class/subclass or super-type/sub-type

Question 16

Assume you are creating a database to handle the data associated with instruction at a university. What is the most appropriate special association to model that a course has an assigned instructor, Teaching Assistants, a classroom, meeting time slot, and class roster?

Answer 16

n-ary association

Question 17

Referential integrity is _________________?

Answer 17

constraint that forces a FK to always point to a PK, allows no orphan datapoint to a PK, allows no orphan data?

Question 18

A table that meets the requirements of a relation is said to be in which normal form?

Answer 18

1st Normal Form

Question 19

————-db4 400

Question 20

An attribute in one table that is used to create an association with another table by matching the primary key of that table is called a(n)

Answer 20

Foreign key

Question 21

Which term defines the highest number of permitted records in a related entity?

Answer 21

maximum cardinality

Question 22

A relationship that indicates that one employee can supervise other employees is called a(n) ______________ relationship.

Answer 22

recursive or reflexive

Question 23

It is an arbitrary, random key with no business meaning ________________ .

Answer 23

surrogate key

Question 24

A relationship that associates data from more than two tables is called a(n) _______________ relationship.

Answer 24

n-ary

Question 25

A library has the following business rule: A person may be a patron and not have any books borrowed and a patron may not have more than five books borrowed at any one time. The cardinality to represent this rule on the patron end would be ______________ and on the books borrowed end would by ______________ .

Answer 25

0:M and 0:5