This diagram shows the entities and entity relationships. The diagram is used to model data after normalization steps are completed. What is the diagram called?ORDERorderid (PK)orderDatecustomerNo (FK)1..*makes1..1hasUse-case diagramPert/CPM chartER ModelFlowchart1..11..*ORDER DETAILorderidorderitemNoproductNo (FK)qtyCUSTOMERcustomerNo (PK)nameaddresscontact No1..1has ►1..*PRODUCTproductNo (PK)prodtypedescriptionskupriceqtyonHand

Answered: This diagram shows the entities and…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

This diagram shows the entities and entity relationships. The diagram is used to model data after normalization steps are completed. What is the diagram called?
ORDER
orderid (PK)
orderDate
customerNo (FK)
1..*
makes
1..1
has
Use-case diagram
Pert/CPM chart
ER Model
Flowchart
1..1
1..*
ORDER DETAIL
orderid
orderitemNo
productNo (FK)
qty
CUSTOMER
customerNo (PK)
name
address
contact No
1..1
has ►
1..*
PRODUCT
productNo (PK)
prodtype
description
sku
price
qtyonHand

Expert Solution

Step 1

Entity Relationship Model, or ER Model, is a high-level conceptual data model diagram. To create a well-designed database, rigorous analysis of the data needs is assisted by the ER model. The ER Model depicts actual people, things, and the connections between them. Before deploying your database, it is recommended that you create an ER Model in a DBMS.

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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