Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Provide PL/SQL Stored procedure TPC R benchmark database LINEITEM L_QUANTITY L_EXTENDEDPRICE L_DISCOUNT L_TAX L_RETURNFLAG L_LINESTATUS L_SHIPDATE L_COMMITDATE L_RECEIPTDATE L_SHIPINSTRUCT L_SHIPMODE L_COMMENT 0..1 A Contains L_LINENUMBER

Provide PL/SQL Stored procedure

TPC R benchmark database LINEITEM L_QUANTITY L_EXTENDEDPRICE L_DISCOUNT L_TAX L_RETURNFLAG L_LINESTATUS Task 2 (5.0 marks) Stored PL/SQL procedure Implement a stored PL/SQL procedure PARTSUPPLIER that lists 

TPC R benchmark database LINEITEM L_QUANTITY L_EXTENDEDPRICE L_DISCOUNT L_TAX L_RETURNFLAG L_LINESTATUS L_SHIPDATE L_COMMITDATE L_RECEIPTDATE L_SHIPINSTRUCT L_SHIPMODE L_COMMENT 0..1 A Contains L_LINENUMBER ORDERS O ORDERKEY ID O_ORDERSTATUS O_TOTALPRICE O_ORDERDATE O_ORDERPRIORITY O_CLERK O_SHIPPRIORITY O_COMMENT 1..* A Submits CUSTOMER C_CUSTKEY ID C_NAME C_ADDRESS C_PHONE C_ACCTBAL C_MKTSEGMENT C_COMMENT Includes Belongs-to PART-SHIIPPED-BY PS_AVAILQTY PS SUPPLYCOST PS_COMMENT PART P_PARTKEY ID P_NAME P_MFGR P_BRAND P_TYPE P_SIZE P_CONTAINER P_RETAILPRICE P COMMENT Supplies SUPPLIER S_SUPPKEY ID S_NAME S_ADDRESS S_PHONE S_ACCTBAL S_COMMENT 1..* Belongs-to NATION N_NATIONKEY ID N_NAME N_COMMENT Is-in REGION R_REGIONKEY ID R_NAME R_COMMENT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Based on the provided information and the TPC R benchmark database schema youre asked to create a PLSQL stored procedure named PARTSUPPLIER that takes ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information System

Authors: James A. Hall

7th Edition

978-1439078570, 1439078572

More Books

Students also viewed these Databases questions

Question

Discuss the advantages of activity-based costing.

Answered: 1 week ago