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 (B)</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 (A)</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 (D)</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 (D)</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 (B)</p> Signup and view all the answers

What is a composite attribute in database modeling?

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

In database modeling, what do intelligent identifiers refer to?

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

More Like This

Business Rules in Data Design
12 questions
Data Models Quiz
13 questions

Data Models Quiz

NimbleBerkelium avatar
NimbleBerkelium
Use Quizgecko on...
Browser
Browser