Slip 1 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Emp(eno ,ename ,designation ,salary, Date_Of_Joining) Dept(dno,dname ,loc) The relationship between Dept & Emp is one-to-many. Constraints: - Primary Key, ename should not be NULL, salary must be greater than 0. Consider the above tables and Execute the following queries: 1. Add column phone_No into Emp table with data type int. 2. Delete the details of Employee whose designation is ‘Manager’.

Solution: