Get a Freelance Job

Use the database and tables from last week’s assignment to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the Del Mar store. Check results by selecting all columns from both tables.

(You are to put all your screen snapshots for the items below, each showing the required SQL statements and results, in order, in a single Microsoft Word file. Failure to do so may result in lost points on this assignment.)

Using the database and tables from Week Two, write SQL statements and enter the records into the Employee table for the workers identified in the Employee Files for the administrative offices and the Del Mar location. Check the results by selecting all of the columns from both of your tables. You should now have 17 total employees and 9 total job titles (2 points)

Using the database and tables in Week Two, write SQL queries using Between, Like and Union: (1 point each)

Using struct and class data type to write a simple student records report program with sorting function
This project is an elaboration of Project 3 ( Student Records Report Program). However, it requires using selection sort algorithm to sort student records and print out student records in a certain order; and using cstrings stead of strings to store student names and SSN numbers.
Use Visual C++ to write your program.
As records secretary for Cougar High School, you have been asked by the principal to prepare a report on the grades of some of the school’s top athletes. Specifically, you must print each of the athlete’s average letter grades based on their scores from three academic courses. Input will be taken from the file stufile.txt, which is organized as follows: Each athlete in the file has four lines of information recorded – name (at most 20 characters including the comma and white space), student ID (SS#), class rank (1=Freshman, 2=Sophomore, 3=Junior, 4=Senior), and the three scores. Information for at most 15 athletes is stored in the file, but the first line of the file contains an integer showing the exact number of athletes.
Use struct data type as data representation of a student record and use separate fields for first names and last names. Then, define a class to hold an array of student records and encapsulate some member functions which will be used to do the specified reporting as described in the following. Look at the sample specification file proj2_prototype.h for the suggested data type declarations.
You can assume that all scores are integers from 0 to 100. Output should be printed out on screen. Athletes’ names ID numbers, class, ranks, and, letter grades are to be printed twice, the first time in alphabetical order by last name, with “A” students first, “B” students second, and so forth. In cases when the last names of more than one students are the same, sort the student records with the same last name in alphabetical order by first name. The second time they are to be printed in alphabetical order by last name, with freshman students first, sophomore students second, and so forth. Also sort student records by first names in cases when last names are the same. (Note the difference from Project 1.) Note that the students’ names are printed out in the format of “Lastname, Firstname”, e.g., “Zitt, Kevin”; the column of student ID numbers should be aligned at least one space beyond the maximum name length, the column of class ranks should be aligned at least one space beyond the column of student IDs, and the column of grades should be aligned at least one space beyond the column of class ranks.
A sample implementation file of the class member functions and a main function is written in file proj2_prototype.cpp. In the main function, there is an outline of the suggested steps to do the reporting job.
Turn in a print-out of the program source code and a diskette containing the header (.h) file, source code (.cpp file), and the I/O files.

We would like our PhpFox members to have last names. The last names will need to integrate with a pre-existing bridge between the PhpFox website and an opensim based site on a separate server.

Project #1

Save all of your code in Notepad as a *.txt file and attach it when you submit the project. Take screen shots of all successful implementation of each set of SQL.

Data Changes and SQL Statements

Resource: Table Queries assignment

Use the database and tables that are attached to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the store. Check results by selecting all columns from both tables.

Between, Like, and Union:

Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use salary to restrict data.

Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use hire dates to restrict data.
Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use telephone area codes to restrict data.

Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use age to restrict data.

Write a SQL query that uses the UNION of the two tables to produce a third table.

Save each query in a txt file and take a screen shot of its results and submit them as an attachment.

Group:

Use the updated database to write the following queries, using the SQL GROUP statement:

Select employees’ last names and group them by EEO-1 classification.

Select employees’ last names and group them by salary.

Select employees’ last names and group them by salary in their EEO-1 classification.

Select employees’ last names and group them by salary in job titles, grouped into exempt and non-exempt.

Save all the SQL statements in a txt file and submit as an attachment.

Screen Shot