SLSREP_FNAMESLSREP_INITIALSLSREP_EMAILCUSTOMERPK CUST NUMCUST_LNAMECUST_FNAMECUST_AREACODECUST_PHONECUST_E-MAILCUST_SHIP_ADDRESSCUST_SHIP_CITYCUST_SHIP_STATECUST_ZIP_CODEPK,FK1PKFK2HESALESREPINVOICEPK SLSREP NUMPKINV_NUMSLSREP_LNAME-It writes OFK1 CUST_NUMFK2 SLSREP_NUMINV_DATEINV_SUBTOTALIgeneratesINV_TAXINV_TOTALcontainsINV_LINEINV_NUMINV_LINE_NUMPROD_CODEINV_LINE_PRICEINV_LINE_QUANTINV_LINE_TOTALVENDORPK VEND_CODEVEND_NAMEVEND_CONTACTVEND_EMAILIsuppliesPRODUCTPK PROD_CODEis written in +1-FK1 VEND_CODEPROD_DESCRIPTIONPROD_PRICEPROD_QOH Q2. Add INSERT INTO statements to populate your database. Include at least 4 representativetuples in each table.

Answered: SLSREP_FNAME SLSREP_INITIAL…

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

Question

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

Q2. Add INSERT INTO statements to populate your database. Include at least 4 representative
tuples in each table.

Expert Solution

SQL (Structured Query Language)

SQL stands for Structured Query Language. It can be used to create database schema, insert records into the tables created, retrieve the needed records that satisfies the specified condition, update records and delete records.

Syntax of INSERT query

INSERT INTO <tablename>(col1, col2,...coln) VALUES (val1, val2,..., valn);

Step by step

Solved in 3 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