Answer to Question #99514 in Databases | SQL | Oracle | MS Access for Ali

Question

Write a query to list of the names of all programs that do not include the course code ‘EN101’

Write a query to list all program-names and related course-names

Assuming that the program code for Bachelor of Science in Mathematics is ‘BSC4’,
construct a second logical view for Mathematics majors only. Your view must include all
attributes of the student record, the full descriptive name of the Bachelor of Science in
Mathematics program, and the descriptive name of the hall dormitory that the students
reside in.

Answer 1

Dear Ali, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order