In this assignment you will focus only on the tasks given below:
- Open the Query Analyzer/SQL server management studio, and perform the below tasks in already created database (Assignment#03). If you did not create a database for assignment#03 then creates a database along with all tables and entity integrity constraints as mentioned in assignment#03 file.
- Insert above rows in each table i.e. Node_info and Protocol_info.
After inserting rows, Perform the below tasks:
- Write an SQL query to apply Right outer join between table Node_Info and Protocol_Info and show the result.
- Write an SQL query to apply inner join between table Node_Info and Protocol_Info and show the result.
- Write an SQL query to apply subquery (nested query) between table Node_Info and Protocol_Info , which shows the following results;
- Take screenshots of your work, and paste them in your solution file (.DOC file).
Hint: You can use aggregate function i.e. max function to perform the 5th task.DOWNLOAD SOLUTION HERE