Search & Filtering
Assume that you have to create such an application for maintaining a database of book titles
and their costs.
Part 1: Write the script to create the required database and add data programmatically by
using the Insert query.
Part 2: Write a Python script connecting to the database created that has the following
features:
• A books table having the title, author, and price as fields.
• Accept input from the user for the title and quantity purchased by the customer.
• Fetch the price from the table by executing the Select query.
• Calculate the total amount and display it
Assume that you have to create a GUI-based form for the same books table that you created
in the module 5 assignment. The form should have the following features:
1. It should have the basic functionality and widgets displayed in the mock-up below:
2. It should fetch the price of the book when the 'find price' button is clicked.
3. The quantity field should only accept integer data.
4. When the 'find total amount' button is clicked, the field should display the total amount
by calculating the product of the price and quantity.
5. If the book title enter is not present in the database, a message saying the book is not
fond should be displayed
Calculate Euclidean distances between these pairs of points (total 10*10 = 100 pairs
including self pairs). This should give you a 10*10 2-D array where each value
corresponds to the distance between a pair.
Construct a 2-D 10 10 ∗ matrix with the following constraints:
• The element at [0,0] should be 1
• The element at [0,9] should be 100
• The element at [9,0]should be 50
• The interval between elements in rows should be constant
• The interval between elements in columns should be constant
Find latitude and longitude of first 20 countries with a population greater than or equal to the population limit given below. Use the country details from this dataset(https://cdn.jsdelivr.net/gh/apilayer/restcountries@3dc0fb110cd97bce9ddf27b3e8e1f7fbe115dc3c/src/main/resources/countriesV2.json).
Your task is to find the sum of the length of all lines (in kms) that can be drawn between co-ordinates of these countries.
Assume radius of earth: 6371 km
Round length of each line and final result to 2 decimal points
If co-ordinates are missing for any country use 0.000 N 0.000 E
Population limit: 65847
Note: Population limit will change at random intervals. So please make sure answer is computed for the correct population limit
Date Format
Write a program to convert the date from =dd-mm* yy^ prime prime format to "dd/mm/yy^ prime prime format.
In Python, what is the output of: 26 % 3
Construct a list of first 100 natural numbers.Create a two dimensional array with 10
rows and whose each row contains 10 columns and each number in this array is the
square of the number from your constructed list.
For example : [[1,4,9,...,100],[121,144,...],......,
Create a 2-D array of 10 points where the x-coordinates and the y-coordinates can
take random integral values between 5 and 20.
An entity that can be different assigned different values is called
