Question: Write the following database update transactions using either PRO*C or JAVA/JDBC or PHP or some other programming language or scripting language. 3.1 The first transaction

Write the following database update transactions using either PRO*C or JAVA/JDBC or PHP or some other programming language or scripting language. 3.1 The first transaction is to add information about a new CUSTOMER. 3.2 The second transaction is to add all the information about a new ITEM. 3.3 The third transaction is to add all the information about a new ORDER (this must find an available item). 3.4 The fourth transaction is to show the details of an ordered item (by orderlD). 3.5 The fifth transaction is to return a list of purchased items by specific customer (customerlD) 3.6 The sixth transaction is to return the total purchased amount for each type (e.g. BOOK) by all customers on specific date (OrderDate). adding 10% to all). order?!) 3.7 The seventh transaction is to update a type of item (e.g. update the price of all Books by 3.8 The eighth transaction is to delete a CUSTOMER (What if a customer has at least one Write the following database update transactions using either PRO*C or JAVA/JDBC or PHP or some other programming language or scripting language. 3.1 The first transaction is to add information about a new CUSTOMER. 3.2 The second transaction is to add all the information about a new ITEM. 3.3 The third transaction is to add all the information about a new ORDER (this must find an available item). 3.4 The fourth transaction is to show the details of an ordered item (by orderlD). 3.5 The fifth transaction is to return a list of purchased items by specific customer (customerlD) 3.6 The sixth transaction is to return the total purchased amount for each type (e.g. BOOK) by all customers on specific date (OrderDate). adding 10% to all). order?!) 3.7 The seventh transaction is to update a type of item (e.g. update the price of all Books by 3.8 The eighth transaction is to delete a CUSTOMER (What if a customer has at least one
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
