Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

Persuasive Speaking Organizing Patterns in Persuasive Speaking?

Answered: 1 week ago