Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2
Q: 1 Create a table Employee with fields EmpNo Number (6) Primary key Name Character (25) Designation Character (20) Department Character (25) BasicPay Number (8, 2) DA Number (8, 2) Total Number (8, 2) SQL> CREATE TABLE EMPLOYEE( 2 EMPNO NUMBER(6) PRIMARY KEY, 3 NAME CHARACTER(25), 4 DESIGNATION CHARACTER(20), 5 DEPARTMENT CHARACTER(25), 6 BASICPAY NUMBER(8,2), 7 DA NUMBER(8,2), 8 TOTAL NUMBER(8,2)); Table created.