emp_details (emp_no(PK)emp_name, DOB, address, doj, mobile_no, dept_no(FK), salary). Create a view on dept_details relation. ( | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

emp_details (emp_no(PK)emp_name, DOB, address, doj, mobile_no, dept_no(FK), salary). Create a view on dept_details relation. (

Any one know answer this question

7th Jan 2021, 5:46 AM
Kumaravel.g
Kumaravel.g - avatar
3 Answers
0
1st Apr 2022, 4:09 PM
g yaswanth
0
Please give me answer
17th Nov 2022, 6:27 PM
Villen Devil
Villen Devil - avatar
- 2
A "view" it's like a DB stored select statement. So, it's not clear which records you need to extract: from the emp_details table in an inner join with dept_details or just from the dept_details table?
11th Jan 2021, 12:44 AM
Vasile Eftodii
Vasile Eftodii - avatar