Show:
Definitions
Logical Database Design
Relationships
DBMS/Org Pyramid
Anything Goes
100

Something that describes a person, place, thing, object, or event is a(n):

Attribute

100

What is the conversion rule for a many to many binary relationship?

Create a new table.

100

A relationship in which three entities are relate is a(n):

Ternary Relationship

100
What is at least one advantage of the DBMS approach to data management?

Data sharing is increased

Data dependence is decreased

Data redundancy is reduced

100

A subclass _____ the attributes of the superclass.

inherits

200

A unique identifier in a table is a(n):

Primary Key

200

When two or more attributes come together to make one key, what is that called?

Concatenated primary key.

200

A relationship in which an entity has a relation with itself is called a(n):

Unary Relationship

200

What is the goal of MIST professionals?

To meet the needs of the user

To problem solve
200

Name at least two naming conventions for entities.

All capitalized

Singular

No special characters

300

An attribute that is unique enough to be the primary key but is not the primary key is a(n):

Candidate Key

300

When converting a binary 1 to many relationship, how many tables will usually be created?

Two

300

A relationship in which two entities are related is called a(n):

Binary Relationship

300

What is the goal of any good database?

Eliminate Redundancy
300

An attribute added to a superclass to differentiate between subclasses is a(n):

Subtype Discriminator

400

Cardinalities are determined by:

The business rules

400

When converting a multivalued attribute, you make a new table. What goes in the new table?

The attribute you are converting and the PK of the table that it came from.

400

A relationship between two entities that has attributes of its own can become a(n):

Associative entity

400

What comes after the conceptual design phase of the Database design model?

Logical Database Design

400

What is unstructured data?

Data that does not have a defined shape. Images, sounds, etc.

500

The rule that states that an instance of an entity may belong to one and only one subclass is a(n):

Disjoint Rule

500

Tables are linked together through:

Foreign key=Primary key links

500

The minimum cardinality refers to what?

The minimum number of instances entity A must be associated with entity B.

500
A cashier using a cash register in the checkout aisle is an exmple of which part of MIS at work?

TPS: Transaction Processing System

500

Which rule states that every subclass is shown and accounted for is the:

Completeness Constraint