Experiment No. 11
Q-1> Creat the following table and insert the given value.
Employees:
Emp_id Name
01 Hansen,Ola
02 Svendson, Tova
03 Svendson, Stephen
04 Pettersen, Kari
Orders:
Prod_id Product Emp_id
234 Printer 01
657 Table 03
865 Chair 03
Q-2> Who ordered a product and what did they order.
Q-3> Who ordered a printer.
Q-4> List all the employees and their order if any.
Q-5> List all orders and who has ordered if any.
Subscribe to:
Post Comments (Atom)
-
Practical exam Q No. 1 Q-1> Write a query in sql to create a table employee and department. Employee(empno,ename,deptno,job,hiredate...
-
3.3 Characteristics of Tasks and Interactions The various decomposition techniques described in the previous section allow us to identify ... -
Cloud Computing Lab Lab No. 5 Explore Storage as a service using own Cloud for remote file access using web interfaces. ownClou...
No comments:
Post a Comment