a. Identify the business rules (types of relationships) represented in the following ERD. b. Convert the following ERD into relational schema. It should include the relation names, attribute names, primary keys and foreign keys. CUSTOMER LINE INVOICE INV NUMBER PK CUS CODE generates PK X contains PK,FK1 PK INV NUMBER LINE NUMBER CUS LNAME FK1 CUS CODE INV_DATE CUS FNAME FK2 P_CODE CUS INITIAL LINE UNITS CUS AREACODE CUS PHONE LINE PRICE CUS BALANCE O is found in I # VENDOR PRODUCT PK Y CODE PK P CODE V_NAME V_CONTACT HE HH-Supplies V AREACODE V PHONE V STATE V ORDER X P_DESCRIPT P INDATE P QOH P MIN P PRICE P_DISCOUNT FK1 V CODE
a. Identify the business rules (types of relationships) represented in the following ERD. b. Convert the following ERD into relational schema. It should include the relation names, attribute names, primary keys and foreign keys. CUSTOMER LINE INVOICE INV NUMBER PK CUS CODE generates PK X contains PK,FK1 PK INV NUMBER LINE NUMBER CUS LNAME FK1 CUS CODE INV_DATE CUS FNAME FK2 P_CODE CUS INITIAL LINE UNITS CUS AREACODE CUS PHONE LINE PRICE CUS BALANCE O is found in I # VENDOR PRODUCT PK Y CODE PK P CODE V_NAME V_CONTACT HE HH-Supplies V AREACODE V PHONE V STATE V ORDER X P_DESCRIPT P INDATE P QOH P MIN P PRICE P_DISCOUNT FK1 V CODE
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter2: Data Models
Section: Chapter Questions
Problem 11P
Related questions
Question
Transcribed Image Text:a. Identify the business rules (types of relationships) represented in the following ERD.
b. Convert the following ERD into relational schema. It should include the relation names, attribute names, primary keys and foreign keys.
CUSTOMER
INVOICE
LINE
PK CUS CODE
generales
contains
PK
FK1
INV NUMBER
CUS CODE
INV DATE
PK,FK1 INV NUMBER
PK LINE NUMBER
CUS_LNAME
FK2
P CODE
CUS_FNAME
CUS INITIAL
CUS AREACODE
LINE UNITS
LINE_PRICE
CUS PHONE
CUS BALANCE
8
is found in
±
VENDOR
PRODUCT
PKY CODE
P_CODE
V_NAME
V CONTACT - Supplies
HE
P_DESCRIPT
P_INDATE
V AREACODE
P QOH
V PHONE
P MIN
V_STATE
P PRICE
V_ORDER
P_DISCOUNT
x
PK
FK1 V CODE
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
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.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
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
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
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
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning