Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CUSTOMER PK CusID SALE PK Sale No -makes- -H- CusName CusAddress CusCity CusState CusZip CusBalance CusCreditLimit SRepNo - is sold SaleQty Item No DeptNo CusID
CUSTOMER PK CusID SALE PK Sale No -makes- -H- CusName CusAddress CusCity CusState CusZip CusBalance CusCreditLimit SRepNo - is sold SaleQty Item No DeptNo CusID FK3 FK2 FK1 -makes- ITEM DELIVERY DEPARTMENT EMPLOYEE PK Item No DelNo PK DeptNo PK EmpNo PK -H-is included O Item Name Item Type ItemColor FK2 FK1 FK3 DelQty > --receives---H- DeptName +O-manages --- EmpName Item No DeptFloor EmpSalary DeptNo DeptPhone FH---has -- OF Boss No Splno FK1 EmpNo FK1 DeptNo 1 - supervises - makes SUPPLIER PK Spino SplName Find the Names of the employees in the Marketing Department. 2. Find the items sold by the departments on the second floor. 3. Find the Names of items sold on floors other than the second floor. 4. Find the items SOLD OTHER THAN THOSE SOLD BY DEPARTMENTS ON THE SECOND FLOOR 16. Find the Suppliers who deliver compasses. 17. Find the Suppliers who do not deliver compasses.(THESE SUPPLIERS NEED NOT MAKE DELIVERIES) 18. Find the Suppliers who deliver any item other than compasses.(THESE SUPPLIERS MAKE DELIVERIES)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started