a) 3 letter Country Codes for

i. Bangladesh and Bhutan

ii. Fiji and French Polynesia

iii. Netherlands and Norway

iv. Paraguay and Uruguay

v. Zambia and Zimbabwe

What do you understand by World Traffic Conferences Areas? What is the linkage between IATA and World Geography?

What is the significance of an airport? Explain the physical layout of an airport.

The following data give the sales of 6 models of mobiles at four different stores. The sales of each mobile (in number of mobiles sold) from each store are given as follows:

Test whether there is a significant difference in the sales of the four stores by using the Kruskal Wallies test at 1% level of significance 

If the number of weekly accidents occurring on a mile stretch of a particular road follows a Poisson distribution with parameter λ . Then

(i) Find the Cramer-Rao lower bound for the variance.

(ii) Also, find the UMVUE of λ .

A food processing company packages 10 gm of honey in small jars. Previous experience suggests that the volume of a randomly selected jar of the company’s honey is normally distributed with a known variance of 2 gm. Drive likelihood ratio test for testing

at a α level of significance. Given

A faculty member of a university receives a number of emails. If X represents the number of spam emails in n emails and follows a binomial distribution with parameters  where  is the probability of getting spam email, then find the posterior distribution of considering the following beta distribution.

Also, find the posterior mean of θ .

State whether the following statements are True or False. Give reasons in support of your answer:

(i) If the form of the population is not known and data are in ordinal form then we apply the Wilcoxon Signed rank test for testing hypothesis about average.

(ii) The Neyman-Pearson lemma provides the most powerful test of size a for testing a simple hypothesis against a simple alternative hypothesis.

(iii) The Rao-Blackwell theorem enables us to obtain a manimum variance unbiased estimator through complete statistic.

(iv) For testing goodness of fit when the data are in categorical form, we use K-S test.

(v) In the Bayesian approach, we treat the parameter as a constant.

(b) Differentiate between Rao-Blackwell and Lehmann-Scheffe theorems.

Develop a GUIll (details given below) by Using wxPythonandTkinter, compare the code complexity of both and give your observations.

Use suitable components like text box, combo box, list, Radio Button, Check Box, Buttons, etc. to develop the GUI

Details of GUI: the GUI should accept the personal details of an Employee like Employee Name, DOB, Residential Address, Email, Mobile, Blood Group (A+, B+, O+, A-, B-, O-, etc.), Nature of Job (Permanent, Temporary, contractual, daily wage etc.), Diabetic (Yes, NO), Health Summary etc.

Develop a QUIZ mobile app. The App should display questions one after another with multiple options (each option is possible answer). You need to select the correct option. After 10 questions, it will display the correct score. Make assumptions, wherever necessary.

Consider the following relational schema:

Employee (Eid, Ename, DeptCode, DateofAppointment) Eid is the employeeID, which is a unique identifier assigned by the Organisation when the employee joins (Primary Key), Ename is the employee name, DeptCode identifies the department of the employee (Foreign Key), DateofAppointment is the date when the employee joined the organisation.

Department (DeptCode, DeptName, DeptLocation)- DeptCode is the code allotted to a department and is the Primary Key, DeptName is the department's name, and DeptLocation is the city where the department office is located.

(a) Create the tables using SQL from the schema above; you must include the primary key, foreign keys and constraints in your implementation. Enter a few sets of meaningful data in each table.

(b) Write and run SQL statements for the following queries:

(i) List the name of the employees appointed before 1 January 2024.

(ii) List the name of all the departments located in "Delhi".

(iii) Find the name of all the employees and the name of the department in which he/she works.

(iv) List the employee ID of all those employees who work in Delhi.

(v) Find the total number of employees in each department.

(vi) Find the total number of departments.

.be an inner product space over the field.We are expecting that variables x and y are related by a relation of the formValues of theordered pair (x, y) were observed and are shown in Fig. 1 by points A, B and C. Obtain the least square solution of the problem. Also, visualise your solution.

Find the greatest and smallest values that the function takes on the ellipseusing the Method of Lagrange Multipliers,

Obtain SVD of the matrix

Using Taylor’s formula forr the quadratic approximation of f(x, y) near origin is:

Gradient of the functionat the point P(1, 2) is:

Using Gram Schmidt orthogonalisation process find orthogonal basis for the subspace of IR

What is Kivy? Discuss the architecture of Kivy with the help of a suitable block diagram.

What is TKinter? Create a GUI using Tkinter that displays "Hello World" message in the window. Discuss the execution of lines of code written by you

Compare DBMS and RDBMS. What are integrity constraints? Discuss different types of integrity constraints. Also, discuss the SQL CRUD statements used to perform database related activities by using PYTHON and SQLLITE. Give an example code for each statement.