shouldn\'t it be select name from department ? * TAR VINhts reserved. Duplicatio

Question

shouldn't it be select name from department ?

* TAR VINhts reserved. Duplication and/or usage of our af any kind without permission willy forbidden hort Answer Given the following database, with primary keys underlined and the following foreign keys: * course(dept.id) references dept(deptid) * enrolled (dept.id, course id) references course(deptid, course.id)! * enrolled student.id) references student (student.id) student maume Bush Cruz Clinton Sanders Trump | 3.8 Toort 100 300 200 | 12 department deptid name building 1 Computer Science Rubio Ajax Math Mathemagics Carson Acme Electrical Engineering Kasich Ajax IE Industrial Engineering Cruz Music | Musicology Costello | North . deptid course id name. 101 Programming 201 Algorithms 202 Systems Math 101 Algebra Math 201 Calculus Math 301 Analysis Music 104 Jazz 102 Circuits IE 101 Proabability 102 Statistics enrolled deptid 1 Math 1 CS 101 1 101 101 201 12 22 Math EE Math 102 22 IE 3 Write SQL queries to answer the following questions. (a) What are the names of all the departments? select name from caurse,

Explanation / Answer

Yes , you are right. the query for this should be

select name from department. (cause its department name not course name).

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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