Write a relational algebra query/expression to show names of all faculty who work at any department that uses "Beau" building. Use the College Relat
Write a relational algebra query/expression to show names of all faculty who work at any department that uses "Beau" building. Use the College Relat
Chapter2: Database Design Fundamentals
Section: Chapter Questions
Problem 3TD
Related questions
Question
Write a relational algebra query/expression to show names of all faculty who work at any department that uses "Beau" building. Use the College Relational Schema provided
Transcribed Image Text:College Relational Schema
DEPARTMENT(DID, DName, ChairEld)
DName -- candidate key
ChairEID – foreign key of FACULTY
FACULTY(Eid, FName, MI, LName, Email, DID)
Email – candidate key
DID – foreign key of DEPARTMENT
BUILDING(BID)
DEPARTMENT_BUILDING(DID, BID)
DID - foreign key of DEPARTMENT
BID - foreign key of BULDING
MAJOR(MCode, MName, DName)
DName – foreign key of DEPARTMENT
COURSE(CID, CName, Credits, DID)
DID - foreign key of DEPARTMENT
CName - candidate key ???
STUDENT(SID, DOB, FName, MI, LName, Street, City, ZIP, Level, Phone)
Phone – candidate key
SECTION(CID, SLetter, Semester, Year, Location, TimeSlot, EID)
EID – foreign key of FACULTY
CID- foreign key of COURSE
REQUIRED_IN(MCode, CID)
MCode - foreign key of MAJOR
CID- foreign key of COURSE
ELECTIVE_IN(MCode, CID)
MCode - foreign key of MAJOR
CID- foreign key of COURSE
ENROLLED_IN(Sid, MCode)
MCode - foreign key of MAJOR
SID - foreign key of STUDENT
TAKES(SID, CID, SLetter, Semester, Year, Grade)
SID - foreign key of STUDENT
CID, SLetter, Semester, Year - foreign key of SECTION
Grade - foreign key of GRADE
GRADE(Grade, Points)
# This table has been added beyond what the ERD implies.
Points - candidate key
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 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
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning