Write queries using operations of relational algebra for the questions listed be
ID: 3922786 • Letter: W
Question
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
Explanation / Answer
<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
>
input type="button" value=cordinate 2
>
<hr>
<div id="outputDiv"></div>
</body>
</html>
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.