Sv Bala

 <COMPANY>     <EMPLOYEE>         <EMPNO>121</EMPNO>         <EMPNAME>SEGAR</EMPNAME>         <POSITION>MANAGER</POSITION>     </EMPLOYEE>     <EMPLOYEE>         <EMPNO>122</EMPNO>         <EMPNAME>MUKESH</EMPNAME>         <POSITION>OFFICE</POSITION>     </EMPLOYEE>     <EMPLOYEE>         <EMPNO>123</EMPNO>         <EMPNAME>ARUL</EMPNAME>         <POSITION>PUNE</POSITION>     </EMPLOYEE> </COMPANY> CREATE TABLE MYTABLE (     EMPNO INT NOT NULL,     EMPNAME VARCHAR(45) NULL,     POSITION VARCHAR(45) NULL,     PRIMARY KEY (EMPNO) ); LOAD XML INFILE 'D:/Seg...

 CREATE DATABASE BANKMG1; USE BANKMG1; CREATE TABLE customer_details (   cid INT PRIMARY KEY,   cname VARCHAR(50),   balance DECIMAL(10, 2) ); CREATE TABLE transaction (   tid INT PRIMARY KEY AUTO_INCREMENT,   cid INT,   transaction_type ENUM('credit', 'debit'),   amount DECIMAL(10, 2),   FOREIGN KEY (cid) REFERENCES customer_details(cid) ); DROP TABLE TRANSACTION; -- Insert values into customer_details table INSERT INTO customer_details (cid, cname, balance) VALUES (1, 'John Doe', 5000.00),        (2, 'Jane Smith', 10000.00),        (3, 'Mike Johnson', 7500.00),        (4,'Segar',100000.00); -- Assertions ALTER TABLE transaction ADD CONSTRAINT check_debit_amount CHECK (transaction_type = 'credit' OR (transaction_type = 'debit' AND amount < 10000)); -- ALTER TABLE CUSTOMER_DETAILS ADD CONSTRAINT debit_below_zero CHECK (BALANCE - transaction.amount > 0); -- Trigger  DELIMIT...