BIL 101 INTRODUCTION TO COMPUTER SCIENCE HW 09 solved

$35.00

Category: You will receive a download link of the .ZIP file upon Payment

Description

5/5 - (1 vote)

PART 1 (Submit to moodle / .py file)
class SortedList:
theList = []
def add(self, number):

def remove(self, number):

def printList(self):

def binarSearch(self, number):

sorted = SortedList() #create a SortedList object
Fill the function definitons of the SortedList class given above. Test your class by calling the
functions by using the object “sorted”.
PART 2 (Submit moodle / .txt file)
Assume we have the database which is shown in lab hour. (www.w3schools.com/sql) Write
the SQL queries that returns the following tables.
1. OrderID, CustomerName with 196 records
2. OrderID, FirstName (employee), LastName (employee) with 196 records
3. Country, ProductName, ShipperName with 518 records