Question

consider the following entities and their relationship. create a RDB in 3 NF with appropriate data types and constraints

Emp(eno ,ename , designation ,salary , date_of_joining)

Dept(dno,dname,1oc)

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 table 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'​

Answer 1

Answer:

I don't know

Explanation:

go to your book chapter