I need help in my database assignment for info systems. I am asked to implement

ID: 3549219 • Letter: I

Question

I need help in my database assignment for info systems.

I am asked to implement a three tables for Suppliers(S), Parts(P), and Shipments (SP).

I already created the table but I need to retrieve some data using sql in access 2010.

here is a list. Make a list of all the different cities where suppliers are located(no repetitions)

Retreive the names of all suppliers who ship P1

Retreive the names of suppliers that ship screws.

I have tried a code to do this but I keep getting the wrong results. help me.

SELECT DISTINCT cities FROM Suppliers SELECT DISTINCT SuppliersFROM Parts SELECT DISTINCT SuppliersFROM Parts

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.