Consider the following Customers table and express in relational algebra each of the questions below:CustomerscustomerNONameAddressCityZip100Salma AmriStreet freedomMuscat213101Ayman ZawamriStreet 11 SeptemberNizwa210102Said RaafitStreet 13 OctoberSalalah211103 Salem Samri Street Yasamine Sur205 List the names of customers who are from the city of “Muscat”. List the details of customers who are not from “Nizwa”. List the names and addresses of customers having the numbers 101 or 103.

here have to determine query of given questions.

Answered: Consider the following Customers table…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Consider the following Customers table and express in relational algebra each of the questions below:

Customers
customerNO	Name	Address	City	Zip
100	Salma Amri	Street freedom	Muscat	213
101	Ayman Zawamri	Street 11 September	Nizwa	210
102	Said Raafit	Street 13 October	Salalah	211
103	Salem Samri	Street Yasamine	Sur	205

List the names of customers who are from the city of “Muscat”.
List the details of customers who are not from “Nizwa”.
List the names and addresses of customers having the numbers 101 or 103.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions