QUESTION 4 Answer All the questions: Consider the below Student table and write the appropriate relational algebra query: City | SNAME SLNAME 1001 Mariam Al Alawi AGE CID 20 ITDR2106 Introduction to Database Sur ITDR2104 Programming ITDR1101 Introduction to IT ITDR2104 Programming ITSW3101 App. Sw. Development SID CNAME Al Salti Sohar Muscat 1002 Sara 22 1003 Rahma Al Ruzaiqi 1004 Busma 1005 Salim 22 Al Mammari 23 Al Busaidi Muscat 24 Muscat Find the student details who do not live in the city Muscat?

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

data

QUESTION 4
Answer All the questions:
Consider the below Student table and write the appropriate relational algebra query:
SID SNAME SLNAME
1001 Mariam Al Alawi
AGE CID
ITDR2106 Introduction to Database Sur
ITDR2104 Programming
ITDR1101 Introduction to IT
ITDR2104 Programming
ITSW3101 App. Sw. Development
CNAME
City
20
1002 Sara
Al Salti
22
Sohar
1003 Rahma Al Ruzaiqi
1004 Busma
1005 Salim
22
Muscat
Al Mammari 23
Al Busaidi
Muscat
24
Muscat
Find the student details who do not live in the city Muscat?
Transcribed Image Text:QUESTION 4 Answer All the questions: Consider the below Student table and write the appropriate relational algebra query: SID SNAME SLNAME 1001 Mariam Al Alawi AGE CID ITDR2106 Introduction to Database Sur ITDR2104 Programming ITDR1101 Introduction to IT ITDR2104 Programming ITSW3101 App. Sw. Development CNAME City 20 1002 Sara Al Salti 22 Sohar 1003 Rahma Al Ruzaiqi 1004 Busma 1005 Salim 22 Muscat Al Mammari 23 Al Busaidi Muscat 24 Muscat Find the student details who do not live in the city Muscat?
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY