This Is The Erd For The Northwind Database Products Orderdetails Orders Customers 00 1 3 Orderid 00 18 00 81 81 Supplie 1 (269.59 KiB) Viewed 20 times
This is the ERD for the Northwind database: Products OrderDetails Orders Customers 00 1 3 OrderID 00 18 00 81 81 Suppliers * SupplierID CompanyName ContactName ContactTitle Address City Region PostalCode Country Phone OrderID 7 ProductID UnitPrice Quantity Discount ProductID ProductName SupplierID CategoryID QuantityPerUnit UnitPrice UnitsInStock Units OnOrder ReorderLevel Discontinued CustomerlD Employeeld OrderDate RequiredDate ShippedDate ShipVia Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCode ShipCountry * CustomerID CompanyName ContactName ContactTitle Address City Region PostalCode Country Phone Fax Fax HomePage Employees 7 Employeeld Last Name FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region PostalCode Country Home Phone Extension Photo Notes ReportsTo Shippers * ShipperID CompanyName Phone Categories 7 CategoryID CategoryName Description Picture
Query 2 What are the unique job titles that Northwind's supplier contacts have? #DELETE THIS LINE AND PASTE YOUR QUERY HERE Query 3 What are the company names, customer contact names of all of Northwind's customers in London (go ahead and list cities as a check)? */ #DELETE THIS LINE AND PASTE YOUR QUERY HERE
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!