Question $5$

Your nephew has been asked to work on a database for NBA teams. The following are the requirements he

has been given:

All teams play in the Eastern Conference or the Western Conference.

Teams in each conference are named for cities or states.

Some teams have moved from one conference to another.

He asks for help in defining entities and attributes. Which of the following answers would you suggest he

use? Select all that apply.

NBA as supertype with Conference as subtype

Conference as subtype under Team as supertype

Team as subtype under Conference as supertype

City and State as subtypes under Team as supertype

TeamMoved as attribute of Conference subtype

CityName as attribute of Team supertype

Question $4$

A ride$-$sharing app's discount system for riders is made so a ride discount only initiates if at least two

RiderIDs book a ride in the same CarID at the same time. Which of the following answers is true of the

relationship RideDiscount$-$is$-$Applicable? Select one.

The relationship minimum is One$-$Two.

The relationship minimum is Two$-$One.

The relationship maximum is One$-$Two.

The relationship minimum is Many$-$One.

Question $3$

In the list below are relationship names and types of relationship maxima or minima that each could have.

Match each relationship in the list below to the type of relationship maxima or minima.

Instructions: Choose your responses from the drop$-$down menus below. Responses can only be used once.

$\_\_\_\_\_$ Minima is Zero$-$Zero

Maxima is One$-$One

Maxima is One$-$Many

Minima is One$-$Zero

Person$-$Assigned$-$SocialSecurityNumber

CubicleNumber$-$Assigned$-$to$-$Employee

Birthdate$-$Recorded$-$for$-$a Person

Women$-$Bearing$-$Children

Question $1$

To be used as a primary key, which of these characteristics must an attribute have in a single instance of

the entity? Select all that apply.

There must be a maximum of one attribute instance.

There must be many instances of the attribute.

There must be at most one entity instance that each attribute instance describes.

There must be at least one instance of the attribute.

There must be zero or more instances of the attribute.