file Income tax department generates the password for Incometax return using the following procedure 1.First 3 Characters of the Applicant first name 2.Last 3 character of the PAN ( PAN length is 10) Password is generated by the concatenation of the above 2 strings Applicant class data members are applicant name, address and aadhaar
Q: 8 An employee file contains records that show an employee's number, name, job code and pay code. The…
A: In the above question job code and job description is given in one table and in the other columns,…
Q: Why does this chapter refer to functions as "single-row" functions?
A: Why do the functions discussed in this chapter refer to themselves as "single-row functions"? These…
Q: from typing import TextIO, Dict, List def get_game_dict(game_data: TextIO) -> Dict[str, List[int]]:…
A: Code: from typing import TextIO, Dict, List def get_game_dict(game_data: TextIO) -> Dict[str,…
Q: count balance: uple[str, int], st[float]]], tuple[str, ht) -> float the balance of the account…
A:
Q: Q 3 / Write a program using the structures (the records read the data of ten factories producing…
A: Since no programming language is mentioned, I am using c++. Algorithm: Start Define a struct…
Q: Q7. The output of the following code is 'University'. import re pattern University' seekerking =…
A: re standa for regular expression. It is helpful in checking if a string or a sub string of a string…
Q: Show Customer name (concatenate First Name and Last Name with a space between) and total number of…
A: The given data samples have the details about a Customer in CUSTOMER table and corresponding orders…
Q: Function CompD (float numl, float num2) returns float nVal float numDiff numbiff - numl - num2 nVal…
A: Given Function: A Function CompD(float num1, float num2) returns float variable nVal float numDiff…
Q: Modify customer 1000 to indicate the date of birth on March 15, 1989. Use YYYY-MM-DD format for…
A: changes needed: Modify customer 1000 to indicate the date of birth on March 15, 1989. Use YYYY-MM-DD…
Q: 1. A medical doctor has a database of his patients that includes the weight and height of each…
A: Start Input Name Compare each name in file with input name If same name found, we print BMI If name…
Q: Exercise: Write a stored procedure which receives a department name p_depName) as input, and…
A: Here we write store procedure for get desired output:…
Q: Write a function to find the average of salary for instructors. header of function…
A: create table instructor ( ID char(5), name varchar(20) not null, dept_name varchar(20),…
Q: Write a function called make_dict(n), where n is an integer parameter. With a given number n, make a…
A: Solution :
Q: Assume, you are given two dictionaries. The dictionary named current_sem_data contains the GPA of 3…
A: NOTE: Since programming language is not mentioned. Therefore answering in Python Language. First,…
Q: US gun murders by state for 2010 Description: Gun murder data from FBI reports. Also contains the…
A:
Q: }; struct state { char name[20]; struct population pl; int district; float lit_rate; }; a. Write the…
A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for…
Q: Complete the following function according to its docstring description. 1 þef format_name (first:…
A: - We need to return the name in the format described in python.
Q: Hello I just need help creating test cases for the functions below. examples: assertequal,…
A: Lets go step by step 1) Validate_name() True:- false:- 2)validate_company True:- False:-…
Q: Scenario 3 a. Create an empty set. b. Enter 5 mobile numbers in the set. c. Display all mobile…
A: s = set() # creating an empty set print("Enter 5…
Q: Write a script that creates and calls a stored function named films_per_category that finds the…
A: CREATE PROCEDURE films_per_category @MovieCategory nvarchar(30)ASSELECT count(*) FROM Films WHERE…
Q: Program 4: Create a PLSQL program that displays the patient's id and name along with the treatment…
A: CODE :- 1. We will write a PL/SQL procedure to display the doctor's salary and bonus after passing…
Q: What is the difference between delete and delete[] C++ operators? When should each be used?
A: An operator is a symbol that instructs the compiler to perform a specific mathematical or logical…
Q: Using Function Points identify EI,EO,EQ.EIF,LIF of given Spell checker. Words?Erors? Dic. name Doc…
A: Software size was originally determined in terms of kilo lines of code(KLOC). However, it is not…
Q: Modify customer 1001 to indicate the date of birth on December 22, 1988. Use YYYY-MM-DD format for…
A: to modify the date in the table using YYYY-MM-DD please use the script in step 2. don't forget to…
Q: PYTHON prov_records_per_date() takes a 2-D list (similar to the database) and an integer…
A: Hey there, I am writing the required solution of the questin mentioned above. Please do find the…
Q: The function below, get_value_if_key, takes two arguments: the dictionary data_dict and a key of any…
A: In Python, to access all the available keys in the dictionary, keys() method is used. It returns a…
Q: Use command SORT to sort the data by case status (depressed or not depressed) sort case * Use the…
A: Solution is below !!
Q: Create a program is used to store and access "id, name and percentage" for 3 students. Sample…
A: Given:-
Q: LINE NUMBER Create or replace Function House Detailsh_num in townhouse.house_num%Type) RETURN…
A: .
Q: The file LabChapter7Problem3.txt has 100 records and is formatted as follows: Emp ID Title First…
A: #include <iostream>using namespace std;struct employee { int empID; char title[50]; char…
Q: Complete the following JavaScript code in order to validate repeated students based on their ID…
A: ANSWER:-
Q: Display only the StudentID, Programming Score and the Maths Score. vi. Show records of students with…
A: V) SELECT studentID , Programming_Score , Maths_Score FROM Student VI) SELECT StudentID FROM Student…
Q: This kind of code gives me errors i have more info below. My code DELIMITER // CREATE PROCEDURE…
A: Answer: SQL Table Create and Insert Code: CREATE TABLE CUSTOMER(CUST_ID INT NOT NULL PRIMARY…
Q: get_total_cases() takes the a 2D-list (similar to database) and an integer x from this set {0, 1, 2}…
A: Coded using Python 3.
Q: sacramento.py Use the sacramento.csv file to complete the following assignment. Create a file,…
A: To answer this question of mismanagement, we have a tendency to use it, we have to draw a line to do…
Q: 1) Add three (3) new records at the bottom of the Fruit Sales sheet. In the Unsold Column of the…
A: Here i write the formula according the given picture data:…
Q: Q2 / Write a program using structures (records) to read the data of seven oil- producing countries…
A: program: #include <iostream> using namespace std;struct record{ string country; int…
Q: Class Attribute : Student Data : Last name, First name, Course, Year Level (1 – 4h year), Midterm…
A: Task : Given the input in the specific order. Output the data in the specific order.
Q: Class Diagram Medical Data Patient data + ld int Pk () Id int Pk Room Data + Medical History…
A: In questions with multiple parts, we must answer 3 parts. In this case, we will write the SQL query…
Q: e
A: The system should allow the employees to list all distributed vaccines and their accumulated…
Q: True or false: setInterval() executes a function repeatedly until the interval is cleared by…
A: We are asked a basic question on setInterval() and clearInterval() function.Let's understand it.
Q: Update the validateForm() function to verify the phone number is exactly 10 characters long. Display…
A: In this question write a JavaScript code for validation of Phone Number input from the user in the…
Q: Using Pandas create a function that takes as input the data set (for example: sets) and returns the…
A: step 1: START step 2: take input of data frame step 3: convert the input to the panda's data frame…
Q: Requirement 4: DESCENDING ORDER (NOT ASCENDING ORDER) 4. Produce a list of all vaccines and their…
A: Our Task: Produce a list of all vaccines and their distributed quantities . The system should allow…
Q: set of integers numbers with the multiplication operator forms a field true or false
A: Answer: The given statement is false.
Step by step
Solved in 2 steps with 1 images
- What is the most a book has been sold for? CREATE TABLE `volume` (`inventory_id` int(11) NOT NULL,`ISBN` char(17) DEFAULT NULL,`condition_code` int(11) DEFAULT NULL,`date_acquired` date DEFAULT NULL,`asking_price` decimal(7,2) DEFAULT NULL,`selling_price` decimal(7,2) DEFAULT NULL,`sale_id` int(11) DEFAULT NULL); INSERT INTO `volume` (`inventory_id`, `ISBN`, `condition_code`, `date_acquired`, `asking_price`, `selling_price`, `sale_id`) VALUES(1, '978-1-11111-111-1', 3, '2019-06-12', '175.00', '175.00', 1),(2, '978-1-11111-131-1', 4, '2019-01-23', '50.00', '50.00', 1),(3, '978-1-11111-133-1', 2, '2018-04-05', '300.00', '285.00', 1),(4, '978-1-11111-142-1', 1, '2018-05-05', '25.95', '25.95', 2),(5, '978-1-11111-146-1', 1, '2018-05-05', '22.95', '22.95', 2),(6, '978-1-11111-144-1', 2, '2019-05-15', '80.00', '76.10', 2),(7, '978-1-11111-137-1', 2, '2019-06-20', '80.00', NULL, NULL),(8, '978-1-11111-137-1', 3, '2019-06-20', '50.00', NULL, NULL),(9, '978-1-11111-136-1', 1, '2018-12-20',…Write a php function (in the space below or attach a file) that returns an array of total sales values for each cookie type in each store.....notice this is a query from a previous section. You can call that query $sqlTotalSales . The function will take three parameters: $numUnits and $priceUnit are strings representing the attributes/columns in the table and $tableName is the name of the table....we could use "Units_Sold" and "Price/unit" for a particular table but what if you want to reuse this function for another dataset? Hence the variables.This is the information after the two pictures. Also, your class should be placed in a namespace "cs_sequence". Here is an example of a simple client program, to give you an idea about how sequences might be used. You can also use this to test your class, but it's far from exhaustive. Keep in mind as you write your class that you should test each member function after you write it. int main() { Sequence s; for (int i = 0; i < 6; i++) { s.insert(i); } for (s.start(); s.is_item(); s.advance()) { cout << s.current() << " "; } cout << endl; } This client program will print the numbers 5 4 3 2 1 0. (They are backward because insert() inserts each new item at the front of the list.) Implementation We will be using the following implementation of type Sequence, which includes 5 data members. numItems. Stores the number of items in the Sequence. headPtr and tailPtr. The head and tail pointers of the linked list. If the Sequence has no items, then these pointers are…
- 10. Write another function called db_consistent that takes a dictionary of dictionariesin the format described in the previous question and returns Trueif and only if every one of the inner dictionaries has exactly the same keys.(This function would return False for the previous example, since RosalindFranklin's entry doesn't contain the 'author' key.)Question 4 Write a function that will redact every third word in a sentence. Make use of the hashtag (#) symbol to redact the characters that make up the word, i.e. if the word is five characters long then a string of five hashtags should replace that word. However, this should not redact any of the following punctuation marks: apostrophes (') quotations (") full stops (.) commas (,) exclamations (!) question marks (?) colons (:) semicolons (;) Arguments: sentence (string) →→ sentence that needs to be redacted. Return: redacted sentence (string)→→ every third word should be redacted. Expected outputs sentence = "My dear Explorer, do you understand the nature of the given question?" redact_words(sentence) == 'My dear ########, do you ########## the nature ## the given ########?' sentence = "Explorer, this is why you shouldn't come to a test unprepared." redact_words(sentence)=="Explorer, this ## why you #######'# come to # test unprepared."Create the .cpp file of this .h file in C++ #include <string>using namespace std;int GetNextID();class Passenger {public: Passenger(); // New passenger, assigning ID using GetNextIDPassenger(int, string, string); // ID, origin, destinationvoid Initialize(int, string, string); // ID, origin, destinationint GetID() {return ID;}string GetOrigin(){ return origin;}string GetDest() {return destination;}private:int ID; // A unique ID number for the passengerstring origin; //Airport identifierstring destination; // Airport identifierint GetNextID(); // Assigns ID's sequentially, starting with 1001};
- Solve this problem and include the code please orderdp.cpp: #include <fcntl.h> #include <stdlib.h> #include <unistd.h> #include <inttypes.h> #include "orders.h" item::item(uint16_t s, uint16_t q) : sku(s), quantity(q) { } item_list::item_list() : items(NULL), num_products(0) { } void item_list::add(const item& i) { items = (item**)realloc(items, (num_products+1)*sizeof(item*)); items[num_products] = new item(i); num_products++; } order::order(uint16_t o, std::string n) : order_id(o), customer_name(n) { } void order::addItem(const item& i) { product_items.add(i); } order** read_orders(const char* filename, uint16_t* num_orders) { int fd; fd = open(filename, O_RDONLY); int err = fd; if (err == -1) { return NULL; } read(fd, num_orders, sizeof(*num_orders)); order** orders = new order*[*num_orders]; for (int i=0; i<*num_orders; i++) { uint16_t order_id; uint16_t…here are the form i used, Public Class frmMain Private Sub frmMain_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'Display the Dormitory price in the list box lstDormitories.Items.Add("Allen Hall - 2,500.00 ") lstDormitories.Items.Add("Pike Hall - 2,200.00") lstDormitories.Items.Add("Farthing Hall - 2,100.00") lstDormitories.Items.Add("UniversitySuites - 2,800.00") End Sub Private Sub btnAddDormitory_Click(sender As Object, e As EventArgs) Handles btnAddDormitory.Click ' if user don't choose any price in list box Select Case lstDormitories.SelectedIndex Case -1 MessageBox.Show("Select A Dormitory Please!") End Select 'Determine the value in Module and display the value of price to lblDormitory Select Case lstDormitories.SelectedIndex Case 0 lblDormitory.Text = mdlsample.Allen_Hall.ToString("c2") Case 1…In java program, please find out the total population for United Kingdom with data that store in text file. The program also should able to display how much average new born per day based the dataset for country specify by user.Text file: (actual file have 500 rows and more country)country,date,total_population,new_born, new_deathUnited Kingdom, 2020-02-24, 63475839, 354, 34,Afghanistan, 2020-02-24, 56213485, 524, 29,United Kingdom, 2020-02-24, 63475702, 602, 56,Afghanistan, 2020-02-25, 56213954, 601, 65,
- Consider the Student class in the provided student.py file. Each student has a name, an id anda list of courses taken. A course is represented as a list with three items to indicate the coursename, semester taken and grade. For example, [‘comp1008’, ‘S24’, 76.3] represents this coursewith a final grade of 76.3. Complete all the functions in the provided a4.py file.Modify to do the following: Add data integrity handing using cin.ignore, etc. for the initial inputs #include <iostream>#include <iomanip>#include <string>#include <vector>#include <cmath>using namespace std;class StudentRec{private: string last_name = ""; // Last name string first_name = ""; // First name int year_grad = 0; // Year expected to graduate float gpa = 0.0; // Current gpapublic: void set_last_name(string last_name_param); void set_first_name(string first_name_param); void set_gpa(float gpa = 0.0); string get_last_name() const; string get_first_name()const; string get_last_name_upper() const; string get_first_name_upper() const; void set_year_grad(int year_grad_param); int get_year_grad() const; int getgpa()const; bool equals(const StudentRec&); string to_str() const; // the rest of the "setter" and "getter" functions for each variable above go here };void…The following copy constructor on lines 2-8 has a few bugs (errors). List all of them in the text box provided with the provided line number as a reference. For example, line 13 is missing a semi-colon (do not use this as one of your answers, -3.5 points). 1 class Midterm{2 void Midterms(const Midterm m){3 _scores = new int[_class_size];4 _class_size = m._class_size;5 for(int i = 0; i < m._class_size; i++)6 _scores[i] = m._scores[i];7 delete[] m._scores;8 }//Midterm910 private:11 int _class_size = 0;12 int* _scores = nullptr;13}//Midterm