Homework SourseWrite queries using operations of relational algebra for the
Write queries using operations of relational algebra for the questions listed below. Make sure tocombine operators together to create more advanced queries to retrieve data.Given tables:CUSTOMER (CUST_ID (PK), CUST_LAST, CUST_FIRST, CUST_PHONE, CUST_EMAIL,CUST_ADDRESS, CUST_CITY, CUST_ZIP, CUST_STATE)ORDERS (ORDER_NUMBER (PK), CUST_ID (FK), PROD_ID (FK), ORDER_DATE,ORDER_TOTAL)PRODUCT (PROD_ID (PK), PROD_DESCRIPTION, PROD_CATEGORY, PROD_PRICE)
4. Retrieve Product Description and Price for the products in either the Computer or Gamecategory.
5. Retrieve Name and Address of the customers who placed orders on 01-01-2016. Assumethe CUSTOMER and ORDERS tables are linked through the CUST_ID column.
PLEASE WRITE IN RELATIONAL ALGEBRA FORM NOT SQL FORMAT
Solution
<html>
<head>
<title> Distance calculater
<body>
<h2>Distance calculater</h2>
<p>
Numbers are selected between <input type=\"text\" id=\"minBox\" size=3 value=0>
and <input type=\"text\" id=\"maxBox\" size=3 value=9>.
</p>
<script type=\"text/javascript\" src=\"../common.js\"></script>
<script type=\"text/javascript\">
function calculate() {
var x1=parseFloat(document.getElementById(\"x1\").value);
var y1=parseFloat(document.getElementById(\"y1\").value);
var x2=parseFloat(document.getElementById(\"x2\").value);
var y2=parseFloat(document.getElementById(\"y2\").value);
var xx1=Math.pow((x2-x1),2);
var yy1=Math.pow((y2-y1),2);
var res=\"=sqrt((x2-x1)^2+(y2-y1)^2)\ \";
res+=\"=sqrt((\"+x2+\"-\"+x1+\")^2+(\"+y2+\"-\"+y1+\")^2)\ \";
res+=\"=sqrt(\"+xx1+\"+\"+yy1+\")\ \";
res+=\"=sqrt(\"+(parseFloat(xx1)+parseFloat(yy1))+\")\ \";
res+=\"=\"+Math.sqrt(parseFloat(xx1)+parseFloat(yy1))+\"\ \";
res+=\"=\"+Math.round(Math.sqrt((parseFloat(xx1)+parseFloat(yy1)))*10000)/10000;
document.getElementById(\"result1\").value=res;
}
</script>
<input type=\"button\" value=cordinate 1
onclick=\"min=parseFloat(document.getElementById(\'minBox\').value);
max=parseFloat(document.getElementById(\'maxBox\').value);
number=Math.floor(Math.random()*(max-min+1)) + min;
document.getElementById(\'outputDiv\').innerHTML=
\'\' + number;\">
input type=\"button\" value=cordinate 2
onclick=\"min=parseFloat(document.getElementById(\'minBox\').value);
max=parseFloat(document.getElementById(\'maxBox\').value);
number=Math.floor(Math.random()*(max-min+1)) + min;
document.getElementById(\'outputDiv\').innerHTML=
\'the distance between x y\' + number;\">
<hr>
<div id=\"outputDiv\"></div>
</body>
</html>
