Business Rules in Database Management
10 Questions
2 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is a good characteristic of a business rule?

  • Redundant–repetitive and unnecessary
  • Declarative–how, not what
  • Consistent–internally but not externally (correct)
  • Vague–unclear, ambiguous meaning
  • What is a good characteristic of a data name?

  • Unrelated to business–only technical characteristics (correct)
  • Readable–complex and difficult to understand
  • Non-unique–can be repeated
  • Technical–related to technical characteristics
  • What corresponds to a row in a table in the E-R model?

  • Attribute symbols
  • Entity instance (correct)
  • Relationship instance
  • Entity Type
  • What is specified by relationship cardinalities in the E-R model?

    <p>Number of entity instances involved</p> Signup and view all the answers

    What should an entity be according to the E-R model constructs?

    <p>It should be an entity type</p> Signup and view all the answers

    What is an entity in the context of database modeling?

    <p>An object that will be composed of multiple attributes</p> Signup and view all the answers

    Which of the following is not a classification of attributes in database modeling?

    <p>An attribute that could be a key…satisfies the requirements for being an identifier</p> Signup and view all the answers

    What is an identifier (key) in the context of database modeling?

    <p>An attribute that uniquely identifies individual instances of an entity type</p> Signup and view all the answers

    What is a composite attribute in database modeling?

    <p>An attribute broken into component parts</p> Signup and view all the answers

    In database modeling, what do intelligent identifiers refer to?

    <p>Containing locations or people that might change</p> Signup and view all the answers

    More Like This

    Business Rules and DBMS Quiz
    0 questions
    Business Rules in Data Design
    12 questions
    Data Models Quiz
    13 questions

    Data Models Quiz

    NimbleBerkelium avatar
    NimbleBerkelium
    Use Quizgecko on...
    Browser
    Browser