DAD 220 - 4-1 Quiz

A singular attribute is also known as a unique attribute. Question options: True False

False

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. _____ Maxima is One-Many _____ Maxima is One-One _____ Minima is One-Zero _____ Minima is Zero-Zero 1. Person-Assigned-SocialSecurityNumber 2. CubicleNumber-Assigned-to-Employee 3. Birthdate-Recorded-for-a Person 4. Women-Bearing-Children

2. CubicleNumber-Assigned-to-Employee - Maxima is One-Many 1. Person-Assigned-SocialSecurityNumber - Maxima is One-One 3. Birthdate-Recorded-for-a Person - Minima is One-Zero 4. Women-Bearing-Children - Minima is Zero-Zero

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. Question options: 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

Conference as subtype under Team as supertype. City and State as subtypes under Team as supertype. TeamMoved as attribute of Conference subtype. CityName as attribute of Team supertype.

While in a hackathon at your high school, the instructor had to remove students with scores under 60 points. 60 is a number. The following is a sample of the scores. Hackathon Table: ID-----Sturdent Name--Score 4367--Jane Smith--------70 4756--Samuel Heart-----56 8789--Kim Parker--------97 What is the correct SQL to delete those students with scores under 60 points? Question options: DELETE FROM HACKATHON WHERE SCORE < '60'; DELETE FROM HACKATHON WHERE SCORE < 60; DELETE WHERE SCORE = 60;

DELETE FROM HACKATHON WHERE SCORE < 60;

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. Question options: The relationship maximum is One-Two. The relationship minimum is One-Two. The relationship minimum is Many-One. The relationship minimum is Two-One.

The relationship minimum is One-Two.

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. Question options: 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.

There must be a maximum of one attribute instance. There must be at most one entity instance that each attribute instance describes. There must be at least one instance of the attribute.

Dropping a table fails when a foreign key constraint refers to the table's primary key. Before dropping the table, either the foreign key constraint or the foreign key table must be dropped. Question options: True False

True