YSQL [jsohn6]> SELECT * FROM SCHOOL; lySQL [jsohn6]> SELECT * FROM DEPARTMENT; SCHOOL_CODE DEPARTMENT_ID | DEPARTMENT_ID | DEPARTMENT_NAME 101 SCHOOL OF MERCHANDISING FASHION DESIGN 101 SCHOOL OF FASHION DESIGN 102 ADVERTISING 102 103| 201|| 202 | SCHOOL OF GRAPHIC DESIGN GRAPHIC DESIGN 103 SCHOOL OF FINE ARTS 201 FINE ARTS SCHOOL OF DESIGN AND TECHNOLOG DESIGN AND TECHNOLOGY 202 rows in set (0.00 sec) MYSQL [jsohn6]> SELECT FROM PROFESSOR; MYSQL [jsohn6]> SELECT * FROM TECHNOLOGY; | PROF_NUM | PROF_LASTNAME PROF_FIRSTNAME COURSE_TYPE | LABTOP_NUMBER 1 | Smith 2 | Banks 3 | Taylor 4 | Smith 6 | Smith 7 | Banks Mary | Jane TECH-100 12345 Hazel TECH-110 67890 Terry TECH-120 13579 | Jenny | Tim 24680 TECH-200 4 rows in set (0.00 sec) 6 rows in set (0.00 sec) VSQL [jsohn6]> SELECT FROM COURSE; COURSE_TYPE | PROF_NUM | DEPARTMENT_ID | COURSE_TITLE | COURSE_DESCRIPTION | COURSE_TYPE_CODE | 101 | Costume Designs 101 | Couture Fashion 101 | Costume Designs 101 | Textile Designs 201 | Fine Arts 103 | Computer Patterns 103 | Web Retail 103 | Web Design 202 | Design with Technolo | Intro to Computer Design | Fundamentals of Costume Design | F | Fundamentals of Luxury Design | F | Fundamentals of Costume Design | F | Fundamentals of Textile Design | F Advanced Printmaking | Intro to Computer Patterns FASH-100 FASH-110 FASH-120 FASH-150 FASH-210 4 | 2 | 4 | 2 | TECH-100 Intro to Retail Ecommerce TECH-110 | Fundamentals of Graphic Design | T TECH-120 TECH-200 rows in set (e.01 sec) MYSQL [jsohn6]> SELECT * FROM FASHION; COURSE_TYPE | RUNWAY_DATE | 2020-05-27 | 2020-05-27 | 2020-05-27 | 2020-05-28 | 2020-05-28 FASH-100 FASH-110 FASH-120 FASH-150 FASH-210 rows in set (0.00 sec)
YSQL [jsohn6]> SELECT * FROM SCHOOL; lySQL [jsohn6]> SELECT * FROM DEPARTMENT; SCHOOL_CODE DEPARTMENT_ID | DEPARTMENT_ID | DEPARTMENT_NAME 101 SCHOOL OF MERCHANDISING FASHION DESIGN 101 SCHOOL OF FASHION DESIGN 102 ADVERTISING 102 103| 201|| 202 | SCHOOL OF GRAPHIC DESIGN GRAPHIC DESIGN 103 SCHOOL OF FINE ARTS 201 FINE ARTS SCHOOL OF DESIGN AND TECHNOLOG DESIGN AND TECHNOLOGY 202 rows in set (0.00 sec) MYSQL [jsohn6]> SELECT FROM PROFESSOR; MYSQL [jsohn6]> SELECT * FROM TECHNOLOGY; | PROF_NUM | PROF_LASTNAME PROF_FIRSTNAME COURSE_TYPE | LABTOP_NUMBER 1 | Smith 2 | Banks 3 | Taylor 4 | Smith 6 | Smith 7 | Banks Mary | Jane TECH-100 12345 Hazel TECH-110 67890 Terry TECH-120 13579 | Jenny | Tim 24680 TECH-200 4 rows in set (0.00 sec) 6 rows in set (0.00 sec) VSQL [jsohn6]> SELECT FROM COURSE; COURSE_TYPE | PROF_NUM | DEPARTMENT_ID | COURSE_TITLE | COURSE_DESCRIPTION | COURSE_TYPE_CODE | 101 | Costume Designs 101 | Couture Fashion 101 | Costume Designs 101 | Textile Designs 201 | Fine Arts 103 | Computer Patterns 103 | Web Retail 103 | Web Design 202 | Design with Technolo | Intro to Computer Design | Fundamentals of Costume Design | F | Fundamentals of Luxury Design | F | Fundamentals of Costume Design | F | Fundamentals of Textile Design | F Advanced Printmaking | Intro to Computer Patterns FASH-100 FASH-110 FASH-120 FASH-150 FASH-210 4 | 2 | 4 | 2 | TECH-100 Intro to Retail Ecommerce TECH-110 | Fundamentals of Graphic Design | T TECH-120 TECH-200 rows in set (e.01 sec) MYSQL [jsohn6]> SELECT * FROM FASHION; COURSE_TYPE | RUNWAY_DATE | 2020-05-27 | 2020-05-27 | 2020-05-27 | 2020-05-28 | 2020-05-28 FASH-100 FASH-110 FASH-120 FASH-150 FASH-210 rows in set (0.00 sec)
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Create a complex query based on two or more tables (SCHOOL, DEPARTMENT, PROFESSOR, TECHNOLOGY, COURSE, & FASHION tables attached) which includes either several conditions or a subquery (or both).
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education