Question:
The following are the relational schemes of Employee, Project and Assigned-to Employee (Emp#, Emp_name, Profession), Project (Proj#, Proj_name, Chief_Architect), Assigned-to (Proj#, Emp#).
Create appropriate samples of each relation according to the question. Write the following queries in SQL.
(i) Get Emp# of employees working on Project numbered MCS-043.
(ii) Get details of employees working on database projects.
(iii) Finally create an optimal query tree for each query.
, Project...){kind=link}
0 comments:
Post a Comment
Let us know your responses and feedback