Quiz#2 - Modeling Data in an Organization
Quiz by LUCY FELIX
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
- Q1
These are statements that define or constrainsome aspect of the business.
Users enter free textType an Answer30s - Q2
The following are characteristics of a good data name except one
technical
Readable
Unique
Repeatable
Meaningful and self-documenting
30s - Q3
It is a collection of entities
Entity Type
Entity Instances
Attributes
Relationship
30s - Q4
Which of the following statements is not correct about ER Models?
Attributes are properties or characteristics of an entity or relationshop.
The entity instances often corresponds to a row in a table
An entity type is a collection of entity instances.
A relationship type corresponds to the primary key - foreign key equivalences in related table.
30s - Q5
A SUPPLIER may send many SHIPMENTs. However, each shipment must be sent by exactly one SUPPLIER.
Which of the following ER Model best represent the given business rule?
30s - Q6
It is an attribute or a combination of attributes that uniquely identifies individual instances of an entity type.
Users enter free textType an Answer30s - Q7
It is an attribute that is both not null and unique which satisfies the conditions of an identifier
Composite Identifier
Candidate Identifier
Simple Identifier
Surrogate Identifier
30s - Q8
The following are characteristics of an identifier, except
An attribute that is unique for every instance
An attribute that contains location or people that might change
An attribute that will not change in value
A substitute new, simple key inplace of a long composite key.
An attribute that will not be null
30s - Q9
Which of the following is a multivalued attribute of Employee Entity type?
name(LN,FN MI)
date hired
contact number
date of birth
age
salary
30s - Q10
Which of the following is a derived attribute of Employee Entity type?
date of birth
age
name (LN,FN MI)
contact number
salary
date hired
30s - Q11
Which of the following is a composite attribute of Employee Entity type?
date of birth
salary
name (LN,FN MI)
contact number
date hired
30s - Q12
The following statements are TRUE except
nRelationships cannot have attributes
Associative Entity is a combination ofrelationship and entity
The relationship type is modeled aslines between entity types…the instance is between specific entity instances
Two entities can have more than onetype of relationship between them (multiple relationships)
30s - Q13
It refers tothe number of instances of one entity that can or must be associated with each instance of another entity
Users enter free textType an Answer30s - Q14
Which of the following describes a many to many cardinality of relationship?
None of the above
An entity on one side of the relationship can have many related entities, but an entity on the other sidewill have a maximum of one related entity
Each entity in the relationshipwill have exactly one related entity
Entities on both sides of the relationship can have many related entities on the other side
30s - Q15
Which of the following describes a one to many cardinality of relationship?
Each entity in the relationshipwill have exactly one related entity
None of the above
An entity on one side of the relationship can have many related entities, but an entity on the other side will have a maximum of one related entity
Entities on both sides of therelationship can have many related entities on the other side
30s
