Reference no: EM133612914

Database Design and Management

Relational Database Assignment

Consider the following relational database of a college.
Student(RollNumber, StudentName, Address)
Teachers(TeacherID, TeacherName, TeachingSubject)
College(RollNumber, TeacherlD)

SQL Expressions
1. Find the name of Students who live in Kutus
2. Find the name of the teacher who teaches Database Management System subject
3. Find the name of the teacher who teaches Computer Organisation subject to John Ruto
4. Delete records of students whose address is 'Embu".

Queries
π represents the projection operation, σ represents the selection operation, and ∪ represents the union operation. The join operation (?) is used to combine data from different tables based on a common attribute.
1. π(StudentName)(σ(Address='Kutus')(Student))
2. π(TeacherName)(σ(TeachingSubject='Database Management System')(Teachers))
3. π(TeacherName)(σ(TeachingSubject='Computer Organisation' AND StudentName='John Ruto')(Teachers ?(TeacherID=TeacherID)? Students))
4. Teachers := Teachers ∪ {(-T07", -Wish", "C-4-s")}
5. Student := σ(Address<>'Embu')(Student)