For ALL Questions submit the SQL Query to perform what the question is asking. You can...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
Step 1: Design the topology (Connectivity), Rename Router1= YourFirstName_Router1, Router2= YourFirstName_Router2, Route3=YourFirstName_Route3, and Computer1= YourFirstName_Computer1. Assign IP...
-
Prepare SQL Scripts that: Select ALL the BusinessEntityID, LastName, and FirstName fields for the Person's table Fields should be in the above order. Add a sort to the query so LastName is...
-
10. Two great circle arcs on the Earth's surface leading out of London make an angle of 20. One goes to New York City, a distance of 3,046 miles, the other to Santo Domingo in the Dominican Republic,...
-
The Athletic Department of Leland University is considering whether to hold an extensive campaign next year to raise funds for a new athletic field. The response to the campaign depends heavily on...
-
The bottling division of Sweet Suzys Sugarless Cola maintains daily records of the occurrences of unacceptable cans flowing from the filling and sealing machine. The data in Colaspc lists the number...
-
What is the major difference between a sample and a census?
-
Imprudential, Inc., has an unfunded pension liability of $ 630 million that must be paid in 20 years. To assess the value of the firms stock, financial analysts want to discount this liability back...
-
Little Books Inc. recently reported $220,000 of net income. Its EBIT was $420,000, and its tax rate was 42.00%. What was its interest expense?
-
1. A car moving with a velocity of +10m/s enters a freeway entrance ramp. Four seconds later it is moving +30 m/s. a. What is the car's acceleration? b. What is the car's velocity 1.5s after entering...
-
In a limited partnership, the liability of a limited partner is limited to the amount of capital they invest in the partnership. (True/False)
-
Lizette borrows $150,000 from Main Street Bank to buy a home. The Truth-in-Lending Act (TILA) regulates primarily a. the mortgage terms that must be disclosed in writing. b. the lenders oral...
-
F.A. Investment Group, Inc., owned an apartment building in Philadelphia, Pennsylvania. Over a two-year period, the city cited F.A. Investment for a variety of housing code violations. These...
-
Baubles, a jewelry store, contacts United Parcel Service (UPS) to ship a diamond ring worth $105,000. The owner of the store arranges for the shipment on UPSs website, which requires the customer to...
-
Hewlett-Packard Company (HP) monitored the phones of its directors to find the sources of leaks of company information to the media. When the government learned of the monitoring, criminal charges...
-
Travelin Style manufactures camping trailers in a production facility in Brownsville, Texas. The company is only eight years old and manufactures small, medium, and large trailers, as well as custom...
-
Suppose the concentration of glucose inside a cell is 0.1 mm and the cell is suspended in a glucose solution of 0.01 mm. a. What would be the free energy change involved in transporting 10-o mole of...
-
Test the hypothesis that the high-fiber diet has a differential effect on cholesterol levels compared with a low fiber diet (report your results as p < .05 or p > .05)? Nutrition, Cardiovascular...
-
Implement the test in Problem 14.55, and report a p-value (two-tailed)? Cancer A study was performed to compare breast cancer incidence between postmenopausal women who used PMH vs. women who did...
-
Suppose a new threshold of change, Î mg/dL, is proposed for establishing compliance. We wish to use a level of Î such that the compliance measures in Problems 5.36 and 5.38 for the...
-
Describe the process of determining a nominal interest rate.
-
How does risk affect the financial management of sport organizations?
-
Of MLB, the NBA, and the NHL, which league has the most risk, and which has the least? Why?
Study smarter with the SolutionInn App