Question

Please HELP, THANK YOU SO MUCH

Consider the below schema of the university database (keys are in bold and underline) Part(pid: string, pname: string, description: string, color: string) Department(did: string, dnamestring, address: string) Supplier(sid string,.sname:string, address:string) Order(did:string. sid string pidstring, time:string, quantityreal, pricereal) The key fields are underlined, and the domain of each field is listed after the field name. Thus pid is the key for Part, did is the key for Department, sid is the key for Supplier, and áid, sid,and pid together form the key for Order Write the following queries in SQL statements. Q1: Find the dids of the departments which have ordered at least one part Q2: Find the department names who have ordered parts from Supplier DELL. Note DELL is a supplier name.

Answer 1

As per the given schema, below are the required queries:

Q1 SELECT did FROM Department WHERE did IN SELECT did FROM "Order" Q2 SELECT dname FROM Department WHERE did IN SELECT did FROM "Order" WHERE sid IN SELECT sid FROM Supplier 'DELL WHERE sname

This completes the requirement. Let me know if you have any questions.

Thanks!