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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!