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
- view complete results in the Gradebook and Mastery Dashboards
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
Our brand new solo games combine with your quiz, on the same screen
Correct quiz answers unlock more play!
- Q1
These are statements that define or constrainsome aspect of the business.
Users enter free textType an Answer30sEditDelete - Q2
The following are characteristics of a good data name except one
technical
Readable
Unique
Repeatable
Meaningful and self-documenting
30sEditDelete - Q3
It is a collection of entities
Entity Type
Entity Instances
Attributes
Relationship
30sEditDelete - 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.
30sEditDelete - 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?
30sEditDelete - Q6
It is an attribute or a combination of attributes that uniquely identifies individual instances of an entity type.
Users enter free textType an Answer30sEditDelete - 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
30sEditDelete - 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
30sEditDelete - 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
30sEditDelete - 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
30sEditDelete - 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
30sEditDelete - 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)
30sEditDelete - 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 Answer30sEditDelete - 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
30sEditDelete - 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
30sEditDelete - Q16
It refers to the number of participating entity types in the relationship
Ternary Relationship
Relationsip Instances
Degree
Cardinality
30sEditDelete - Q17
These are entity types that are dependent on a strong entity type.
Users enter free textType an Answer30sEditDelete - Q18
A student may read any number of book. A book may be read by any number of students. What is the cardinality of the relationship between books and student?
Many to Many
One to Many
One to One
Many to One
30sEditDelete - Q19
A student may read any number of book. A book may be read by any number of students. What is the degree of the relationship between books and student?
Users enter free textType an Answer30sEditDelete - Q20
A student may read any number of book. A book may be read by any number of students. Which ER Model best represents this relationship?
30sEditDelete
