MIST Exam

An advantage of the DBMS approach to data management is

• data redundancy is reduced

• data sharing is increased

• data independence is increased

• all of the above

• none of the above

the number instanced of entity A that must be associated with entity B is the

• multiple cardinality

• maximum cardinality

• mandatory cardinality

• none of the above

the document that contains detailed information about the entities and the attributes in the database is the

• data dictionary

• RAID

• subtype discriminator

• DBMS

when converting entities in a binary many-to-many relationship, how many tables will usually be created

• 1

• 2

• 3

• 4

the rule that sttes that an entity instance can only belong to one subclass is the

• disjoint rule

• total specialization rule (Complete)

• overlap rule

• partial specialization rule (incomplete)

an entity in an object model

• represents a person, place, or thing

• is described by attributes

• can also be called an object

• all of the above

a subclass ________ the attributes of the superclass

• optimizes

• inherits

• generalizes

• subsumes

maximum cardinality refers to the number of instances of entity A that entity B

• must be associated with

• may be associated with

• should be associated with

• all of the above

an attribute added to a superclass to differentiate between subclasses is an

• cardinality

• subtype discriminator

• subclass

• class differentiator

a unique identifier in a table is a(n)

• foreign key

• primary key

• multi-valued attribute

• all of the above