Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

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.

Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter12: Subqueries And Merge Statements
Section: Chapter Questions
Problem 19MC
See similar textbooks
icon
Related questions
Question

  1. 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

     

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

                         

Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Complex Datatypes
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS