(c) Describe the relation that would te produed the toing tp relational caleulus

Question

(c) Describe the relation that would te produed the toing tp relational caleulus (10 points) C(Roomm 5 Consider the following dass database schema: (20 Points) Students (stuNo, fName, IName, address, DOB, sex, depNo) Department (depNo, depName Instructor (instructorNo, depNo, fName, IName Class (classNo, className, instructorNo, depNo) Registration(StuNo, classNo, semester) StudyOn (stuNo, class No, dateStudied, hoursStudied) Formulate the following queries in SQL 5-1 41. List all details of students who are female (10 Points) the database class. (10 Points)

Explanation / Answer

SQL Query for 5.1 :

SELECT * FROM Students WHERE sex='F' ;

SQL Query for 5.2 :

SELECT fName,lName from Students,Department,Class,Registration WHERE depName='CS' AND Students.depNo=Department.depNo AND className='database' AND Registration.StuNo=Students.stuNo AND Registration.classNo=Class.classNo ;

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.