Quiz 1.2

Question 1

Term used to describe the combination of the DBMS and the database.

Answer 1

Database System.

Question 2

The following property of transaction ensures that all manipulation of the database must be successful, or else no changes will be applied.

Answer 2

Atomicity.

Question 3

A function of the Database Management System (DBMS) that includes functions such as querying the database to retrieve specific data, updating the database to reflect changes in the mini world, and generating reports form the data.

Answer 3

Manipulating.

Question 4

Is sometimes referred to as the “intension” of the database.

Answer 4

Schema.

Question 5

When we define a new database, we specify its database schema only to the DBMS. At this point, the corresponding database is in this state.

Answer 5

Empty State.

Question 6

People whose jobs require access to the database for querying,
updating, and generating reports; the database primarily exists for their use.

Answer 6

Database Users.

Question 7

Of the different classes of end users, this class requires the most knowledge of the DBMS.

Answer 7

Sophisticated Users.

Question 8

Duplication of effort is one of many downsides in not controlling this, or storing the same data multiple times.

Answer 8

Data Redundancy.

Question 9

“every section record must be related to a course record” is an example of this type of constraint.

Answer 9

Referential Integrity.

Question 10

Some constraints can be specified to the DBMS and automatically enforced. Other constraints may have to be checked by update programs or at the time of data entry. For typical large applications, it is customary to call such constraints by this name.

Answer 10

Business Rules (Logic)

Question 11

1:1, 1:N, N:1, N:M are all cardinality ratios of these class of relationships.

Answer 11

Binary Relationships.

Question 12

This participation, also referred to as the “existence dependency” is represented as a double solid line from an entity type E to a relationship type R on an ER diagram.

Answer 12

Total Participation.

Question 13

The total number of subsets of an entity set {e1, e2, …, en} with n entity instances.

Answer 13

2^n.

Question 14

Daily Double (Which entity type can I move the attribute “StartDate” to)? One is (0,N), one is (1,N)

Answer 14

Neither

Question 15

The cardinality combined with the participation constraint(s) are referred to as this.

Answer 15

Structural Constraints.

Question 16

This type of attribute is represented on an ER diagram with a solid oval.

Answer 16

Simple Attribute, Single Valued Attribute.

Question 17

This type of attribute is represented on an ER diagram with a dotted oval.

Answer 17

Derived Attribute.

Question 18

This type of attribute is represented on an ER diagram with double ovals.

Answer 18

Multivalued attribute.

Question 19

This type of relationship is represented on an ER diagram with a double diamond.

Answer 19

Identifying Relationship.

Question 20

This type of entity cannot be uniquely identified by itself and has this type of key attribute.

Answer 20

Entity Type.

Question 21

The process of defining a set of subclasses of an entity type.

Answer 21

Specialization

Question 22

When an entity can be a member of at most one of the subclasses of the specialization, they are this.

Answer 22

Disjoint.

Question 23

The second constraint on specialization, which may be total or partial.

Answer 23

Completeness.

Question 24

When a shared subclass directly inherits attributes and relationships from more than 1 super classes.

Answer 24

Multiple Inheritance.