Question

1 pts Based on the following ER Diagram from the database called "Student Financial." What SQL statement would you use to answer the following question? Student Tuition PKPSUID PK tutionID FirstName Pays (1.1-FX Student LastName SemesterCost Email Scholarships Department DueDate What are the names of all departments that contain the word "art" in them? (Provide a list of departments, no repeats) SELECT [Select] FROM Student WHERE [Select)

Answer 1

1.In the First question.

The query needs to display the name of departments ,So we will select Department

and the art has to be in the name,so using % wildcard on both before and after art "%are%" will give us the department that has art in anywhere in the name.

SELECT Department

FROM Student

WHERE Department LIKE "%art%"; //when you use pattern matching you use LIKE.

2.In the second question

We need email of student with scholarship less than 5000 So the condition will be t.scholarship < 5000

In the query we have to take a column from one table and the column for the condition is in another table,so it is better to mention table name with the column name.

SELECT s.Email   //here S will be for the student table as email is in that table.

FROM Student s,Tuition t       //comma is the correct way to separate both tables

WHERE t.Scholarship < 5000;