Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For the following database schema: STUDENT (STUD-NO, STUD-NAME, BDATE, ADDRESS, DNO) DEPARTMENT (DNO, DNAME, MGR-NO) COURSE (CNO, CNAME, CREDIT-H, DNO) ENROLLED (STUD-NO, CNO, GRADE)
For the following database schema: STUDENT (STUD-NO, STUD-NAME, BDATE, ADDRESS, DNO) DEPARTMENT (DNO, DNAME, MGR-NO) COURSE (CNO, CNAME, CREDIT-H, DNO) ENROLLED (STUD-NO, CNO, GRADE) a) Write down the following expressions in SQL: 1) Retrieve student names that enrolled in course "Introduction to DB" and has grade "A". 2) Retrieve the names of all courses listed in "Computer science". Department. b) Write down the definition of the relation ENROLLED using SQL.
Step by Step Solution
★★★★★
3.46 Rating (159 Votes )
There are 3 Steps involved in it
Step: 1
Question a 1 SQL query select studStudName as StudentName from student studenrolled encourse cn wher...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Fundamentals Of Database Systems
Authors: Ramez Elmasri, Shamkant Navathe
7th Edition
0133970779, 978-0133970777
