Question: PLEASE ANSWER THIS QUESTION 2 ABC is a vehicle insurance renewal agency. Consider the following table regarding their customer information District The Insurance Name of

PLEASE ANSWER THIS
PLEASE ANSWER THIS QUESTION 2 ABC is a vehicle insurance renewal agency.
Consider the following table regarding their customer information District The Insurance Name

QUESTION 2 ABC is a vehicle insurance renewal agency. Consider the following table regarding their customer information District The Insurance Name of Vehicle No the Owner No. Identification Customer Last Policy Gender Make of Issued On the Date Vehicle Belongs to 101 A 201 102 B 213 103 516 Vellore 1/01/2021 Male Maruti Kancheepuram 1/01/2021 Female Skoda Vellore 5/03/2021 Female Hyundai Neyvelli 6/06/2021 Male Hyundai Vellore 5/06/2020 Male Maruti 104 D 908 105 E 762 Every year the customers (owners) of the car are identified by the insurance agency and a call is to be made to remind them. Support the insurance agency with a python program for this process. You are expected to write Python program to find the following: a) Display Insurance No's of the Male customers b) Display Name of the Female customers C) Accept the current date, month and year as input, Display the Customer names and Vehicle Identification numbers for whom a renewal is due now (i.e. their insurance is getting expired from an active license status). Note: Insurance Due here means, as per the current month and year, these are the collection of customers who have not renewed equal to or more than a year from the previous policy issue date. d) Accept the make of the car information. Display the Owner names that are with a particular make. INPUT FORMAT: Current date, month and year as DD/MM/YYYY Make of the car OUTPUT FORMAT: #First line display's the Insurance No's of the Male customers #Next line display's the Name of the Female customers #Next few lines display the Customer names and Vehicle Identification numbers for whom a renewal is due now # Owners name who own the vehicle from a particular make Test Input Result 1 10/01/2022 101 104 105 Maruti A 201 B 213

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!