Chapter5- Data Modelling and Design (Hard)
30 Questions
1 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

Which category refers to the time interval of interest to the enterprise?

  • Where
  • Person or organization
  • What
  • When (correct)

    • Which category refers to the location of interest to the enterprise?

  • What
  • Person or organization
  • When
  • Where (correct)

    • What is the term used to represent an occurrence or value of a particular entity?

  • Entity Type
  • Entity
  • Entity Instance (correct)
  • Entity Alias

    • In data models, how are entities typically depicted?

    <p>Rectangles (A)</p> Signup and view all the answers

    Which term is often used in relational schemes to refer to a relationship?

    <p>Association (B)</p> Signup and view all the answers

    What is the purpose of cardinality in a relationship?

    <p>To specify the number of entities participating in the relationship (B)</p> Signup and view all the answers

    What is the arity of a relationship?

    <p>The number of entities involved in the relationship (D)</p> Signup and view all the answers

    In relational modeling, where are child entities typically placed in a recursive relationship?

    <p>On the many side of the relationship (A)</p> Signup and view all the answers

    Which of the following is NOT one of the six most commonly used data modeling schemes?

    <p>Structured (B)</p> Signup and view all the answers

    What are the three levels of detail at which data models exist?

    <p>Conceptual, Logical, Physical (B)</p> Signup and view all the answers

    What is the goal of data modeling and design?

    <p>To create a foundation for data governance programs (C)</p> Signup and view all the answers

    What are some examples of components in a data model?

    <p>Entities, Relationships, Facts, Attributes (A)</p> Signup and view all the answers

    Which one of the following is NOT one of the four main types of data that can be modeled?

    <p>Detail transaction information (B)</p> Signup and view all the answers

    What is the main purpose of data modeling?

    <p>To understand organizational data (D)</p> Signup and view all the answers

    What are the basic building blocks of most data models?

    <p>Entities, relationships, attributes, and domains (A)</p> Signup and view all the answers

    What is the definition of an entity in data modeling?

    <p>A thing about which an organization collects information (B)</p> Signup and view all the answers

    Which of the following is an example of a binary relationship in a data model?

    <p>Figure 34 (C)</p> Signup and view all the answers

    In a data model, what is a foreign key used for?

    <p>To represent a relationship between two entities (B)</p> Signup and view all the answers

    What is the difference between a simple key and a surrogate key?

    <p>A simple key is visible to end users, while a surrogate key is not (C)</p> Signup and view all the answers

    Which of the following is an example of a compound key in a data model?

    <p>Universal Product Code (UPC) (B)</p> Signup and view all the answers

    Which of the following is NOT a goal of data modeling?

    <p>To provide the starting point for customization, integration, or replacement of an application (D)</p> Signup and view all the answers

    What is the purpose of data models in data management?

    <p>To provide a common vocabulary around data (B)</p> Signup and view all the answers

    What does a data model help explain?

    <p>All of the above (D)</p> Signup and view all the answers

    What is the role of a data model in data understanding?

    <p>All of the above (D)</p> Signup and view all the answers

    Which of the following is an example of a candidate key for a customer entity?

    <p>Email address (D)</p> Signup and view all the answers

    What is the difference between a super key and a candidate key?

    <p>A super key is any set of attributes that uniquely identify an entity instance, while a candidate key is a minimal set of one or more attributes that identifies the entity instance to which it belongs. (B)</p> Signup and view all the answers

    What is a primary key?

    <p>A surrogate key that uniquely identifies an entity instance. (D)</p> Signup and view all the answers

    What is an alternate key?

    <p>A candidate key that was not chosen as the unique identifier for an entity. (B)</p> Signup and view all the answers

    What is the difference between a business key and a surrogate key?

    <p>A business key is one or more attributes that a business professional would use to retrieve a single entity instance, while a surrogate key is a candidate key that is chosen to be the unique identifier for an entity. (B)</p> Signup and view all the answers

    Can an entity have multiple candidate keys?

    <p>Yes, an entity can have multiple candidate keys. (B)</p> Signup and view all the answers

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser