List the ids, first names, last names, majors, minors, and advisor's faculty ids of students majoring or minoring in CSCI and having a faculty advisor in the following

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...
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).

[1] List the ids, first names, last names, majors, minors, and advisor's faculty ids of
students majoring or minoring in CSCI and having a faculty advisor in the following
manner.
+--------+-------+-------+-------+-------+---------+
| stuId | fname | lname | major | minor | advisor |
+--------+-------+-------+-------+-------+---------+
| 100000 | Tony | Hawk | CSCI | CINF | 1011 |
| 100001 | Mary | Hawk | CSCI | CINF | 1011 |
| 100002 | David | Hawk | CSCI | ITEC | 1012 |
| 100009 | Linda | King | ARTS | CSCI | 1018 |
+--------+-------+-------+-------+-------+---------+
4 rows in set (0.000 sec)

MariaDB [toyu2]> select * from student;
stuId fname
| 1name
| Hawk
Hawk
Hawk
Lim
100000 Tony
100001 | Mary
100002 | David
100003 | Catherine
100004 Larry
100005 Linda
100006 Lillian
100007 Ben
100008 | Bill
100009 | Linda
100111 | Cathy
11 rows in set (0.000 sec)
| major | minor | credits | advisor |
CSCI
CINF
CSCI | CINF
CSCI
ITEC
ITEC
CINF
Johnson
ITEC
NULL
Johnson CINF
ENGL
Johnson
CINF
ITEC
NULL
NULL
ARTS
CSCI
Johanson NULL | NULL
Zico
Ching
King
NULL
ARTS
40
35
66
20
66
13
18
16
90
125
1011
1011
1012
NULL
1017
1015
1016
NULL |
NULL |
1018
1018
Transcribed Image Text:MariaDB [toyu2]> select * from student; stuId fname | 1name | Hawk Hawk Hawk Lim 100000 Tony 100001 | Mary 100002 | David 100003 | Catherine 100004 Larry 100005 Linda 100006 Lillian 100007 Ben 100008 | Bill 100009 | Linda 100111 | Cathy 11 rows in set (0.000 sec) | major | minor | credits | advisor | CSCI CINF CSCI | CINF CSCI ITEC ITEC CINF Johnson ITEC NULL Johnson CINF ENGL Johnson CINF ITEC NULL NULL ARTS CSCI Johanson NULL | NULL Zico Ching King NULL ARTS 40 35 66 20 66 13 18 16 90 125 1011 1011 1012 NULL 1017 1015 1016 NULL | NULL | 1018 1018
Expert Solution
Step 1

MySQL creates a database for storing and manipulating data defining the relationship of each table.

steps

Step by step

Solved in 3 steps with 4 images

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