For this homework you will use the sample database provided, but there is no SQL required. Instead, you w need to answer questions about what tables and columns are needed to get the requested information. Mc of the questions will require information from more than one table. In your answers be sure to list all tables and column names that would be needed, and why they are needed. You will be given the SQL statements needed to create the database modeled below.

Sample question: Provide a list of student names for everyone what has taken CS$101$

Answer: In the takes table you would need the columns course$\_$id and ID$.$ Query the course$\_$id column for values equal to $CS101$ and the ID column for the student ID$.$ To get the student names you would need the ID results from the query on the takes table and match it with the ID and name columns in the student table.

Questions $($Each question is worth $1$ point$)$

Which tables and fields would you access to determine room capacity for the course CS$-319$ in the spring terms?

When a student declares a major, they will have a department name associated with student information. How would you determine how many students haven't declared a major?

The university wants to find out how many total credit hours were taught in $2017,$ and what the course titles were for the courses taught. Which tables and fields would be used to get this information?

How would you determine the difference in total credit hours taught in $2018$ vs in $2017.$

A student wants to know which instructor is teaching CS$-315$ in the spring of $2018.$ Which tables and fields would be needed, and in what order would they be accessed, in order to find the information for the student request?