For the last three questions, we’ve begun to use the Student…
For the last three questions, we’ve begun to use the Student database, that we’ll use for the rest of the test. Here is a schema diagram for this database: If we are trying to get the information we need “Find the name of every student along with the full name (and not just the short code) of their major”, we may try the following query: SELECT SNAME, DNAMEFROM Student, Department_to_major Unfortunately, we would get the wrong answer if we use this query. Write a SELECT FROM WHERE query that returns the correct result using the concepts and syntax we have seen in C112.