SALESREP PK SLSREP NUM SLSREP_LNAME-It writes SLSREP_FNAME SLSREP INITIAL SLSREP_EMAIL PK CUST NUM CUSTOMER CUST_LNAME CUST_FNAME CUST_AREACODE CUST_PHONE CUST_E-MAIL CUST_SHIP_ADDRESS CUST_SHIP_CITY CUST_SHIP_STATE CUST_ZIP_CODE OFK1 FK2 INVOICE PK INV_NUM PK,FK1 PK FK2 I generates CUST_NUM SLSREP_NUM INV_DATE INV_SUBTOTAL INV_TAX INV_TOTAL F contains INV_LINE INV_NUM INV_LINE NUM PROD_CODE INV_LINE_PRICE INV_LINE_QUANT INV_LINE_TOTAL VENDOR PK VEND_CODE VEND_NAME VEND_CONTACT VEND_EMAIL supplies PRODUCT PK PROD_CODE is written in +1-FK1 VEND_CODE PROD_DESCRIPTION PROD_PRICE PROD_QOH

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
icon
Related questions
Question
Q1. Write the SQL code to create the table structures for the entities shown in the above ERD.
The structures should contain the attributes specified in the ERD. Use data types that are
appropriate for the data that will need to be stored in each attribute. Enforce primary key and
foreign key constraints as indicated by the ERD.
Transcribed Image Text:Q1. Write the SQL code to create the table structures for the entities shown in the above ERD. The structures should contain the attributes specified in the ERD. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD.
SLSREP_FNAME
SLSREP_INITIAL
SLSREP_EMAIL
CUSTOMER
PK CUST NUM
CUST_LNAME
CUST_FNAME
CUST_AREACODE
CUST_PHONE
CUST_E-MAIL
CUST_SHIP_ADDRESS
CUST_SHIP_CITY
CUST_SHIP_STATE
CUST_ZIP_CODE
PK,FK1
PK
FK2
HE
SALESREP
INVOICE
PK SLSREP NUM
PK
INV_NUM
SLSREP_LNAME-It writes OFK1 CUST_NUM
FK2 SLSREP_NUM
INV_DATE
INV_SUBTOTAL
I
generates
INV_TAX
INV_TOTAL
contains
INV_LINE
INV_NUM
INV_LINE_NUM
PROD_CODE
INV_LINE_PRICE
INV_LINE_QUANT
INV_LINE_TOTAL
VENDOR
PK VEND_CODE
VEND_NAME
VEND_CONTACT
VEND_EMAIL
I
supplies
PRODUCT
PK PROD_CODE
is written in +1-FK1 VEND_CODE
PROD_DESCRIPTION
PROD_PRICE
PROD_QOH
Transcribed Image Text:SLSREP_FNAME SLSREP_INITIAL SLSREP_EMAIL CUSTOMER PK CUST NUM CUST_LNAME CUST_FNAME CUST_AREACODE CUST_PHONE CUST_E-MAIL CUST_SHIP_ADDRESS CUST_SHIP_CITY CUST_SHIP_STATE CUST_ZIP_CODE PK,FK1 PK FK2 HE SALESREP INVOICE PK SLSREP NUM PK INV_NUM SLSREP_LNAME-It writes OFK1 CUST_NUM FK2 SLSREP_NUM INV_DATE INV_SUBTOTAL I generates INV_TAX INV_TOTAL contains INV_LINE INV_NUM INV_LINE_NUM PROD_CODE INV_LINE_PRICE INV_LINE_QUANT INV_LINE_TOTAL VENDOR PK VEND_CODE VEND_NAME VEND_CONTACT VEND_EMAIL I supplies PRODUCT PK PROD_CODE is written in +1-FK1 VEND_CODE PROD_DESCRIPTION PROD_PRICE PROD_QOH
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Table
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 System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education