Question: SQL help Now insert the following record through the view. Can you do it? VENDOR_ID: 150 VENDOR_NAME: 'UK Postal Service' VENDOR_CITY: 'Madison VENDOR_STATE: 'WI' VENDOR_ZIP_CODE:

SQL help

  1. Now insert the following record through the view. Can you do it? VENDOR_ID: 150 VENDOR_NAME: 'UK Postal Service' VENDOR_CITY: 'Madison VENDOR_STATE: 'WI' VENDOR_ZIP_CODE: '53707' DEFAULT_TERMS_ID: 1 DEFAULT_ACCOUNT_NUMBER: 552 Is the record inserted into Vendor table?
  2. Create one more view, the same as before only now add the WITH CHECK OPTION clause. Can you insert the following record?: VENDOR_ID: 151 VENDOR_NAME: Global Postal Service' VENDOR_CITY: 'Madison VENDOR_STATE: 'WI' VENDOR_ZIP_CODE: '53707' DEFAULT_TERMS_ID: 1 DEFAULT_ACCOUNT_NUMBER: 552 Why- Why not?

SQL help Now insert the following record through the view. Can youdo it? VENDOR_ID: 150 VENDOR_NAME: 'UK Postal Service' VENDOR_CITY: 'Madison VENDOR_STATE: 'WI'VENDOR_ZIP_CODE: '53707' DEFAULT_TERMS_ID: 1 DEFAULT_ACCOUNT_NUMBER: 552 Is the record inserted into Vendor

Connections Connections * + - Y O CUSTOMERS CUSTOMER_ID CUSTOMER_FIRST_NAME CUSTOMER_LAST_NAME 1 CUSTOMER_ADDRESS 1 CUSTOMER_CITY CUSTOMER_STATE CUSTOMER_ZIP CUSTOMER_PHONE CUSTOMER_FAX + CUSTOMERSHIP ADDRESS_T + DOESBUSINESSINT + EMPLOYEET + EMPLOYEESKILLS T +- GENERAL_LEDGER_ACCOUNTS + INVOICE_LINE_ITEMS #- INVOICES ITEMS ORDER_DETAILS ORDER_ID ITEM_ID ORDER_QTY --DORDER_T ORDERID CUSTOMERID ORDERDATE FULFILLMENTDATE SALESPERSONID SHIPADRSID # E ORDERLINET # E ORDERS + PAYMENT_T - PAYMENTTYPE_T OD PAYMENT_T PAYMENTID ORDERID PAYMENTTYPEID PAYMENTDATE PAYMENTAMOUNT PAYMENTCOMMENT + PAYMENTTYPE_T + PRODUCEDIN_T PRODUCT_T PRODUCTID IT PRODUCTLINEID PRODUCTDESCRIPTION PRODUCTFINISH PRODUCTSTANDARDPRICE PRODUCTONHAND # PRODUCTLINET # SALESPERSON_T + SKILL_T + TERMS # TERRITORY_T VENDOR_CONTACTS VENDOR_ID LAST_NAME FIRST_NAME BEVENDORS VENDOR_ID VENDOR_NAME VENDOR_ADDRESS1 I VENDOR_ADDRESS2 VENDOR_CITY VENDOR_STATE TRIGLIS QY PRODUCT_T PRODUCTID PRODUCTLINEID PRODUCTDESCRIPTION PRODUCTFINISH PRODUCTSTANDARDPRICE PRODUCTONHAND # - PRODUCTLINE_T # SALESPERSON_T + SKILL_T + TERMS + TERRITORY VENDOR_CONTACTS VENDOR_ID LAST_NAME FIRST_NAME VENDORS VENDOR_ID VENDOR_NAME VENDOR_ADDRESS1 VENDOR_ADDRESS2 VENDOR_CITY VENDOR_STATE VENDOR_ZIP_CODE VENDOR_PHONE VENDOR_CONTACT_LAST_NAME VENDOR_CONTACT_FIRST_NAME DEFAULT_TERMS_ID DEFAULT_ACCOUNT_NUMBER COOPERATING_VENDOR_ID # WORKCENTER_T # WORKSINT # Views Connections + CRY DMS Lab 2 DMS Lab 3 Tables (Filtered) + CUSTOMER_T # CUSTOMERS + CUSTOMERSHIP ADDRESS_T + DOESBUSINESSIN_T + EMPLOYEET # 2 EMPLOYEESKILLST + GENERAL_LEDGER_ACCOUN + INVOICE_LINE_ITEMS # INVOICES + DITEMS # D ORDER_DETAILS + ORDER_T + ORDERLINET + ORDERS + E PAYMENT_T + PAYMENTTYPET + PRODUCEDIN_T + PRODUCT_ # PRODUCTLINET + SALESPERSON_T + SKILLT # TERMS + D TERRITORY # E VENDOR_CONTACTS + E VENDORS # D WORKCENTER_T # WORKSIN_T Views 109 Editioning views

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!