Insert statements to populate at least 10 faculty records, 5 Course records, and 25 FacultyCourses records 5. Use update statements to update all Courses to 4 credits 6. Use update statements to update any Faculty who have taught more than 4 courses to modify the number to 5 courses taught 7. Delete any Faculty record whose LastName starts with the letter ‘Z’ 8. Delete any Course record that was first offered in 1999 9. Use select statements to display all records in all 3 tables. Order by the Faculty lastname, and Course title as appropriate. Note you should use 3 separate select statements to satisfy this requirement. 10. Use Select statements to display all Faculty who have not taught any courses 11. Use Select statements to display all Courses offered before 1984 12. Use Select and appropriate joins to display all columns from the Faculty and Course tables for each Faculty and Course in the FacultyCourse table. Note: this will be a 3-table join.
