CIS 130 Quiz 4

35 Questions | Total Attempts: 577

SettingsSettingsSettings
CIS Quizzes & Trivia


Questions and Answers
  • 1. 
    A data model is a:
    • A. 

      The mathematical model of formulas and logic used in a system

    • B. 

      The abstract creating of an ideal system transformation

    • C. 

      The model that is produced by extreme programming

    • D. 

      The expanded, thoroughly balanced and normalized use case for a system

    • E. 

      A formal way of representing the data that are used and created by a business system

  • 2. 
    A data model can __________
    • A. 

      Illustrate return-on-investment, break-even point, and economic feasibility

    • B. 

      Represent actions or processes that occur in the to-be system

    • C. 

      Be used as a logical data model in analysis and as a physical data model in design

    • D. 

      Only be used with Document analysis

    • E. 

      Only be used with JAD sessions

  • 3. 
    Which of the following is NOT illustrated by a data model?
    • A. 

      People

    • B. 

      Places

    • C. 

      Things

    • D. 

      Actions

  • 4. 
    ERD is an acronym for
    • A. 

      Enterprise Relationship Diagramming

    • B. 

      Entity Relationship Diagramming

    • C. 

      Electronic Repository Diagramming

    • D. 

      Enhanced Relationship Diagramming

    • E. 

      Entity Repository Design

  • 5. 
    An analyst can read an ERD to
    • A. 

      Discover the individual pieces of information in a system and how they are organized and related to each other

    • B. 

      Find what processes use what data

    • C. 

      Determine the cardinality of processes in a system and if the modality of process is 1:M; 1:1; or M:N

    • D. 

      Evaluate data structure hierarchies as to processing anomalies in a business system

    • E. 

      Discover how the people, places and things in a business system are generated, moved, transformed and stored

  • 6. 
    Which of the following is NOT true about ERDs?
    • A. 

      Special symbols are added to show high-level business rules

    • B. 

      The diagrams are drawn in a sequential order – from top to bottom

    • C. 

      Similar kinds of information are listed together in entities

    • D. 

      ERD's are data modeling techniques

    • E. 

      Lines are drawn to show relationships among the data

  • 7. 
    Which is NOT an element of an Entity Relationship Diagram?
    • A. 

      Cardinality

    • B. 

      Modality

    • C. 

      Attribute

    • D. 

      Relationship

    • E. 

      Data stores

  • 8. 
    Which would NOT likely be an attribute of an entity called “Student”?
    • A. 

      Age

    • B. 

      Student identification number

    • C. 

      Class room number

    • D. 

      Home phone

    • E. 

      Gender

  • 9. 
    Which would NOT likely be an entity on a car insurance ERD?
    • A. 

      Customer

    • B. 

      Policy

    • C. 

      Agent

    • D. 

      Zip code

    • E. 

      Car

  • 10. 
    Modality refers to
    • A. 

      Relationships of one-to-one; one-to-many; or many-to-many

    • B. 

      Whether a child entity can exist with or without a related instance in the parent entity

    • C. 

      The hierarchical structure that was developed in process models applied to data models

    • D. 

      The number of attributes generated by an entity

    • E. 

      Whether the entity has a unique identifier or a concatenated identifier

  • 11. 
    CASE tools have a(n) __________________ where information about entities, attributes and relationships on the ERD are stored.
    • A. 

      Information space

    • B. 

      Data store

    • C. 

      Meta file

    • D. 

      Data flow

    • E. 

      Data dictionary

  • 12. 
    Information in the data dictionary is called:
    • A. 

      Metadata

    • B. 

      Cached information

    • C. 

      Compiled data

    • D. 

      Data repository

    • E. 

      File silo

  • 13. 
    Mike is drawing an ERD diagram.  He has a one-to-many relationship.  To identify the end of the relationship for the main relationship, Mike should draw:
    • A. 

      An oval

    • B. 

      A crow's foot

    • C. 

      The letter M

    • D. 

      An infinity symbol

    • E. 

      A diamond

  • 14. 
    The three major parts of an ERD diagram are:
    • A. 

      Process, data flow, data store

    • B. 

      Attribute, modularity, cardinality

    • C. 

      Relationship, data flow, entity

    • D. 

      Relationship, attribute, entity

    • E. 

      Process, entity and relationship

  • 15. 
    What is true about creating an entity relationship diagram?
    • A. 

      There will be at most seven entities

    • B. 

      There will be at most seven relationships

    • C. 

      If you identify more than seven entities, analyze and combine until you have seven or less

    • D. 

      It is an iterative process

    • E. 

      Entities will have at most seven attributes

  • 16. 
    In adding attributes to an ERD, which of the following might NOT be a good resource for attributes?
    • A. 

      From the CASE tool

    • B. 

      Data flows from DFD's

    • C. 

      Requirements documents

    • D. 

      The system proposal document

    • E. 

      Through interviews (what users need for reports and processing)

  • 17. 
    The last step in creating basic ERD’s is to:
    • A. 

      Identify relationships

    • B. 

      Define attributes and assign identifiers

    • C. 

      Recognize entities

    • D. 

      Test them with users

    • E. 

      Compile them with Java

  • 18. 
    The first step to building an Entity Relationship Diagram is to
    • A. 

      Identify data flows from the level 0 DFD diagram

    • B. 

      Draw the relationships between the entities

    • C. 

      Identify the attributes for each entity

    • D. 

      Identify the entities

    • E. 

      Identify the processes, data flows and data stores

  • 19. 
    When normalizing data models, if you take attributes that have multiple values for a single instance of an entity and create separate entities for those attributes you are moving from:
    • A. 

      0 normal form to 1st normal form (1NF)

    • B. 

      1st normal form (1NF) to 2nd normal form (2NF)

    • C. 

      3rd normal form (2NF) to 3rd normal form (3NF)

    • D. 

      Generalized normal form (GNF) to fully normalized form (FNF)

    • E. 

      Dependent normal form (DNF) to Independent normal form (INF)

  • 20. 
    Independent entities are:
    • A. 

      When a child requires attributes from the parent

    • B. 

      When there is only one entity for a data process model

    • C. 

      When an entity can exist without the help of another entity

    • D. 

      Where the entity identifier is also the primary key

    • E. 

      When a entity comes from an external source (external entity)

  • 21. 
    A(n) _____ entity cannot exist without the presence of another entity and is normally on the “many” end of a relationship or has an identifier that is based on another entity’s attribute.
    • A. 

      Independent

    • B. 

      Incomplete

    • C. 

      Dependent

    • D. 

      Variable

    • E. 

      Non-complying

  • 22. 
    When the analyst is evaluating a data model to ensure that all fields in a record depend fully on the entire primary key, which step of normalization is being performed?
    • A. 

      Base normal form

    • B. 

      First normal form

    • C. 

      Second normal form

    • D. 

      Third normal form

    • E. 

      Cannot tell from the above information

  • 23. 
    Data models can be either logical or physical
    • A. 

      True

    • B. 

      False

  • 24. 
    The data that are used and created by a business system are illustrated by a process model.
    • A. 

      True

    • B. 

      False

  • 25. 
    Logical data models are most commonly drawn with the Data Flow Diagram technique
    • A. 

      True

    • B. 

      False

Back to Top Back to top