Microsoft Access Assignment: Please Post Link to Download: 6-36. Use SQL to define the following view: StudentID StudentName 38214 Letersky 54907 Altvater 54907 Altvater 66324 Aiken

6-37. Because of referential integrity, before any row can be entered into the SECTION table, the CourseID to be entered must already exist in the COURSE table. Write an SQL assertion that will enforce this constraint.

6-38. Write SQL data definition commands for each of the following queries:

How would you add an attribute, Class, to the Student table?

How would you remove the Registration table?

How would you change the FacultyName field from 25 characters to 40 characters?

6-39. Write SQL commands for the following:

Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the Student table.

Now write a command that will remove Lopez from the Student table.

Create an SQL command that will modify the name of course ISM 4212 from Database to Introduction to Relational Databases.

6-40. Write SQL queries to answer the following questions:

Which students have an ID number that is less than 50000?

What is the name of the faculty member whose ID is 4756?

What is the smallest section number used in the first semester of 2015?

6-41. Write SQL queries to answer the following questions:

How many students are enrolled in Section 2714 in the first semester of 2015?

Which faculty members have qualified to teach a course since 2008? List the faculty ID, course, and date of qualification.

6-42. Write SQL queries to answer the following questions:

Which students are enrolled in Database and Networking? (Hint: Use SectionNo for each class so you can determine the answer from the Registration table by itself.)

Which instructors cannot teach both Syst Analysis and Syst Design?

Which courses were taught in the first semester of 2015 but not in the second semester of 2015?