Quiz 3

In the E-R model, a key that consists of more than one attribute is described as __________

composite

In an EE-R diagram, the letter d in a specialization circle stands for __________

disjoint

In the E-R model, all of the following describe entity Y as existence dependent on entity X EXCEPT __________

for X to exist, Y must exist

Of the following types of keys, the one that does not appear in the entity-relational model is __________

foreign key

In an E-R diagram, attributes are represented by __________

ovals

In the EE-R model, if entity instances can belong to more than one subclass in a specialization, the subclasses are __________

overlapping

In the EE-R model, if subclass membership can be determined by examining a condition for each subclass, we describe the specialization as __________

predicate-defined

In the E-R model, when an entity set is related to itself, we call the relationship __________

recursive

In the EE-R model, the process of identifying subsets of existing entity set is called __________

specialization

Any attribute or set of attributes that uniquely identifies an entity is called a __________

superkey

In the E-R model, which of the following is true about weak entities?

Every weak entity is existent-dependent

In the E-R model, which of the following is NOT always true about a weak entity?

It always has one attribute which serves as a discriminator

On an E-R diagram, the primary key of an entity is indicated by __________

underlining

In an EE-R diagram, the specialization circle is sometimes called a(n) __________

isa relationship symbol

In a business, if a department can have many workers, but each worker belongs to only one department, the cardinality of the department-to-worker relationship is __________

one-to-many

In a library, the relationship between the borrower entity set and the books entity set normally has cardinality of __________

one-to-many

In the E-R model, connections or interactions between entities are called __________.

relationships

The entity-relationship model was developed by __________

Peter Chen

In the E-R model, if a relationship R is ternary, it means __________

R is a relationship among three entity sets

In an EE-R diagram, a total specialization is indicated by __________

a double line connecting the circle to the superclass

On an E-R diagram using (min,max) notation, if the line from the entity set Employee to the relationship Assign has (0,M) it indicates __________.

an employee may or may not have an assignment, but can have multiple assignments

In the EE-R model, if a specialization uses the same attribute in the defining predicate for a specialization, it is called __________

attribute-defined

The basic objects in the E-R model include all of the following EXCEPT __________

classes

In the E-R model, an attribute that can be broken down into smaller attributes is called __________.

composite

In the E-R model, the number of entities that can map to one another under a relationship is called the __________

degree of the relationship

In the E-R model, if the value of an attribute is determined by a calculation on the value of another attribute in a relation, we call the first attribute __________

derived

In the EE-R model, if entity instances cannot belong to more than one subclass, we say the subclasses are __________

disjoint

On an E-R diagram using (min,max) notation, if the line from the entity set Employee to the relationship Assign has (1,3) it indicates __________

every employee has some assignment, and at most 3

In a bank, if we assume that savings accounts can be jointly owned by two or more customers and that a customer can have more than one savings accounts, the relationship between the savings accounts entity set and the customer entity set is __________

many-to-many

In the E-R model, if each entity in set S can be associated with two or more entities in set T, but each entity in T can be associated with only one entity in S, then the binary relationship from S to T is called __________.

many-to-one

In a university, students can get at most one parking permit for one car. Not every student has a car. No car is allowed on campus without a parking permit. In the E-R model, the participation constraint for car in the relationship to student is __________

partial

In the E-R model, if every member of an entity set must participate in a relationship, the participation is described as __________

total

In the EE-R model, completeness constraints tell us whether a specialization is __________

total or partial

In the E-R model, if the value of an attribute is null, it often means the __________

value is unknown

In the E-R model, an entity that is existence-dependent on another and does not have a key of its own is called a __________

weak entity