Dad 220 4 2 Lab Cardinality And Targeted Data Comprehensive Examination Test With Complete Solutions

DAD 220 4 2 LAB CARDINALITY AND
TARGETED DATA COMPREHENSIVE
EXAMINATION TEST WITH COMPLETE
SOLUTIONS


◉ 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. Answer: 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.


◉ A singular attribute is also known as a unique attribute.


Question options:
True
False Answer: 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 Answer: 2. CubicleNumber-Assigned-to-
Employee - Maxima is One-Many