Q-3 Sort the following elements using Selection Sort. 67 34 45 12 23 89 55 9. 60 18
Q: Why is Access a better tool than Excel for keeping track of this data?
A: Access and Excel are both Microsoft programmers. MS Access and MS Excel are two of Microsoft's most ...
Q: Problem 4 def yetanothertwoloops (n): for i in range (n): for j in range (10): print (n)
A:
Q: When did the mechanical computer first appear on the scene?
A: Given: When was the first time you saw a mechanical computer?
Q: Use an inline assembler and the cpuid instruction to write a program that finds out what type of pro...
A: срuid instruсtiоn саn be used in intel рrосessоr tо get срu sрeсifiс infоrmаtiоn. Оutрu...
Q: m + n = 2k + 2k = 4k therefore adding even numbers always gives an even number. The above is wrong ...
A: Yes , As we know that adding of two even is always a even number
Q: Write a program that uses two classes. The first class is called “dAta" and holds x and y coordinate...
A: Summary: -Hence, we have discussed all the points.
Q: Make a list of the many sorts of cursors
A: Answer: An SQL statement results in a cursor being created in system memory, which serves as a tempo...
Q: Write the differences between Von Neumann and Harvard architecture
A: ANSWER: DIFFERENCES BETWEEN VON NEUMANN AND HARVARD ARCHITECTURE: VON NEUMANN ARCHITECTURE: It is a...
Q: The number of goals achieved by two football teams in matches In a league Is given in the form of tw...
A: Please refer below code and output for the problem above: It contains proper comment at each line: l...
Q: Compile the pseudo-x86 program below into x86, placing all variables on the stack. movq $1, x movq $...
A: Summary: - Hence, we have discussed all the points.
Q: Write a program that accepts the lengths of three sides of a triangle as inputs. The program output ...
A: Start input three side check if square of largest side is equal to the sum of square of two smalles...
Q: Give at least 2 to 3 example each of when can we use Shell Sort in : Real word Computer science
A: Shell sort is a typical sorting method that compares each object to the element immediately before i...
Q: Create a program that will accept a certain size of link list and display the list, this program can...
A: C++ code to insert and delete element at nth position in linked list #include<iostream>using n...
Q: What command should be used to determine the graph of 2cos(x)- x1/2 + 5 from 0 to 3n? O >fzero(('2"c...
A: Answer below
Q: Consider the First Come First Serve (FCFS) algorithm for the scheduling of three processes A, B, C. ...
A: Turnaround time: To calculate turnaround time subtract Completion time with arrival time of desired ...
Q: 11. Consider the following grammar [15pts] 1. prog → A 2. prog expr ';' 3. expr → ID expr '-' expr e...
A: I have answered this question in step 2.
Q: 66. Given the following code segment, write Java code to read 10 numbers into the array named number...
A: logic:- use for loop to iterate input statement. I.e for(int i=0;i<10;i++) numbers[i]=in.nextDo...
Q: Write a console application that initializes at least five (5) variables or constants with different...
A: The program is written in C#. Check the program screenshot for the correct indentation. Please check...
Q: eate A Re Of A Particular Lang
A: Create A Re Of A Particular Language
Q: For the next two questions, consider the following portion of assembly code, which places two quad-w...
A: For the next two questions, consider the following portion of assembly code, which places two quad-w...
Q: 1. Give the name of a function that returns an int and generates a random number in the C Standard L...
A: 1. ions that allow us to get the absolute value of a number located in different headers. What two h...
Q: The manager of the company has informed his assistant to enter the age of all the workers working i...
A: Answer: Step 1: Code: while True: x = input('\nenter age:') age = x.split() for i in age: if i i...
Q: Translate the following hex numbers to RISC-V instructions. 1. 0x060000EF 2. 0x00000073 3. 0x0040...
A: Dear student, As per guidelines, I can answer only first three subparts. Please repost your other pa...
Q: Given two sorted arrays A and B, design a linear (O(|A|+|B|)) time algorithm for computing the set C...
A:
Q: Coding decision statements correctly improves programme efficiency. Why is programming efficiency cr...
A: The dependability, speed, and programming methodology utilised in producing codes for an application...
Q: IN your own words, how would you describe network services? * How would you describe network servi...
A: Network services allow you to connect to other people and share files and devices with them. You can...
Q: what does uncertain loop means ? using this example import random x=True while x==True: n=random.ra...
A: EXPLANATION: The uncertain loop refers to the loop whose number of iterations is not defined. The n...
Q: Create a function named mat_desc() that througouhly describes a matrix, it should: 1. Displays the s...
A: There is a shape function to determine the shape of a matrix. There is a size function to determine...
Q: in python write a function where it makes a dictionary from given text file. If no value is present ...
A: SUMMARY: - Hence, we discussed all the points.
Q: Create a program that gives the user to display the sum of first and second numbers, difference of t...
A: Given :- Create a program that gives the user to display the sum of first and second numbers, differ...
Q: loud: A rapidly growing company has outgrown its computing e nvironment and needs to upgrade. The ch...
A: Cloud: A rapidly growing company has outgrown its computing e nvironment and needs to upgrade. The c...
Q: Demonstrate the effectiveness of histogram equalization as a powerful adaptive contrast enhancement ...
A: Given The answer is given below Firstly save the following image as abc.jpg:- Using in-built functi...
Q: The mole balance equation for the phase separator is ziF=yiV + xiL.What does the F represent in this...
A: Mole balance equation is: ziF = yiV + xiL Here, F is total molar flow rate. V = vapour molar flow ra...
Q: When it comes to infrastructure and architecture, what's the difference?
A: The process of ensuring that technological systems and infrastructure are developed to fulfill busin...
Q: Find the recurrence relation for the worst-case time complexity of the following code. Explain your ...
A: T(n)=T(n-1)+O(n)
Q: Write a Python program that will generate 1000 random numbers between 1 and 100 inclusive from the r...
A: PROGRAM INTRODUCTION: Import the required libraries. Start the definition of getRandom method that ...
Q: Exercise 3 – XHTML and JavaScript Using XHTML and JavaScript you have create a web page that allows ...
A: The HTML is a markup language used for creating static webpages, the JavaScript is a scripting langu...
Q: Select all managers whose firstname starts with letter M and department they lead have less than 10 ...
A: Find the required query given as below :
Q: QUESTION 3 Write one ARM instruction to do the following operation? LDRH R6, [RO] ADD RO, RO, #10
A:
Q: . Use O notation to give asymptotic running times of the following algorithms in terms of the input ...
A: for(int i=1; i<n; i = 2*i) // Outer loop for(int j=0; j<n; j++) // Inner loop std::cout <...
Q: ABC Bank announced a new scheme of reward points for a transaction using an ATM card. Each transacti...
A: Answer: Step 1 Coded using C++. main.cpp #include <iostream> #include "HPVISACard.cpp" ...
Q: Given the following class definition, how would you instantiate it
A: An object is an instance of class and instantiating is a process of creating an instance for a class...
Q: I. Use Euler diagrams to determine if the following arguments are valid or not. 1. All dogs are an...
A:
Q: Given the following Context Free Grammar, sho derivation for the following strings. = ; -> ->
A: Consider the given Grammar :
Q: Create flowchart for constructing a Binary Tree.
A: let us see the answer:- A complete binary tree is one in which all of the levels are completely fill...
Q: 2. Consider the following pseudocode. Including the initial parent process, how many processes, main...
A: The process can be denoted as a program in execution. The threads can be denoted as the part of a sa...
Q: Write a class for the city database using unordered lists. Each database record contains the name of...
A: C++ code to make city database :
Q: What data science topics are you interested in learning more about? How might you apply some of the ...
A: INTRODUCTION: Following are the general topics in which most of the persons are interested: Statist...
Q: Consider the problem of computing the product of integers. That is, given an input A = a,, a, a) a s...
A: Here we have given pseudocode to find the sum of elements. we have identified a loop invariant in th...
Q: iagram of
A: Block diagram of a typical Asynchronous Communication Interface The figure shows a block diagram of...
Step by step
Solved in 4 steps
- herpever applicable 2. Title field in Instructor table should allow only Mr., Ms., Mrs., Dr., Prof. as values apply check constraintsMySql Workbench CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 1. List last name of all students whose first name is longer than 4 letters in ascending order accordingto the last name. Duplicated rows should be removed from the output.2. Count the total number of rooms in Location.3. Find the number of students in each major.4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...Apex, Salesforce In which you have two types of Record type on Position Object one is for Technical and one is non technical Record type. you have to write a SOQL query to fetch All the reocrd type of the ID of Technical Record Type. Please Run the SOQL Query on the Anonymous Window. also please attach the screenshot of the output.
- Alter the structure of the table Activities by adding a new column called 'ActivityDescription' of type Varchar2(100). This column will hold the description of each activity.Using the WideWorldDistributors database and the Sales schema create a function that takes InvoiceID as an input parameter and returns all the rows from the table InvoiceLines for the InvoiceID value passed into the function. If the result is a NULL return a zeroOpen the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.
- Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Answer in MYSQL pleaseImplement the above schema with its attributes and relation.• Drop the column PAdress from the above Person table.• Change the column PDesignation from above PersonOfficeDetails table VARCHAR (20) toVARCHAR (30).• Change the data type/definition of column POfficeAdress INT to TEXT from above PersonOfficeDetails table.• Rename Person Table to Person_AlterTable.• Insert one meaning full data on each table of your choice2- selects the order line items (orderNumber, orderlinenumber) fromthe “orderdetails” table. Also, display the subtotal (quantityOrdered * priceEach) for eachline item and sorts the result set based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantityordered (itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition“total” greater than 1000.8- Display product code, product name and text description for product.9- Find customer number, customer name, order status and order number, for customerwith their orders…
- WEEK 3 ASSIGNMENT This assignment contains two parts. You must complete Part I before moving on to Part II. Part I: Using the table you previously worked on, complete the following exercise: Insert a row into your student table where the last name is "Parker", first name is "Sam" and the ZIP code is "68134". You can determine the values for the remaining columns. Select a row from your student table where the last name equals "Parker". Select a row from your student table where the ZIP code is less than "68134". Select the student first and last name from the student table order by the state column. Part II: Complete the following exercise: Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state. Using your student table select all students with ZIP codes between “23164” and “98164”. Using your student table select all students where states are in Florida and New York. Using your…DTSC670: Foundations of Machine Learning Models Module 1 Assignment 2: COVID-19 Data Wrangling Name: The purpose of this assignment is to hone your data wrangling skills. Your task for this assignment is to perform the data preparation as instructed in the DTSC670_Assignment_2 pdf listed in Brightspace. After performing all the data preparation tasks outlined in the document, run the code in the "Prepare DataFrames for Grading" section. You are supplied an Excel file called BrazilcOVIDData.xlsx - be sure to put the data file in the same directory as this Jupyter Notebook. Please note that it may take around 5 minutes to read-in all of the data in this file. In [ ]: N ### ENTER CODE HERE ### # Insert as many cells as you need, but be sure your code is very neat and very well documented. In [ ]: N # Get Final Features DataFrame # features = ### ENTER CODE HERE ### # Get Final Response DataFrame # response = ### ENTER CODE HERE ###A social media application stored information about each registered user in the table create table user (id int primary key auto_increment, name varchar(100) not null) A user can have many "friends" and can also be a "friend" to many other users. Specify how this relationship would be implemented by coding the create table statement(s) for the tables.