Informative Quiz On Database Management.

13 Questions | Total Attempts: 63

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

At the end of the course you should be able to create relational databases, write SQL statements to extract information to satisfy business-reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. Test how much you understood about Database Management by taking the quiz below.


Related Topics
Questions and Answers
  • 1. 
    What is known as a graphical technique for portraying a data base schema?
    • A. 

      Data modeling

    • B. 

      System Analysis

    • C. 

      Entity- relationship diagram

    • D. 

      DBMS

  • 2. 
    An ________ is anything about which the organization wants to collect and store information.
  • 3. 
    One of the basic type of Entities that have economic value to the organization is called a ?
    • A. 

      Agents

    • B. 

      Event

    • C. 

      Resource

    • D. 

      Diagram Variation

  • 4. 
    One of the basic types of Entities represent the people and organiations that participate in events and about whom information is desired for planning, control, and evaluation purposes. 
    • A. 

      Events

    • B. 

      Resources

    • C. 

      Agents

    • D. 

      Attribute

  • 5. 
    _______ are the various business activities about which management wants to collect information for planning or control purposes.
  • 6. 
    Every event entity must be linked to at least
    • A. 

      One resource entity, one other event entity , and at least two participating agents

    • B. 

      One event entity and at least two participating agents

    • C. 

      Two event entities and at least one participating agent

  • 7. 
    Accounts receivable would appear in an REA diagram as a example of which kind of entity?
    • A. 

      Resource

    • B. 

      Event

    • C. 

      Agent

    • D. 

      None

  • 8. 
    Which of the following is not likely to be depicted as an entity in the REA data model?
    • A. 

      Customers

    • B. 

      Invoices

    • C. 

      Sales

    • D. 

      Delivery trucks

  • 9. 
    In most cases, the relationship between agent entities and event entities is
    • A. 

      1:1

    • B. 

      1:N

    • C. 

      M:N

    • D. 

      0:N

  • 10. 
    Which of the following most accurately models the sales of low cost, mass produced items by a retail store.
    • A. 

      Sales = 0 to many inventory and inventory equals one to many sales

    • B. 

      Sale= 0 to many inventory and inventory equals 0 to many sales

    • C. 

      Sale= 1 to many inventory and inventory equals 0 to many sales

    • D. 

      Sale = o to many inventory and inventory equals 1 to many sales

  • 11. 
    Data modeling occurs during which stages of database design?
    • A. 

      System analysis and physical design

    • B. 

      System analysis and conceptual design

    • C. 

      Conceptual design and implementation and conversion

    • D. 

      Phsical design and implementation and conversion

  • 12. 
    Which of the following statements about the REA data model is true
    • A. 

      Every event must be linked to at least 2 agents

    • B. 

      Every resource must be linked to at least two agents

    • C. 

      Every agent must be linked to at least two events