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
- 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?
- 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?



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
Get step-by-step solutions from verified subject matter experts
