DAD_220_-_4-1_QUIZ

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Information Systems

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by AdmiralAlbatrossPerson792

4-1 Quiz Your work has been saved and submitted Written Jan 31, 2024 12:44 PM - Jan 31, 2024 1:08 PM e Attempt 1 of 2 Attempt Score 20/20-A Overall Grade (Highest Attempt) 20/20-A Question 1 2/ 2 points 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. w Hide question 1 feedback During the extraction of data from a database, a primary key must be singular, regular, and unique. For a single entity instance, consider the following definitions: An attribute is termed singular when a maximum of one data value may exist. An attribute is unigue when the data value occurs only once. An attribute is considered required when at least one data value must exist.

Question 2 2 / 2 points A singular attribute is also known as a unique attribute. True o False w Hide question 2 feedback A singular attribute is not the same as a unique attribute. Both are associated with a single entity instance. A singular attribute has an attribute maximum of one. At most one attribute instance can be associated with a single entity instance. Each instance of a unique attribute describes only one entity instance. For example, an attribute WeeklyPay is a singular attribute of an Employee because each Employee can receive only one value of WeeklyPay. But it is not a unique attribute because many Employees can have the same value of WeeklyPay. Question 3 3/ 3 points 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. __4 Minima is Zero-Zero 1. Person-Assigned-SocialSecurityNumber __1 Maxima is One-One 2. CubicleNumber-Assigned-to-Employee __2__ Maxima is One-Many 3. Birthdate-Recorded-for-a Person 3 Minima is One-Zero 4. Women-Bearing-Children w Hide question 3 feedback In the relationship Person-Assigned-SocialSecurityNumber, the maxima is one-one because we know that one person can only be assigned one social security number and vice-versa. For the relationship CubicleNumber-Assigned-to-Employee, the maxima is one-many: In a workplace that runs on shifts, the same cubicle number may be assigned to many employees, but each employee may only be assigned to one cubicle number. For the relationship Birthdate-Recorded-for-a Person, the minima is one-zero because the minimum number of people born on a date may be zero. But each person that has been born has at least one recorded birthdate. Finally, for the relationship Women-Bearing-Children, the minima is zero-zero because there may be no women at all who are pregnant, so there may not be any children being born.

Question 4 2 / 2 points 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 CarlD at the same time. Which of the following answers is true of the relationship RideDiscount-is-Applicable? Select one. The relationship minimum is Many-One. The relationship minimum is Two-One. The relationship maximum is One-Two. e The relationship minimum is One-Two. w Hide question 4 feedback The relationship minimum for RideDiscount-is-Applicable is One-Two given the business rule described. For the ride discount to initiate, the same CarlD must receive a booking from at least two Rider|Ds at the same time. At least two Rider|Ds are required to book with one CarlD. Question 5 2 / 2 points 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 w Hide question 5 feedback « ATeam is a supertype entity because it is the basic unit of the NBA. « A Conference is a subtype entity of the Team entity because a Conference is made of a subset of all teams in the NBA. « Teams named for a City or State are other subsets, so City and State are subtype entities under Team as supertype. « A Team may be named for a City, so CityName is an attribute of the supertype entity Team. « A Team may have moved from one Conference to another, so TeamMoved is an attribute of the Conference subtype entity.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help