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:

9xr7t9c 9uxf9xfu9xfu0icg0c8g

Answer 2

3. Consider the following entities and their relationships. Create a RDB in 3 NF with

appropriate data types and Constraints. [15 Marks]

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’.

Q4. Consider the above database and execute the following queries: [25 Marks]

1. Display the count of employees department wise.

2. Display the name of employee who is ‘Manager’ of “Account Department”.

3. Display the name of department whose location is “Pune” and “Mr. Advait” is

working in it.

4. Display the names of employees whose salary is greater than 50000 and department

is “Quality”.

5. Update Date of joining of employee to ‘15/06/2019’ whose department is ‘computer

science’ and name is “Mr. Roy’.