Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 14th East European Conference Adbis 2010 Novi Sad Serbia September 2010 Proceedings Lncs 6295

Authors: Barbara Catania ,Mirjana Ivanovic ,Bernhard Thalheim

2010th Edition

3642155758, 978-3642155758

More Books

Students also viewed these Databases questions

Question

LO1 Discuss four different views of motivation at work.

Answered: 1 week ago

Question

LO6 Summarize various ways to manage retention.

Answered: 1 week ago