Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operational Auditing A Complete Guide

Authors: Gerardus Blokdyk

2019 Edition

0655515879, 978-0655515876

More Books

Students also viewed these Accounting questions

Question

7. Identify six intercultural communication dialectics.

Answered: 1 week ago