Question: Help needed related python program ! Thanx Write a Python program, that uses the Company Database previously supplied to answer the following questions: 1. Find
Help needed related python program ! Thanx
Write a Python program, that uses the Company Database previously supplied to answer the following questions:
1. Find the names of all the customers in Atlanta
2. How many suppliers have the number 456 as part of their phone number
3. Find a list of the customers and their orders
4. Find the products ordered by Delta Airlines
5. Find all the suppliers who supply more than 5 products, and the number of products they supply
The Python program should produce a data output, which should be formatted. The user should be presented with a choice of the 5 queries, shown above. The user then inputs their choice of query to run (1) through (5) and a formatted data output is produced. This process is in a loop till the user quits the program (have an option to exit)
The company schema is as follows:
Categories(CategoryID, CategoryName, Description)
Customers(CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax)
EmployeeTerritories(EmployeeID, TerritoryID)
Employees(EmployeeID, LastName, FirstName, Title, TitleofCourtesy, BirthDate, HireDate, Address, City, Region, PostalCode, Country, HomePhone, Extension, Photo, Notes, ReportsTo, PhotoPath)
Orders(OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShippedVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry)
OrderDetails(OrderID, ProductID, UnitPrice, Qty, Discount)
Products(ProductID, ProductName, SupplierID, CategoryID, QntyPerUnit, UnitPrice, UnitsinStock, ReorderLevel, Discontinued)
Region(RegionID, RegionDescription)
Shippers(ShipperID, CompanyName, Phone)
Suppliers(SupplierID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, HomePage)
Territories(TerritoryID, TerritoryDescription, RegionID)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
