EMPLOYEE TABLE EMPLOYEE_ID FIRST_NAME SURNAME CONTACT NUMBER emp101 0877277521 emp102 emp103 emp104 emp105 DONATOR TABLE DONATOR_ID 20111 20112 20113 20114 20115 7111 7112 7113 7114 Jeff 7115 7116 Kevin DONATION TABLE DONATION ID Adanya Adebayo Xolani Jeff Stephen James Kelly Abraham FIRST_NAME 20111 20112 Davis 20113 20115 Marks 20114 20113 Andrews DONATOR_ID Dryer Samson Joe 0837377522 Ross Clark 0817117523 0797215244 SURNAME Watson Jones 0827122255 DONATION KIC Fridge Samsung 42inch LCD Sharp Microwave 6 Seat Dining room table Lazyboy Sofa JVC Surround Sound System PRICE R 599 R 1 299 R 1 599 R 799 ADDRESS R 1 199 R 179 10 main CONTACT NUMBER EMAIL 0827172250 0837865670 0878978650 0826575650 0797656430 road 18 water road 21 circle lane 1 sea road 12 main road EMAIL jand@isat.com km@isat.com aa@isat.com aryer@isat.com xosam@isat.com jwatson@ymail.com joness@ymail.com jj@isat.com kross@gsat.com aclark@ymail.com DONATION_DATE 1 May 2022 3 May 2022 3 May 2022 5 May 2022 7 May 2022 9 May 2022

Q: Convert this file to .csv and then make a chart using python.

A: Read the contents of the "mortgageRate.txt" file. Split the lines into a list of year-rate pairs.…

Q: Set rows 1-3 as print titl

A: answer in next step

Q: Insert rows into Horse table Using MYSQL   The Horse table has the following columns: ID -…

A: Find the required query to insert given data given as below :

Q: ode to keep facilitate the players. Create a class name Play • Create the following method name •…

A: Below is the required java program. Program Approach:   Define a class as play. Inside the play…

Q: ***Please show steps on how to create the "userform" box"   Create a userform with two sets of…

A: The answer is written in step 2

Q: Use all arrays to display the selected employee data in HTML form inside table with default values…

A: Answer :-…

Q: For the UScereal data set, create a scatter plot of calories modeled by sugars using the shelf…

A: use this the code snippet in RStudio to start with this problem after loading dataset in R studio:

Q: Apply the Short Date input mask format to the selected field (StartDate). Do not change default…

A: We have to apply the Short Date input mask format to the selected field (StartDate) without changing…

Q: Global Variable Go to the jpf_hitori.js file in your editor. Directly below the comment section,…

A: 1. //Right click on file jpf_hitori.js //Select Edit menu and Open with →Notepad++ //Write the code…

Q: In the list of interest rates (range A13:A25), create a Conditional Formatting Highlight Cells Rule…

A: To create a Conditional Formatting rule in Excel to highlight cells that match the interest rate for…

Q: Open a new workbook and save the file with the name "Payroll". Enter the labels and values in the…

A: Open a New Workbook and Save:-Open Excel.Click on "File" and then "New Workbook".Save the workbook…

Q: 2 The Week worksheet contains data for the week of April 5. In cell D7, insert the appropriate date…

A: SOLUTION:-

Q: Show how to call the Str_trim procedure and remove all trailing "@" characters from astring.

A: call the Str_trim procedure and remove all trailing "@"

Q: the function fx = (e ^x)^ 2/ (x ^2)+5 where x E -2, 2 defined it as anonymous function and plot it…

A: Requirements:- Solution :- Please see below MATLAB code with output and read comments to get all…

Q: Phyton code

A: Explanation:- To read the csv file we use the read_csv() method and using the index_col=0 will make…

Q: Please help me to create the code!   Q. Use the pandas library, to load the iris dataset which…

A: In this question we have to write a python code using pandas to load the url and perform the…

Q: After Jill previewed her presentation, she realized that the chart she had chosen did not reflect…

A: Solution :

Q: Move the wto Collie.jpg file to the Images folder. Redisplay the contents of the Media_Files folder…

A: To move the "wto Collie.jpg" file to the "Images" folder, you can use the "mv" command in the…

Q: Writing a query, calculate the total number of pages of books which are published in or after 1980…

A: SQL stands for Structured Query Language which is a query language that is used to insert, delete,…

Q: One of the columns (named location) in my data frame (df_covid) is the countries of the world. How…

A: solution of the above question is answered in step 2:- we can use endswith to find the specific…

Q: Use NumPy to import engineering.txt and assign the result to variable data_1. Print the 4th element.…

A: Please find the answer below :

Q: Add a conditional formatting rule using the custom formula is option to highlight all customers in…

A: To apply conditional formatting to all customers in column E with the Default green backdrop who…

Q: Create below table and set the background color to 'red' and text color to 'blue'.

A: Provided the HTML code in order to create the table as shown above  and set the background color to…

Q: Create a “Signup” Form with fields (ID, first_name, last_name, age, gender, email, password and…

A: Here we create signup form with fields -ID,first_name,last_name,age ,gender,password and retype…

Q: te R code to create a visual dashboard for CBSE 12th standard exam results in 2021.

A: The answer given as below:

Q: 9. Write the R command for creating the following 5X5 matrix A [Image result for 5 x 5 matrix] 0 0 0…

A: According to our guidelines . we solve first three only:…

Q: Use MaxIFS to calculate the Highest Paid-in-Full Transaction Amount.

A: The statistical function that returns the maximum value among the range of the cells specified,…

Q: Identify the format element which is used to display a three-letter abbreviation day of the week O a…

A: The various format are year,yyyy,yy = Year month,mm,m = month

Q: Home Insert Design Layout References Mailings Review View O Tell me what you want to do. X Cut Copy…

A: Solution:

Q: Please do not give solution in image format thanku Finally, create a table with three columns. The…

A: creating  a table with three columns and compute the estimated body mass using the flipper_length_mm…

Q: Please do not give solution in image formate thanku.  Use escape characters in Python to align your…

A: Define the header labels for the table.Define the rows of the table with data about each…

Q: Question: Design a data entry form (as a sketch) with the title as "User Form", having the following…

A: Given question has  asked to design a data entry form(as a sketch) with the title as "User Form"…

Q: Italicize the contents of the range A4:A14 to separate the plant names from the rest of the data

A: In this question we have to understand how to change the font style of the contents from the range…

Q: Create a custom footer for the worksheet. In the left footer section, display the current Page…

A: 1. To create a custom footer on the worksheet, first switch to the Page Layout view by clicking on…

Q: Complete the code to show the result of the 10 factorials. Do not change anything on the codes Just…

A: int main(){ int a,fact=1; printf("enter the number"); scanf("%d",&a); for(int…

Q: Open the index html file and correct the doctype tag

A: Please find the answer below :

Q: Context for remaining questions Natural Language Processing (NLP) is the field of computer science…

A: The question does not specify any particular programming language for the solution. We have done the…

Q: Characterize a sub-square shape as an arranged pair of two cells ((x1,y1),(x2,y2)), indicating the…

A: Here have to determine about the conceivable batik shading mixes problem statement in python code.

Q: To freeze the row and column for a SPECIFIC cell and all the rows above and to the left of it,…

A: A row can be made fixed or a column can be made fixed or set of cells can be made fixed

Q: File Home Insert Page Layout Formulas Data fx [ e Insert AutoSum Recently Financial Logical Text…

A: To perform logical, mathematical and statistical operation in excel some formula is used, that is…

Q: Base the zooming concept, plotting N square shape with random color as shown in figure. Make axes…

A: Approach :- when we divide 121 by 1000 the remainder will be 121 .so we have to plot 121 squares.…

Q: html

A: Given :- An webpage that consists of an html code    Needs to do In the main content area, wrap all…

Q: Using the “Green Savings” worksheet, provide the formulas to calculate the savings for each computer…

A: Task:  Using the “Green Savings” worksheet, provide the formulas to calculate the savings for each…

Q: Your assignment must follow these formatting guidelines: Be typed, double spaced, using Times New…

A: Solution : The factor that matter while selecting a vendor for cloud-based storage solution should…

Q: Demonstrate how to create the tot credits (year, num credits) view, which displays the total amount…

A: Introduction: A view tot credits (year, num credits) utilizing relational data from the University…

Q: Use AverageIF to calculate the average dollar amount of the paid in full transactions in J4.

A: Formula: