i- Calculate the query cost of the given two relational queries.
ii- Write SQL query for both relational queries.
a) PNAME (((sCITY!= ‘Rawat’(Customer)) ⋉CID(Order)) ⋈OID(soquantity!=3 (Invoice)))
b) PPrice(sP.PID=I.PID^O.OID=I.OID(((sPrice>30(Product)) x Invoice))x(soid!=3 (Order)))
Answers
Answered by
0
Answer:
Your answer is 20000 bro
Answered by
0
Answer:
Chapter 15 SQL Structured Query Language
ADRIENNE WATT & NELSON ENG
Structured Query Language (SQL) is a database language designed for managing data held in a relational database management system. SQL was initially developed by IBM in the early 1970s (Date 1986). The initial version, called SEQUEL (Structured English Query Language), was designed to manipulate and retrieve data stored in IBM’s quasi-relational database management system, System R. Then in the late 1970s, Relational Software Inc., which is now Oracle Corporation, introduced the first commercially available implementation of SQL, Oracle V2 for VAX computers
Similar questions