Entity Relationship Diagrams and Data Modeling Quiz
18 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

Which of the following diagrams represents the logical elements of a system but does not depict the physical system?

  • System flowchart
  • Program flowchart
  • Entity relationship (ER) diagram
  • Data flow diagram (DFD) (correct)

What is the purpose of an entity relationship (ER) diagram?

  • To represent the relationship between business entities (correct)
  • To depict the physical components of a system
  • To document the data flows in a system
  • To model the processes of a system

What does the term 'cardinality' refer to in the context of entity relationship diagrams?

  • The type of relationship between entities
  • The degree of complexity of the diagram
  • The number of entities in the diagram
  • The numeric mapping between entities (correct)

Which of the following statements is true about data flow diagrams (DFDs) and entity relationship (ER) diagrams?

<p>DFDs model system processes, while ER diagrams model system data (A)</p> Signup and view all the answers

Which version of the entity relationship (ER) model is widely used in accounting information systems (AIS)?

<p>The REA model (C)</p> Signup and view all the answers

Which of the following is NOT a component represented in a data flow diagram (DFD)?

<p>Entity Relationship Diagrams (D)</p> Signup and view all the answers

What is the purpose of a data model in the context of database design?

<p>To serve as a blueprint for the physical database (B)</p> Signup and view all the answers

In an entity relationship (ER) diagram, the cardinality of a relationship between two entities indicates the:

<p>Minimum and maximum number of instances of one entity that can be associated with each instance of the other entity (B)</p> Signup and view all the answers

Which of the following documentation techniques uses symbols to represent the flow of data and control through a system?

<p>Data Flow Diagram (D)</p> Signup and view all the answers

The REA (Resources, Events, Agents) model is a conceptual framework for modeling:

<p>Business processes and accounting information systems (C)</p> Signup and view all the answers

Which of the following is a problem associated with the flat-file approach to data management?

<p>Increased data redundancy (B)</p> Signup and view all the answers

Which of the following is NOT a benefit of using digital record audit trails compared to hard-copy document audit trails?

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

What do resources, events, and agents represent in the REA model?

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

In the context of ER diagrams, what does cardinality refer to?

<p>Numerical mapping between entities (A)</p> Signup and view all the answers

How is a DFD different from an ER diagram?

<p>ER diagram models data and DFD models processes (B)</p> Signup and view all the answers

Which documentation technique reveals the internal structure of digital records in a database table?

<p>Record layout diagrams (B)</p> Signup and view all the answers

What does the CARDINALITY term 'one-to-many' signify in an ER diagram?

<p>Each entity is connected to many entities of another type (D)</p> Signup and view all the answers

What does a Document flowchart represent if a manual system is involved?

<p>Processing of a single transaction (A)</p> Signup and view all the answers

More Like This

Use Quizgecko on...
Browser
Browser