Answer to Question #214276 in Databases | SQL | Oracle | MS Access for Hassam

Question

Given are relational algebraic expressions. Perform given tasks for each.

·        Write SQL statement for given queries.

·        Convert Cartesian Product into Joins and vice versa.(convert only given queries in relational algebraic form)

i-                  (((s_TSAL>=50000(Tutor))⟕_TIDAssign)⋈_C.cid=A.cid(s_{Name=’DBS’} (Course))

ii-                s_{TS.REGNO=R.REGNO^R.CCODE=C.CCODE}           (((s_CGPA>3.0(STUDENT)) x (REG)) x (s_{CATEGORY='MATHS'}(COURSE)))

Answer 1

SELECT Customers.CustomerName, Orders.OrderID

FROM Customers

LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID

ORDER BY Customers.CustomerName;