Create a table called Employee & execute the following | DATABASE MANAGEMENT SYSTEM | MYSQL
/* Watch this vedio in high resolution for more clear understanding (1080p HD recommended)
Create a table called Employee & execute the following.
Employee(EMPNO,ENAME,JOB, MANAGER_NO, SAL, COMMISSION)
1. Create a user and grant all permissions to theuser.
2. Insert the any three records in the employee table contains attributes
EMPNO,ENAME JOB, MANAGER_NO, SAL, COMMISSION and use rollback.
Check the result.
3. Add primary key constraint and not null constraint to the employee table.
4. Insert null values to the employee table and verify the result.
#dbms #mysql #mysql_workbench #vtu #database