a Base Management Sectio 01 spring 201z co Content Library v Assessments v Commu

Question

a Base Management Sectio 01 spring 201z co Content Library v Assessments v Communication v Resources Des test2-Feb28th 7:30pm-9:30pm Quiz on Johnson: Attempt 1 Question 4 (5 points) Now let's assume you have created the Student and Department (only one attribute DID. It is a new no relation with last three questions) tables. Now use SQL Query Language to connect the two entities together and print out the following data (don't forget GPA Name Sid John Smith Kittie Green Bob Brown Department Sid Print out the data like this: DID GPA 3.6 EST 2.5 Kittie Green Bob Brown

Explanation / Answer

[4]
SELECT a.Sid, a.Name , a.GPA , b.DID
FROM Student JOIN Department
ON (a.Sid = b. Sid);

[5]
SELECT a.Name, b.DID
FROM Student JOIN Department
ON (a.Sid = b. Sid)
WHERE b.DID = 'CST';

[6]
DROP TABLE Student;

[7]
ALTER TABLE Student
ADD Age INT;

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.