Design an E-R diagram for keeping track of the exploits of your favorite sports team. You should store the matches played, the scores in each match, the players in each match and individual player statistics for each match. Summary statistics ...

Consider the following Data Base schema Employee (Eno, EName, Salary, Dno, Mgr_Eno) Department (Dno, DName)  Project (Pno, Pname, Dno)   Write the following queries in SQL: Display the name of all the employees along with the name of their managers.

Illustrate with example how can you apply the following command in SQL  Order by In operator Like Operator