Find the name of students who live in kutus

Assignment Help Database Management System

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)

Reference no: EM133612914

Questions Cloud

How sketch would change if the sample size was increased : Explain how the sketch would change if the sample size was increased and compute relevant statistics and give your position on the Null hypothesis

Software development process : A description of the core activities in the software development process. An explanation of why the testing stage of systems development is so important.

Describe social institutions and impact on the individual : Dr. Hahn asks her students to describe social institutions and their impact on the individual. One of her students writes extensively of her gender,

How non-verbal communication plays a role in communication : Identify how non-verbal communication plays a role in communication. Describe how to incorporate this education into inter-professional communication.

Find the name of students who live in kutus : DIS 4104 Database Design and Management - Find the name of Students who live in Kutus and Find the name of the teacher who teaches Database Management System

What are implications of trends for electoral participation : What are the implications of these trends for electoral participation? How could this affect who wins the election?

Concepts of diversity and equity : Discuss the steps you would use to collect primary data for your identified population. Consider the concepts of diversity, equity,

Describe potential challenges or risks that may be inherent : Describe any potential challenges or risks that may be inherent in the technologies associated with these trends you described.

What strategies will you employ to ensure a successful nclex : What strategies will you employ to ensure a successful NCLEX outcome? Describe 3-4 strategies you will utilize to promote your success.

User Account

All Pages