BuyFind

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
BuyFind

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Solutions

Chapter
Section
Chapter 2, Problem 6RQ
Textbook Problem
444 views

Consider the scenario described by the statement “A customer can make many payments, but each payment is made by only one customer.” Use this scenario as the basis for an entity relationship diagram (ERD) representation.

Expert Solution
Program Plan Intro

Entity Relationship Diagram (ERD):

Entity relationship diagram is a basically a picture or snapshot about the business system. It means that the information stored and created is represented by this diagram.

  • Entities may represent the physical object, event, or concept.
  • An attribute is a property of an entity.
  • Relationship denotes the link between the entities.
    • If an independent child entity is present in a relationship then it is called a non-identifying relationship.
    • If a dependent child entity is present in a relationship then it is called a identifying relationship.

Explanation of Solution

  • The Scenario “A customer can make many payments, but each payment is made only by one customer” described here depicts a One-to-Many (1:M) relationship.
  • A mapping “R” from “X” to “Y” is one-to-many if each entity in “X” is associated with many entities in “Y” but each entity in “Y” is associated with only one entity in “X”.
  • This relationship can be described by using three ER notations: the original Chen notation, the Crow’s Foot notation, and the Class diagram notation.

Chen Model:

In the above given Chen Model, the connectivity’s is indicated next to each entity box and the relationship “makes” is indicated by the diamond box that is connected to the two entities “Customer” and “Payment” through a relationship line.

Crow’s Foot Model:

Want to see this answer and more?

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

See solution

Chapter 2 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
Ch. 2 - What is a relationship, and what three types of...Ch. 2 - Give an example of each of the three types of...Ch. 2 - What is a table, and what role does it play in the...Ch. 2 - What is a relational diagram? Give an example.Ch. 2 - What is connectivity? (Use a Crows Foot ERD to...Ch. 2 - Describe the Big Data phenomenon.Ch. 2 - What does the term 3 Vs refer to?Ch. 2 - What is Hadoop, and what are its basic components?Ch. 2 - What is sparse data? Give an example.Ch. 2 - What are the basic characteristics of a NoSQL...Ch. 2 - Prob. 21RQCh. 2 - What is logical independence?Ch. 2 - What is physical independence?Ch. 2 - Use the contents of Figure 2.1 to work Problems...Ch. 2 - Use the contents of Figure 2.1 to work Problems 13...Ch. 2 - Use the contents of Figure 2.1 to work Problems 13...Ch. 2 - Using Figure P2.4 as your guide, work Problems 45....Ch. 2 - Using Figure P2.4 as your guide, work Problems 45....Ch. 2 - Using Figure P2.6 as your guide, work Problems 68....Ch. 2 - Using Figure P2.6 as your guide, work Problems 68....Ch. 2 - Using Figure P2.6 as your guide, work Problems 68....Ch. 2 - Typically, a hospital patient receives medications...Ch. 2 - United Broke Artists (UBA) is a broker for...Ch. 2 - Using the ERD from Problem 10, create the...Ch. 2 - Convert the ERD from Problem 10 into a...Ch. 2 - Describe the relationships (identify the business...Ch. 2 - Create a Crows Foot ERD to include the following...Ch. 2 - Write the business rules that are reflected in the...Ch. 2 - Create a Crows Foot ERD for each of the following...Ch. 2 - Write the business rules that are reflected in the...

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions
What does the term 3 Vs refer to?

Database Systems: Design, Implementation, & Management

What are the two basic types of tapping toolholders?

Precision Machining Technology (MindTap Course List)

Your car loan payment extends for six years at 8% interest compounded monthly. After how many months do you pay...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Describe three systems development tools and three development methods.

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

What is necessary before two Bluetooth devices can communicate? (138)

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

What can cause a properly sized electrode holder to overheat?

Welding: Principles and Applications (MindTap Course List)