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

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

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!