Question

Task 2 - Part A Connect to MySQL either through command line interface mysql or graphical user interface MySQL Workbench as user csit115 and execute a script file A3drop.sql and immediately after that the scripts A3create.sql and A3load.sql to refresh the contents of a database csit115. No report is expected from the implementation of the steps listed above. Implement SQL script that performs the following actions. (1) The script finds all cases that violate in a database csit115 the following consistency constraint. "A purchase which is an online purchase should NOT be a walk-in purchase" The script must list the outcomes of verification of the consistency constraint as a single column table with the following messages as the following rows. A purchase with the purchase ID of <insert PurchaseID here> is an online purchase of type <insert Online Type here> and also a walkin purchase of location <insert ShopLocation here > Use a function CONCAT to create the messages above. It is NOT allowed to use more than one SELECT statement to implement this task. Note, that it is NOT your task to eliminate the violations of consistency constraint listed above.

          Task 2 - Part A

Connect to MySQL either through command line interface mysql or graphical user interface
MySQL Workbench as user csit115 and execute a script file A3drop.sql and immediately after
that the scripts A3create.sql and A3load.sql to refresh the contents of a database csit115.
No report is expected from the implementation of the steps listed above.
Implement SQL script that performs the following actions.
(1) The script finds all cases that violate in a database csit115 the following consistency
constraint.
"A purchase which is an online purchase should NOT be a walk-in purchase"
The script must list the outcomes of verification of the consistency constraint as a single column
table with the following messages as the following rows.
A purchase with the purchase ID of <insert PurchaseID here> is an online purchase of type
<insert Online Type here> and also a walkin purchase of location <insert ShopLocation here >
Use a function CONCAT to create the messages above. It is NOT allowed to use more than one
SELECT statement to implement this task.
Note, that it is NOT your task to eliminate the violations of consistency constraint listed above.

Task 2 - Part A

Connect to MySQL either through command line interface mysql or graphical user interface
MySQL Workbench as user csit115 and execute a script file A3drop.sql and immediately after
that the scripts A3create.sql and A3load.sql to refresh the contents of a database csit115.
No report is expected from the implementation of the steps listed above.
Implement SQL script that performs the following actions.
(1) The script finds all cases that violate in a database csit115 the following consistency
constraint.
"A purchase which is an online purchase should NOT be a walk-in purchase"
The script must list the outcomes of verification of the consistency constraint as a single column
table with the following messages as the following rows.
A purchase with the purchase ID of <insert PurchaseID here> is an online purchase of type
<insert Online Type here> and also a walkin purchase of location <insert ShopLocation here >
Use a function CONCAT to create the messages above. It is NOT allowed to use more than one
SELECT statement to implement this task.
Note, that it is NOT your task to eliminate the violations of consistency constraint listed above.

Added by Amanda R.

Question

Please give Ace some feedback