Database and SQL

The project/assignments involve: 1) database concepts, 2) use of SQL , and they 3) must be devoted/in-line-with the textbook (which I will provide to you). Please note that I’ll also require the expert to have a grasp on the english langauge, given the assignment requires PROFESSIONAL, business-level writing and reading of english language.

Message me if you meet these requirements. Thanks!

Add functions to original code

The reader thread should then insert
the input into a queue (buffer). The main thread will be responsible for dequeuing the input and processing it, just like in Assignment 3. This is essentially the Unbounded Buffer Producer-Consumer problem
where the reader thread is the producer, and the main thread is the consumer. Your program must be
compiled to an executable called miner. The program will read in five events, which are the same as in
Assignment 3. Please see the Problem Statementsin Assignment 1, 2 and 3 for a description of the events.
The reader thread should consist of a loop that reads events from stdin and enqueues them onto an
unbounded queue. The queue can never fill up, so a linked-list implementation is recommended.
The main thread will use the same main loop as in Assignment 3, except that instead of reading from stdin
it should dequeue events from the queue fed by the reader thread and process the events. Please note
that if the queue is empty, the main thread should block until more events are added by the readerthread.

From the dist directory you will execute your program from the command line with two filenames asarguments, input file name and output file name. For example:
java -jar lab5.jar..input.txt ..output.txt
Write a java program that will prompt the user for two city and province names from a select list.
Read each of the records from the input file and extract the two records that match thoserequrested by the user.
Define a class named Cruncher which will do all the ‘heavy lifting’ in this program.
The main line of your solution will look exactly like this:
public static void main(String[] args) {   if(args.length < 2)   {   System.err.println("Usage: java -jar lab5.jar infile outfile");   System.exit(99);   }   Cruncher dataManipulator = new Cruncher(args[0], args[1]);   dataManipulator.openFiles();   dataManipulator.findDistance();   dataManipulator.writeRecords();   dataManipulator.closeFiles(); }
Latitude is measured in degrees and minutes with zero at the equator and 90 degress at the North pole or South pole. Latitude has to be expressed as North or South. There is usually a third number, seconds but it is not in our data, just degrees and minutes. Longitude is also measured in degrees and minutes with zero located a little outside London England (Greenwich). Longitude must be expressed as West or East and it ranges from zero to 180 degrees. All the data in Canada will be North and West and simplifies our calculation a little bit.
Here is the code to calculate the distance between two cities given longitude and latitude:
double earthRadius = 6371;  // in km  double distance = Math.acos(Math.sin(Lat1) * Math.sin(Lat2)   Math.cos(Lat1) * Math.cos(Lat2) *  Math.cos(Long2 – Long1)) * earthRadius;The values you feed into the trig functions are in radians. You will be readingstrings of text in degrees and minutes. So your program will have to convertstrings to doubles as degrees and minutes and then convert those doubles todecimal degrees and then convert that to radians. Here is a non-Javadescription of what I mean:
degree = 23 minute = 45 decimaldegree is then 23.75 because there are 60 minutes in a degree ( our data does not have seconds ) radians = decimaldegree * PI/180

These 2 for my final assignment

For each new class that you have created, create an interface that defines its behavior, then require your class to implement it. Omit one or two methods and try compiling. What does the error look like?
Create a small program that defines some fields. Try creating some illegal field names and see what kind of error the compiler produces.
In the program you created, try leaving the fields uninitialized and print out their values. Try the same with a local variable and see what kind of compiler errors you can produce. 

Address calculation and instruction count

Show the matrix base address (of A, B and C) in hexadecimal.
Report the size of a double floating point number.
Report the size of the matrix, in bytes.
For each of A, B and C, report the address of:array[0][0]

Give a formula for calculating the address of element i,j of the matrix.
Is this row major or column major form of storing a matrix?
Compile your C program to assembly (“-S” option on compile).
Edit the assembly program, adding comments. Ignore everything except the matrix multiply portion:Identify the loop controls. How many nested loops are there?
Identify the instructions that calculate the element addresses for A, B, and C matrix elements.
Identify the actual floating point multiply and adds.
Identify what variables are kept in CPU registers.

Calculate the total number of instructions in the matrix multiply.
Parts of this will be kind of a hassle, because of the complicated x86 and ARM addressing modes (MIPS is simpler). Submit the edited assembly source, and a report (in PDF) with the answers to the other questions. Submit them in a tar or zip file.

Matrix multiplication: CUDA GPU

The first CUDA example doesn’t have any performance measurement code. Add some, and tell me how many clock cycles the overhead is for just a simple operation like that one.
The code here measures only steps 3 to 5 of the five-step process of working with the GPU, from copying data to the GPU to copying it back. Modify the code here to measure both that and just the parallel execution portion. How much is the overhead, and how much is the parallel execution? How does that match your understanding of Amdahl’s Law?
Assuming that one clock cycle (a delta of 1) is 1/2.2GHz seconds, calculate how many FLOPS we are getting out of the GPU.

Select the correct statement(s) regarding Internet Exchange Points (IXPs) and/or Network Access Points (NAPs).

a. IXPs and NAPs are facilities that enable interoperability between autonomous systems at OSI layers 1, 2, and 3b. peering agreements between Internet Service Providers (ISPs) within an IXP or NAP ensures the proper counting of exchanged packets and the application of appropriate surchargesc. IXPs and NAPs are facilities that enable the direct connection of privately owned intranets to the Internetd. all statements are correct

write a (single-threaded) program in C that multiplies two square matrices

write a (single-threaded) program in C that multiplies two square matrices. Report its performance. Your program should have the following characteristics:
Use double-precision floating-point numbers.
The matrix size should be compiled in, using a #define for the size.
It should initialize the matrix with some numbers; I don’t care what they are.
There should be three matrices; A, B, and C. Multiply C = AB.
It should measure the time for doing the matrix multiplication. There are several techniques for doing this.
Report the time for multiplying matrices of size 10, 100, 1000, 10000. Report the memory size of the matrices, as well.
Include your source, evidence that the program runs, and a report on this performance. That’s either two or three files. Submit them as a tar file or a zip file.
This is a pretty good explanation of arrays in C, perhaps more info than you need right now:…

SWE 440 DIC 3 software project mange

You assignment is to research and describe the following functions that are part of the software project planning process and how they impact the overall project.
The functions are:
Risk assessment
Work breakdown schedule
Human resource plan
Project team
How to identify the appropriate stakeholder for the project
Responses to Other Students: Respond to at least 2 of your fellow classmates with a reply of at least 100 words about their primary task response regarding items you found to be compelling and enlightening. To help you with your discussion, please consider the following questions:
What did you learn from your classmate’s posting?
What additional questions do you have after reading the posting?
What clarification do you need regarding the posting?
What differences or similarities do you see between your posting and other classmates’ postings?