S307 Midterm

The following figure shows an example of:

A composite attribute

For the relationship represented in the figure below, which of the following is true?

A department can have more than one employee

The following figure shows an example of:

A strong entity and its associated weak entity

In the figure below, what is depicted? (Enrolled Table)

An associative entity

An entity that associates the instances of one or more entity types and contains attributes peculiar to the relationships is called a(n):

Associative entity

The property by which subtype entities possess the values of all attributes of a supertype is called:

Attribute inheritance

A person's name, birthday, and social security number are all examples of:

Attributes

Which of the following criteria should be considered when selecting an identifier?

Choose an identifier that doesn't have large composite attributes

A(n) _________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype

Completeness

An attribute that can be broken down into smaller parts is called a(n) ________ attribute

Composite

In the figure below, the primary key for "Order Line" is which type of key?

Composite

A primary key that consists of more than one attribute is called a:

Composite Key

When a regular entity type contains a multivalued attribute, one must:

Create two new relations, one containing the multivalued attribute.

A graphical system used to capture the nature and relationships among data is called a(n):

Data Model

Which of the following is software used to create, maintain, and provide controlled access to databases?

Database management systems (DBMS)

Given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, Transmission SUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, Transmission, Truck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload

Define one vehicle entity type to hold all entities

An attribute that can be calculated from related attribute values is called a __________ attribute:

Derived

An attribute of an entity that is computed is a(n):

Derived attribute

In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the _______ rule

Disjoint

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes

Disjointedness constraint

In the following diagram, which answer is true?

Each employee can supervise one employee, no employees or many employees

In the following diagram, which of the answers below is true?

Each patient has one or more patient histories

Customers, cars, and parts are examples of:

Entities

A person, place, object, event, or concept about which the organization wishes to maintain data is called an:

Entity

The logical representation of an organizations data is called a(n):

Entity-relationship model

A composite key consists of only one attribute

False

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

Foreign Key

The process of defining a more general entity type from a set of more specialize entity types is called:

Generalization

Metadata typically describes all of the following EXCEPT:

Location on disk

A form or design of a database after mapping the conceptual ERD requirements is called:

Logical Designs

A database is an organized collection of _________ related data.

Logically

Data that describe the properties of other data are:

Metadata

In the figure below, a student:

Must be a graduate student, an undergraduate, a special student or some other type of student

The entity integrity rule states that:

No primary key attribute can be null

In the figure below, what type of relationship do the relations depict?

One-to-many

In a supertype/subtype hierarchy, each subtype has:

Only one supertype

In the figure below, which of the following is a subtype of patient?

Outpatient

The subtype discriminator in the figure below is:

Part_Type

A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a _________ dependency

Partial Functional

The _________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype

Partial specialization

In the figure below, which of the following apply to both OUTPATIENTs and RESIDENT_PATIENTs?

Patient_Name

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

Primary Key

One of the most popular RAD methods is:

Prototyping

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

Referential integrity constraint

A two-dimensional table of data sometimes is called a:

Relation

Relational databases establish the relationships between entities by means of common fields included in a file called a(n):

Relation

__________ are established between entities in a well-structured database so that the desired information can be retrieved

Relationships

An attribute that must be present for every entity (or relationship) instance is a(n):

Required attribute

A relation that contains no multivalued attributes and has nonkey attributes soley dependent on the primary key but contains transitive dependencies is in which normal form?

Second

In the figure below, which attribute is multivalued?

Skill

The process of defining one or more subtypes of a supertype and forming relationships is called:

Specialization

The most common types of entities are:

Strong entities

The following diagram shows:

Subtype discriminator

Which of the following is a generic entity type that has a relationship with one or more subtypes?

Supertype

The traditional methodology used to develop, maintain, and replace information systems is called the:

Systems Development Life Cycle

In a logical design or schema, the data is represented in the form of:

Tables

A simultaneous relationship among the instances of three entity types is called a _________ relationship

Ternary

The figure below is an example of mapping which type of relationship?

Ternary

A candidate key must satisfy all of the following conditions EXCEPT:

The key must indicate the row's position in the table

The following figure shows an example of:

The overlap rule

Subtypes should be used when:

There are attributes that apply to some but not all instances of an entity type

The following figure is an example of:

Total specialization

A functional dependency between two or more nonkey attributes is called a:

Transitive Dependency

A primary key is an attribute that uniquely identifies each row in a relation

True

In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized?

Vehicle

An entity type whose existence depends on another entity type is called a ________ entity.

Weak

In the figure below, which attribute is derived?

Years_Employed

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a _________ relationship.

many-to-many