placeholder image to represent content

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 skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • 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

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
30 questions
Show answers
  • Q1

    These are statements that define or constrainsome aspect of the business.

    Users enter free text
    Type an Answer
    30s
  • 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?

    Answer Image
    Answer Image
    Answer Image
    Answer Image
    Answer Image
    Answer Image
    30s
  • Q6

    It is an attribute or a combination of attributes that uniquely identifies individual instances of an entity type.

    Users enter free text
    Type an Answer
    30s
  • 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 text
    Type an Answer
    30s
  • 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

Teachers give this quiz to your class