Question
Update the Course Table's Description for Course Num 1010 to: This course uses computers for advanced research papers. Then, develop the following queries: List course
Update the Course Table's Description for Course Num 1010 to: This course uses computers for advanced research papers.
Then, develop the following queries:
List course titles offered by Philosophy or Applied Computer Science where the course description contains the word computer. Show fields: Title, Dept Name, Description. Save this as qry_p11_qry1.
List course titles where the course description contains the word computer but where the course is not offered by the Applied Computer Science department. Show fields: Title, Dept Name, Description. Save this as qry_p11_qry2.
List course titles and course numbers where the credit hours are 1, 6 or 9. Show fields: Title, Course Num, Credit Hours. Save this as qry_p11_qry3.
List course titles and course numbers where the credit hours are not 1, not 6, and not 9. Show fields: Title, Course Num, Credit Hours. Save this as qry_p11_qry4.
please let me know where to put the values one I create the queries.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started