Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Question: Do a Left Outer Join of relations D and C over their common attributes. D being the DEPARTMENT Relation C being the COURSE Relation

Question: Do a Left Outer Join of relations D and C over their common attributes. D being the DEPARTMENT Relation C being the COURSE Relation

Database System Concepts
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
See similar textbooks
icon
Related questions
Question

Question: Do a Left Outer Join of relations D and C over their common attributes.

D being the DEPARTMENT Relation

C being the COURSE Relation

(Answer should be in relational algebra query.) Please show the output based on your answer as well in a table for further explanation.  

The DATABASE PDF **DEPARTMENT Relation** | NAME | DCODE | COLLEGE | PHONE | LOCATION | HODID | |--------------|-------|--------------------|-------------|-------------|---------| | Economics | 1 | Arts and Sciences | 5235567654 | 123 McMicken | FM49276 | | QA/QM | 3 | Business | 5235566566 | 333 Lindner | BA54325 | | Economics | 4 | Education | 5235569978 | 336 Dyer | EM65436 | | Mathematics | 6 | Engineering | 5235564379 | 728 Old Chem| RR79345 | | IS | 7 | Business | 5235567489 | 333 Lindner | CC49234 | | Philosophy | 9 | Arts and Sciences | 5235565546 | 272 McMicken | CM87659 | **COURSE Relation** | NAME | COURSE# | CREDIT | COLLEGE | HRS | DCODE | |-----------------------------------|----------|--------|------------------|-----|-------| | Intro to Economics | 15ECON112| U | Arts and Sciences| 3 | 1 | | Operations Research | 22QA375 | U | Business | 2 | 3 | | Intro to Economics | 18ECON123| U | Education | 4 | 4 | | Supply Chain Analysis | 22QA411 | U | Business | 3 | 3 | | Principles of IS | 22IS270 | G | Business | 3 | 7 | | Programming in C++ | 20ECSE212| G | Engineering | 6 | 6 | | Optimization | 22QA888 | G | Business | 3 | 3 | | Financial Accounting | 18ACCT801| G | Education | 3 | 4 | | Database Concepts | 22IS330 | U | Business | 4 | 7 | | Database Principles | 22IS832 | G
Transcribed Image Text:The DATABASE PDF **DEPARTMENT Relation** | NAME | DCODE | COLLEGE | PHONE | LOCATION | HODID | |--------------|-------|--------------------|-------------|-------------|---------| | Economics | 1 | Arts and Sciences | 5235567654 | 123 McMicken | FM49276 | | QA/QM | 3 | Business | 5235566566 | 333 Lindner | BA54325 | | Economics | 4 | Education | 5235569978 | 336 Dyer | EM65436 | | Mathematics | 6 | Engineering | 5235564379 | 728 Old Chem| RR79345 | | IS | 7 | Business | 5235567489 | 333 Lindner | CC49234 | | Philosophy | 9 | Arts and Sciences | 5235565546 | 272 McMicken | CM87659 | **COURSE Relation** | NAME | COURSE# | CREDIT | COLLEGE | HRS | DCODE | |-----------------------------------|----------|--------|------------------|-----|-------| | Intro to Economics | 15ECON112| U | Arts and Sciences| 3 | 1 | | Operations Research | 22QA375 | U | Business | 2 | 3 | | Intro to Economics | 18ECON123| U | Education | 4 | 4 | | Supply Chain Analysis | 22QA411 | U | Business | 3 | 3 | | Principles of IS | 22IS270 | G | Business | 3 | 7 | | Programming in C++ | 20ECSE212| G | Engineering | 6 | 6 | | Optimization | 22QA888 | G | Business | 3 | 3 | | Financial Accounting | 18ACCT801| G | Education | 3 | 4 | | Database Concepts | 22IS330 | U | Business | 4 | 7 | | Database Principles | 22IS832 | G
## Madeira College Database Relations ### Employee and Course Information #### Employee Relation This table consists of employee details, including: - **Name** (e.g., Ram Raj, John B Smith) - **Employee ID** (e.g., RR79345) - **SSN** – Social Security Number (e.g., 5235567244) - **Date of Birth** (e.g., 23-JUN-01) - **Department Number** (e.g., 6) - **Salary** (e.g., 44000) #### Course Relation A simplified table connecting courses to specific codes. - **Courses** include courses labeled like 401W2014, 104A2014. - **Codes** such as A, B, C. - **Instructor/Professor ID** (e.g., KS39874, BE76598). ### Books and Grades #### TEXTBOOK Relation This table provides information on textbooks used in various courses: - **ISBN** – Unique identifier for books (e.g., 000-66574998) - **Title** (e.g., Database Management, Linear Programming) - **Year of Publication** (e.g., 2007, 2005) - **Publisher** (e.g., Thomson, Prentice-Hall) #### TAKES Relation This table records grades for students in particular sections: - **Section Number** (e.g., 101A2014) - **Grade** (e.g., A, B, C) - **Student ID** (SID) (e.g., KP78924, KS39874) ### Usage of Textbooks #### USES Relation This table maps textbooks to courses and instructors: - **Course Number** (e.g., 1HECON123) - **ISBN** – Identifies textbooks used in the course (e.g., 0296748-99) - **Employee ID** – Instructor responsible for the course (e.g., CM65436) This database structure provides a comprehensive view of employee data, textbook information, course relationships, and student performance metrics within Madeira College.
Transcribed Image Text:## Madeira College Database Relations ### Employee and Course Information #### Employee Relation This table consists of employee details, including: - **Name** (e.g., Ram Raj, John B Smith) - **Employee ID** (e.g., RR79345) - **SSN** – Social Security Number (e.g., 5235567244) - **Date of Birth** (e.g., 23-JUN-01) - **Department Number** (e.g., 6) - **Salary** (e.g., 44000) #### Course Relation A simplified table connecting courses to specific codes. - **Courses** include courses labeled like 401W2014, 104A2014. - **Codes** such as A, B, C. - **Instructor/Professor ID** (e.g., KS39874, BE76598). ### Books and Grades #### TEXTBOOK Relation This table provides information on textbooks used in various courses: - **ISBN** – Unique identifier for books (e.g., 000-66574998) - **Title** (e.g., Database Management, Linear Programming) - **Year of Publication** (e.g., 2007, 2005) - **Publisher** (e.g., Thomson, Prentice-Hall) #### TAKES Relation This table records grades for students in particular sections: - **Section Number** (e.g., 101A2014) - **Grade** (e.g., A, B, C) - **Student ID** (SID) (e.g., KP78924, KS39874) ### Usage of Textbooks #### USES Relation This table maps textbooks to courses and instructors: - **Course Number** (e.g., 1HECON123) - **ISBN** – Identifies textbooks used in the course (e.g., 0296748-99) - **Employee ID** – Instructor responsible for the course (e.g., CM65436) This database structure provides a comprehensive view of employee data, textbook information, course relationships, and student performance metrics within Madeira College.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Enhanced ER Model
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
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS