1. Write a menu drive program to perform following operations into a binary file shoes.dat. 8
a) Add record b) Display records c) Search record d) Exit The structure of file content is: [s_id, name, brand, type, price]Solution:
import pickle
def add_record():
s_id = int(input("Enter Shoe ID: "))
name = input("Enter Name: ")
brand = input("Enter Brand: ")
shoe_type = input("Enter Type: ")
price = float(input("Enter Price: "))
record = (s_id, name, brand, shoe_type, price)
with open("shoes.dat", "ab") as file:
pickle.dump(record, file)
print("Record added successfully.")
def display_records():
try:
with open("shoes.dat", "rb") as file:
while True:
record = pickle.load(file)
print("Shoe ID:", record[0])
print("Name:", record[1])
print("Brand:", record[2])
print("Type:", record[3])
print("Price:", record[4])
print("-" * 30)
except EOFError:
pass
except FileNotFoundError:
print("File not found. No records to display.")
def search_record():
try:
s_id = int(input("Enter Shoe ID to search: "))
with open("shoes.dat", "rb") as file:
while True:
record = pickle.load(file)
if record[0] == s_id:
print("Record found:")
print("Shoe ID:", record[0])
print("Name:", record[1])
print("Brand:", record[2])
print("Type:", record[3])
print("Price:", record[4])
return
except EOFError:
pass
except FileNotFoundError:
print("File not found. No records to search.")
def main():
while True:
print("\nMenu:")
print("a) Add record")
print("b) Display records")
print("c) Search record")
print("d) Exit")
choice = input("Enter your choice: ").lower()
if choice == 'a':
add_record()
elif choice == 'b':
display_records()
elif choice == 'c':
search_record()
elif choice == 'd':
print("Exiting program. Goodbye!")
break
else:
print("Invalid choice. Please try again.")
if __name__ == "__main__":
main()
2. 
Solution:
import mysql.connector as mycon
# i. Fill in the parameters and values for statement 1
cn = mycon.connect(user='root', password='tiger', host='localhost',database='Customer')
# ii. Write function name to create a cursor and fill in the gap for statement 2
cr = cn.cursor()
cust_id = int(input("Enter ID:"))
cust_name = input("Enter Customer Name:")
city = input("Enter City:")
ba = float(input("Enter Bill Amount:"))
mno = input("Enter Mobile No.")
# iii. Write a query to fill statement 3 with desired values
query = "INSERT INTO customer (CustomerID, CustomerName, City, BillAmt, MobileNo) VALUES (%s, %s, %s, %s, %s)"
values = (cust_id, cust_name, city, ba, mno)
cr.execute(query, values)
# iv. Write a query to fill statement 4 to save the records into the table
cn.commit()
# Close the cursor and connection
cr.close()
cn.close()
