Question

RDB without Constraints:

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

following and answer the queries:

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

Dept(dno,dname ,loc)

The relationship between Dept & Emp is one-to-many.

1. Insert at least five records into the tables.

2. Display the names of employees who are working in “Quality Department”.

3. Display the name of employee who is ‘Manager’ of “Purchase Department”.

4. Display the name of department whose location is “Baramati” and “Mr. Pawar” is

working in it.

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

department is “Qualit​

Answer 1

don't nooooooooooooo ooooooooooooooo sorry

Answer 2

Answer:

Insert at least five records into the table