For ALL Questions submit the SQL Query to perform what the question is asking. You can...

 

Transcribed Image Text:

For ALL Questions submit the SQL Query to perform what the question is asking. You can copy and paste your queries in the text box. FACULTY F_ID Fname 102 Amit 103 Nitin 104 Rakshit Rashmi 105 106 Sulekha 107 Niranjan COURSES C_ID F_ID C21 102 C22 106 104 C23 C24 106 C25 102 C26 105 C27 107 FACULTY COURSES C_ID FID C21 102 C22 106 C23 104 F_ID Fname 102 Amit 103 Nitin 104 Rakshit 105 Rashmi 106 Sulekha 107 Niranjan C24 106 C25 102 Question 2 (2.5 points) Listen C26 105 C27 107 Consider the above tables for the questions: Write the SQL statements to create tables Faculty and Courses. F_ID is the primary key in the FACULTY table and C_ID is the primary key for the COURSES table. Make sure to include all other appropriate constraints and insert all the data in the tables. FACULTY Figure C_ID F_ID C21 102 C22 106 C23 104 C24 106 C25 102 C26 105 C27 107 Question 3 (2.5 points) Listen F_ID Fname 102 Amit 103 Nitin 104 Rakshit 105 Rashmi 106 Sulekha 107 COURSES Listen FACULTY COURSES C_ID F_ID C21 102 C22 106 C23 104 C24 106 C25 102 C26 105 C27 107 Consider the above tables for the questions: Display details of those Faculties whose salary is greater than 12000. Hire_date Salary 12-10-1998 12000 24-12-1994 8000 18-5-2001 Malhotra 11-9-2004 Srivastava 5-6-2006 Kumar 26-8-1996 FID Fname 102 Amit 103 Nitin Rakshit 104 105 Rashmi 106 Sulekha 107 Niranjan FACULTY Lname Mishra Cname Grid Computing System Design COURSES Vyas Soni Computer Security Human Biology C21 C_ID F_ID 102 C22 106 C23 104 Computer Network Visual Basic Dreamweaver C24 106 C25 102 C26 105 C27 107 Question 5 (2.5 points) Listen FACULTY COURSES Consider the above tables for the questions: Display the details of courses whose fees is in the range of 15000 to 50000 (both values included). Question 4 (2.5 points) C_ID F_ID C21 102 C22 106 C23 104 an C24 106 C25 Fees 40000 16000 8000 C26 105 C27 107 15000 20000 6000 4000 Lname Hire_date Salary Mishra 12-10-1998 12000 Vyas 24-12-1994 8000 Soni 18-5-2001 14000 Malhotra 11-9-2004 11000 10000 Srivastava 5-6-2006 Kumar 26-8-1996 16000 Cname Grid Computing System Design Computer Security Human Biology Vyas Soni Fees 40000 16000 8000 15000 20000 Computer Network Visual Basic 6000 Dreamweaver 4000 Consider the above tables for the questions Set the fees of all courses so that they are all increased by 500. Lname Hire_date Salary Mishra 12-10-1998 12000 24-12-1994 8000 Malhotra 11-9-2004 18-5-2001 14000 11000 Srivastava 5-6-2006 10000 Kumar 26-8-1996 16000 14000 11000 10000 16000 Cname Fees Grid Computing 40000 16000 System Design Computer Security 8000 Human Biology Computer Network Visual Basic Mishra F_ID Fname 102 Amit 103 Nitin Rakshit Lname Hire_date Salary 12-10-1998 12000 24-12-1994 8000 14000 Vyas Soni 104 18-5-2001 11000 105 Rashmi Sulekha Malhotra 11-9-2004 Srivastava 5-6-2006 107 Niranjan Kumar 26-8-1996 106 10000 16000 15000 20000 6000 Dreamweaver 4000 Lname Hire_date Salary Mishra 12-10-1998 12000 Vyas 24-12-1994 8000 Soni 18-5-2001 Malhotra 11-9-2004 Srivastava 5-6-2006 Kumar 26-8-1996 14000 11000 10000 16000 Cname Fees Grid Computing 40000 System Design 16000 8000 Computer Security Human Biology 15000 20000 Computer Network 6000 Visual Basic Dreamweaver 4000 Consider the above tables for the questions: Display details of those courses which are taught by 'Sulekha' Cname Fees 8000 Grid Computing 40000 System Design 16000 Computer Security Human Biology Computer Network 6000 Visual Basic Dreamweaver 4000 15000 20000 Lname F_ID Fname 102 Amit Mishra 103 Vyas Nitin Rakshit 104 Soni 18-5-2001 105 Rashmi Malhotra 11-9-2004 106 Sulekha Srivastava 5-6-2006 107 Niranjan Kumar 26-8-1996 Salary Hire_date 12-10-1998 12000 24-12-1994 8000 14000 11000 10000 16000 Cname Fees Grid Computing 40000 System Design 16000 Computer 8000 Security Human Biology 15000 20000 Computer Network Visual Basic Dreamweaver 4000 6000 Consider the above tables for the questions: Generate the query using the traditional approach (using the SELECT, FROM, WHERE statements) and then with the JOIN keyword. Create a list that displays the ID of the Faculty as well as their first name,last name and the course name they teach. For ALL Questions submit the SQL Query to perform what the question is asking. You can copy and paste your queries in the text box. FACULTY F_ID Fname 102 Amit 103 Nitin 104 Rakshit Rashmi 105 106 Sulekha 107 Niranjan COURSES C_ID F_ID C21 102 C22 106 104 C23 C24 106 C25 102 C26 105 C27 107 FACULTY COURSES C_ID FID C21 102 C22 106 C23 104 F_ID Fname 102 Amit 103 Nitin 104 Rakshit 105 Rashmi 106 Sulekha 107 Niranjan C24 106 C25 102 Question 2 (2.5 points) Listen C26 105 C27 107 Consider the above tables for the questions: Write the SQL statements to create tables Faculty and Courses. F_ID is the primary key in the FACULTY table and C_ID is the primary key for the COURSES table. Make sure to include all other appropriate constraints and insert all the data in the tables. FACULTY Figure C_ID F_ID C21 102 C22 106 C23 104 C24 106 C25 102 C26 105 C27 107 Question 3 (2.5 points) Listen F_ID Fname 102 Amit 103 Nitin 104 Rakshit 105 Rashmi 106 Sulekha 107 COURSES Listen FACULTY COURSES C_ID F_ID C21 102 C22 106 C23 104 C24 106 C25 102 C26 105 C27 107 Consider the above tables for the questions: Display details of those Faculties whose salary is greater than 12000. Hire_date Salary 12-10-1998 12000 24-12-1994 8000 18-5-2001 Malhotra 11-9-2004 Srivastava 5-6-2006 Kumar 26-8-1996 FID Fname 102 Amit 103 Nitin Rakshit 104 105 Rashmi 106 Sulekha 107 Niranjan FACULTY Lname Mishra Cname Grid Computing System Design COURSES Vyas Soni Computer Security Human Biology C21 C_ID F_ID 102 C22 106 C23 104 Computer Network Visual Basic Dreamweaver C24 106 C25 102 C26 105 C27 107 Question 5 (2.5 points) Listen FACULTY COURSES Consider the above tables for the questions: Display the details of courses whose fees is in the range of 15000 to 50000 (both values included). Question 4 (2.5 points) C_ID F_ID C21 102 C22 106 C23 104 an C24 106 C25 Fees 40000 16000 8000 C26 105 C27 107 15000 20000 6000 4000 Lname Hire_date Salary Mishra 12-10-1998 12000 Vyas 24-12-1994 8000 Soni 18-5-2001 14000 Malhotra 11-9-2004 11000 10000 Srivastava 5-6-2006 Kumar 26-8-1996 16000 Cname Grid Computing System Design Computer Security Human Biology Vyas Soni Fees 40000 16000 8000 15000 20000 Computer Network Visual Basic 6000 Dreamweaver 4000 Consider the above tables for the questions Set the fees of all courses so that they are all increased by 500. Lname Hire_date Salary Mishra 12-10-1998 12000 24-12-1994 8000 Malhotra 11-9-2004 18-5-2001 14000 11000 Srivastava 5-6-2006 10000 Kumar 26-8-1996 16000 14000 11000 10000 16000 Cname Fees Grid Computing 40000 16000 System Design Computer Security 8000 Human Biology Computer Network Visual Basic Mishra F_ID Fname 102 Amit 103 Nitin Rakshit Lname Hire_date Salary 12-10-1998 12000 24-12-1994 8000 14000 Vyas Soni 104 18-5-2001 11000 105 Rashmi Sulekha Malhotra 11-9-2004 Srivastava 5-6-2006 107 Niranjan Kumar 26-8-1996 106 10000 16000 15000 20000 6000 Dreamweaver 4000 Lname Hire_date Salary Mishra 12-10-1998 12000 Vyas 24-12-1994 8000 Soni 18-5-2001 Malhotra 11-9-2004 Srivastava 5-6-2006 Kumar 26-8-1996 14000 11000 10000 16000 Cname Fees Grid Computing 40000 System Design 16000 8000 Computer Security Human Biology 15000 20000 Computer Network 6000 Visual Basic Dreamweaver 4000 Consider the above tables for the questions: Display details of those courses which are taught by 'Sulekha' Cname Fees 8000 Grid Computing 40000 System Design 16000 Computer Security Human Biology Computer Network 6000 Visual Basic Dreamweaver 4000 15000 20000 Lname F_ID Fname 102 Amit Mishra 103 Vyas Nitin Rakshit 104 Soni 18-5-2001 105 Rashmi Malhotra 11-9-2004 106 Sulekha Srivastava 5-6-2006 107 Niranjan Kumar 26-8-1996 Salary Hire_date 12-10-1998 12000 24-12-1994 8000 14000 11000 10000 16000 Cname Fees Grid Computing 40000 System Design 16000 Computer 8000 Security Human Biology 15000 20000 Computer Network Visual Basic Dreamweaver 4000 6000 Consider the above tables for the questions: Generate the query using the traditional approach (using the SELECT, FROM, WHERE statements) and then with the JOIN keyword. Create a list that displays the ID of the Faculty as well as their first name,last name and the course name they teach.