Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Q6. Now, the manager wants you to delete the 'Northwoods Cranberry Sauce' product from the database but keep all the related records. Can you delete it? Why/Why not? What would b your solution?

Q6. Now, the manager wants you to delete the 'Northwoods Cranberry Sauce' product from the database but keep all the related records. Can you delete it? Why/Why not? What would b your solution?

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
SALESREP PK SLSREP_NUM PK CUST NUM CUSTOMER CUST_LNAME CUST_FNAME CUST_AREACODE CUST_PHONE CUST_E-MAIL FK2 CUST_SHIP_ADDRESS CUST_SHIP_CITY CUST_SHIP_STATE CUST_ZIP_CODE INVOICE PK INV_NUM SLSREP_LNAME-It writes OFK1 CUST_NUM FK2 SLSREP_NUM SLSREP_FNAME SLSREP INITIAL INV_DATE SLSREP_EMAIL INV_SUBTOTAL PK,FK1 PK 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 I supplies I PRODUCT PROD_CODE PK 0 is written in +1-FK1 VEND_CODE PROD_DESCRIPTION PROD_PRICE PROD_QOH
Transcribed Image Text:SALESREP PK SLSREP_NUM PK CUST NUM CUSTOMER CUST_LNAME CUST_FNAME CUST_AREACODE CUST_PHONE CUST_E-MAIL FK2 CUST_SHIP_ADDRESS CUST_SHIP_CITY CUST_SHIP_STATE CUST_ZIP_CODE INVOICE PK INV_NUM SLSREP_LNAME-It writes OFK1 CUST_NUM FK2 SLSREP_NUM SLSREP_FNAME SLSREP INITIAL INV_DATE SLSREP_EMAIL INV_SUBTOTAL PK,FK1 PK 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 I supplies I PRODUCT PROD_CODE PK 0 is written in +1-FK1 VEND_CODE PROD_DESCRIPTION PROD_PRICE PROD_QOH
Q6. Now, the manager wants you to delete the 'Northwoods Cranberry Sauce' product from the database but keep all the related records. Can you delete it? Why/Why not? What would be your solution?
Transcribed Image Text:Q6. Now, the manager wants you to delete the 'Northwoods Cranberry Sauce' product from the database but keep all the related records. Can you delete it? Why/Why not? What would be your solution?
Expert Solution
Step 1

Given:

Now, the manager wants you to delete the 'Northwoods Cranberry Sauce' product from the database but keep all the related records. Can you delete it? Why/Why not? What would be your solution?

steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS