Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Provide the MySQL commands for the following queries. Make sure that your queries produce the exact output as shown (row order can be different).    [2] Show the information (id, fname, lname and major program name) of all students enrolled in the class 10003 in the following manner.

Provide the MySQL commands for the following queries. Make sure that your queries produce the exact output as shown (row order can be different).    [2] Show the information (id, fname, lname and major program name) of all students enrolled in the class 10003 in the following manner.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Provide the MySQL commands for the following queries. Make sure that your
queries produce the exact output as shown (row order can be different). 

 

[2] Show the information (id, fname, lname and major program name) of all
students enrolled in the class 10003 in the following manner.
+--------+-------+---------+------------------------------+-------------------+
| stuId | fname | lname | major | class 10003 grade |
+--------+-------+---------+------------------------------+-------------------+
| 100000 | Tony | Hawk | Computer Science | C |
| 100002 | David | Hawk | Computer Science | D |
| 100004 | Larry | Johnson | Information Technology | A |
| 100005 | Linda | Johnson | Computer Information Systems | NULL |
+--------+-------+---------+------------------------------+-------------------+ 

MariaDB [toyu2]> select from grade; grade | gradePoint | A A- MUTUOŐÓLAAš B+ B- C+ C- 1.6667 1.0000 1.3333 0.6667 0.0000 NULL | NULL | NULL | in set (0.001 sec) MariaDB [toyu2]> select from school; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual tha MariaDB [toyu2]> select * from school; | schoolCode | schoolName Business Education D D+ D- F IP P WX 4.0000 3.6667 3.0000 3.3333 2.6667 2.0000 2.3333 15 rows BUS EDU HSH | CSE rows in set (0.000 sec) MariaDB [toyu2]> select from student; stuId | fname | 1name 100000 | Tony Hawk 100001 Mary Hawk 100002 | David Hawk 100003 Catherine Lim Human Sciences and Humanities Science and Engineering 100004 Larry 100005 Linda 100006 Lillian 100007 Ben 100008 Bill 100009 Linda 100111 Cathy | major | minor | credits | advisor | CSCI | CINF 1011 | CSCI | CINF 1011 CSCI | ITEC 1012 ITEC NULL Johnson ITEC 1017 Johnson CINF 1015 Johnson CINF 1016 NULL NULL 1018 1018 Zico Ching King NULL ARTS ARTS Johanson NULL 11 rows in set (0.000 sec) MariaDB [toyu2]> CINF NULL ENGL ITEC NULL NULL CSCI NULL 40 35 66 20 66 13 18 16 90 125
Transcribed Image Text:MariaDB [toyu2]> select from grade; grade | gradePoint | A A- MUTUOŐÓLAAš B+ B- C+ C- 1.6667 1.0000 1.3333 0.6667 0.0000 NULL | NULL | NULL | in set (0.001 sec) MariaDB [toyu2]> select from school; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual tha MariaDB [toyu2]> select * from school; | schoolCode | schoolName Business Education D D+ D- F IP P WX 4.0000 3.6667 3.0000 3.3333 2.6667 2.0000 2.3333 15 rows BUS EDU HSH | CSE rows in set (0.000 sec) MariaDB [toyu2]> select from student; stuId | fname | 1name 100000 | Tony Hawk 100001 Mary Hawk 100002 | David Hawk 100003 Catherine Lim Human Sciences and Humanities Science and Engineering 100004 Larry 100005 Linda 100006 Lillian 100007 Ben 100008 Bill 100009 Linda 100111 Cathy | major | minor | credits | advisor | CSCI | CINF 1011 | CSCI | CINF 1011 CSCI | ITEC 1012 ITEC NULL Johnson ITEC 1017 Johnson CINF 1015 Johnson CINF 1016 NULL NULL 1018 1018 Zico Ching King NULL ARTS ARTS Johanson NULL 11 rows in set (0.000 sec) MariaDB [toyu2]> CINF NULL ENGL ITEC NULL NULL CSCI NULL 40 35 66 20 66 13 18 16 90 125
MariaDB [toyu2]> show tables; | Tables_in_toyu2 class course department enroll faculty grade school student 8 rows in set (0.001 sec) MariaDB [toyu2]> select * from class; | classId | courseId | semester | year | facId 2019 1011 2019 1011 2019 1012 D136 2019 1014 D241 2019 1014 D241 2019 1015 D237 2019 1019 D217 2019 1020 B101 2019 1018 D241 2020 1011 D241 2020 1012 D242 2020 | 1013 D136 2020 1016 | D217 | 2020 1918 | B191 | 10000 10001 10002 10003 10004 10005 10006 10007 10008 11000 11001 11002 11003 11004 2000 Fall 2001 Fall 2002 Fall 2020 Fall 2021 Fall 2040 Fall 2041 Fall 2060 Fall 2080 Fall 2000 Spring 2001 Spring 2002 Spring 2020 | Spring 2061 Spring 14 rows in set (0.000 sec) MariaDB [toyu2]> select from course; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds MariaDB [toyu2]> select * from course; | courseId | rubric | number | title 2000 CSCI 2001 CSCI 2002 CSCI 2020 CINF 2021 CINF 2040 ITEC 2041 ITEC 2060 | ENGL 2061 ENGL 2080 ARTS 2090 ACCT 3333 | Data Structures 4333 5333 3321 4320 3335 3312 1410 1311 3311 3333 | room | D241 | D242 11 rows in set (0.002 sec) Design of Database Systems | DBMS Introduction to Information Systems Web Application Development Database Development | Introduction to Scripting English I | English II Hindu Arts | Managerial Accounting | credits | 3 3 | 3 لینا لینا لنا لنا ليل 3 3 3 لا بیا بیا بیا بیا 3 | 4 3 3 | 3 |
Transcribed Image Text:MariaDB [toyu2]> show tables; | Tables_in_toyu2 class course department enroll faculty grade school student 8 rows in set (0.001 sec) MariaDB [toyu2]> select * from class; | classId | courseId | semester | year | facId 2019 1011 2019 1011 2019 1012 D136 2019 1014 D241 2019 1014 D241 2019 1015 D237 2019 1019 D217 2019 1020 B101 2019 1018 D241 2020 1011 D241 2020 1012 D242 2020 | 1013 D136 2020 1016 | D217 | 2020 1918 | B191 | 10000 10001 10002 10003 10004 10005 10006 10007 10008 11000 11001 11002 11003 11004 2000 Fall 2001 Fall 2002 Fall 2020 Fall 2021 Fall 2040 Fall 2041 Fall 2060 Fall 2080 Fall 2000 Spring 2001 Spring 2002 Spring 2020 | Spring 2061 Spring 14 rows in set (0.000 sec) MariaDB [toyu2]> select from course; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds MariaDB [toyu2]> select * from course; | courseId | rubric | number | title 2000 CSCI 2001 CSCI 2002 CSCI 2020 CINF 2021 CINF 2040 ITEC 2041 ITEC 2060 | ENGL 2061 ENGL 2080 ARTS 2090 ACCT 3333 | Data Structures 4333 5333 3321 4320 3335 3312 1410 1311 3311 3333 | room | D241 | D242 11 rows in set (0.002 sec) Design of Database Systems | DBMS Introduction to Information Systems Web Application Development Database Development | Introduction to Scripting English I | English II Hindu Arts | Managerial Accounting | credits | 3 3 | 3 لینا لینا لنا لنا ليل 3 3 3 لا بیا بیا بیا بیا 3 | 4 3 3 | 3 |
Expert Solution
steps

Step by step

Solved in 3 steps with 6 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS