Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exercises on university database: Submit SQl queries for following statements. 1. Find the names of courses in Computer science department which have 3 credits 2.
Exercises on university database: Submit SQl queries for following statements.
1. Find the names of courses in Computer science department which have 3 credits
2. For the student with ID 12345 (or any other value), show all course_id and title of all courses registered for by the student.
3. Find the names of all students who have taken any Comp. Sci. course ever (there should be no duplicate names) 4. Display the IDs of all instructors who have never taught a couse.
G information-schema my1st_db mysql Profi ing lEdit inline] [ Edit] [ Explain SQL]l Create PHP code ] [R course-id title mysql performance_schema phpmyadmin Intro. to Biology dept name credits Biology Show all Number of rows. 25 Edit Cop elete BIO-101 test + Oplions Eait Copy Delete BIO-301 s ulosy ID name dep-name tot-cred 102 + test +G testdb Computational Intro. to testdb iP Cdit,i Copy Delole Bio-399 Edit Copyete 00123 Zhar Comp Sci. Edit Copy Delete 12345 Shankar Comp yDelete CS-101 Computer Comp. Sci Game Design Comp. Sci. Corp. Sci. Comp Sci Comp Sci +advisor adviso / Edit gi Cop Delete 19991 Brandl History Ed i Copy Delete CS 190 CditCopy Dululc 23121 Chavez Finance Edit Copy Delete 11553 Peltier Physics Edit "Copy )Delete 45673 Levy Physics EditCopyDelete 54321 Willams Comp. Sci 11D 56 46 54 +r course course +instructor prere section tdit Copy Delete CS315 Robotics Edil ije Copy elele CS-319 Edil i Cupy Delele 34r ystem instructor Processirig prereq section n student Edi Copy Dets 55719 / Edit Cop +student takes ECopyDelete EE-181Intro. to Digital Delete/05h/Snow Physics Systems Edit y Copy', Delete HN-201 Investment Editgi Copy Delete HIS-351 World History History Edit e Copy Delete usic Edi CopyDelete PHY-101 n teaches n teaches Hinance Edit i Copy Delcie 76543 Brown Comp dit Copy Delete 76653 Aoi Elec. Eng. Edit Copy Delete g6755 Bounkas Elec. Eng. Dariking time_slot +time_slot 60 98 120 Production Physical D a Edit5+ Cop Delete 90000 Tanaka Biology t-o check al With selected Edit Copy Delete
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started