DATABASE SYSTEMS
DATABASE SYSTEMS
13th Edition
ISBN: 9780357095607
Author: Coronel
Publisher: CENGAGE L
bartleby

Concept explainers

Question
100%
Book Icon
Chapter 2, Problem 3P
Program Plan Intro

Crow’s Foot notation:

In the Crow’s Foot model by the three-pronged crow’s foot to exhibit the “many” side relationship.

  • In this notation, “1”is represented as a short line segment.
  • “M” is represented as three-pronged crow’s foot.
  • The relationship name is represented above the relationship line.
  • Consider the following business rule referred in problem2 that describes the relationship between AGENT and CUSTOMER and it is written as follows.
    • One agent can have many customers, but each customer has only one agent.
    • From the above business rule, it is concluded that there exist a 1:M relationship between AGENT and CUSTOMER.
  • The Crow’s Foot ERD for the given business rule is depicted as follows.

DATABASE SYSTEMS, Chapter 2, Problem 3P

Blurred answer
Students have asked these similar questions
Manhattan distance
Aiwhat cost from Oradea to Goal which Eforie us A* Algorithm G(n)+H(n) last what ıs the cost
What is the SELECT statement? give one reference with your answer What is a URL and what is it used for? give one reference with your answer  What is e-mail, and what are its advantages? Give one reference with your answer
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning