An independent real estate firm that specializes in home sales needs to create a database in which to store its records. In the following project, you will open a database containing information about the properties the real estate firm has listed. You will work with a table in which to store agent information, and then sort the table. You create a relationship between two tables and enforce referential integrity. You also apply filters, sort a table, and save the results.

Start   Access. Open the downloaded Access file named   Exp19_Access_Ch01_ML1_Home_Loans.accdb. Grader has automatically added your last name to   the beginning of the filename.

Open the Agents table in   Datasheet view, and add the following records letting Access assign the   AgentID number:

FirstName   LastName Title
Guillaume    Picard    Broker
  Keith    Martin     Agent
  Usa-chan    Yang     Agent
  Steven    Dougherty     Agent   in Training
  Rajesh    Khanna    Agent in Training
  Juan    Rosario  President

Sort the Age nts table by the LastName field in   ascending order.

Apply a selection filter so that   everyone with a title other than Agent   in Training displays. Save the changes to the table design and close the   Agents table.

Open the Properties table in   Design View. Change the data type for the specified fields as follows:

Field Name    Data   Type
  DateListed   Date/Time
  ListPrice   Currency
  SqFeet Number
  Beds Number
  Baths Number
  AgentID Number

Save the changes to the design   of the table. Access will alert you that some of the data in the table may be   lost due to changing the data type of the fields listed above. Click Yes then view the table in Datasheet   View.

Sort the records in the   Properties table by the ListPrice field from largest to smallest.

Use Filter by Form to create a   filter that will identify all properties with a list price less than $300,000 and with 2 beds. Apply the filter and   preview the filtered table. Close the table and save the changes.

Close all database objects.   Close the database and then exit Access. Submit the database as directed.

 1 page 

After having the opportunity to complete the course, what would you change and why? What topic particularly caught your interest and what do you want to know more about?  Last, but not least, if you could share with the next class one piece of advice about this class, what would it be? Please note that this pertains to the class, the materials, flow/organization, etc.

Your comments may be shared with incoming students with no identifying information. Thank you and good luck on your educational journey!
(No participation replies required but encouraged!)

The chief technology officer (CTO) has indicated that your organization has been requested by the National Security Council (NSC) to comment on the upcoming National Cybersecurity Strategy. The NSC has asked for specific recommendations as it relates to the next cybersecurity strategy, private/public partnerships, and comments on how specific technologies should be incorporated into the assessment.

The CTO has asked you to collaborate with your team to provide the organizational input.

Use the Cybersecurity Strategy, Law, and Policy Team Assignment Template to write your paper, which should cover the following topics:  

Part 5: Cybersecurity Technologies

• The authors of the National Security Strategy (NSS) are looking to address particular technologies that have the opportunity to revolutionize cybersecurity. They believe that blockchain technology is a revolutionary technology that has the ability to significantly improve cybersecurity.
  • What would be your recommendation for how the NSS should incorporate this technology to the public?
  • Propose exactly what you believe should be written in the NSS. Specifically, explain the blockchain technology in layman’s terms to nontechnical people that may be reading the NSS, give examples of how it could be used to provide revolutionary cybersecurity, include examples of how it is being used to provide cybersecurity solutions, and discuss what, if any policies or laws should be established to mandate its use in specific industries.

 I only need part 5 done.

 Statistics for Data Science. 

1. Current occupation and employer (if applicable)
2. Experience and/or background with statistics 

Why study statistics?  

Modern computing power is causing a revolution in data analysis. Key drivers have been the rapid development of new technology, access to more and bigger data, and the greater use of quantitative analysis in a variety of disciplines: 

1. Why is computing power so influential in data analysis?
2. Why is almost any sort of data so valuable to the companies and the governments? 

• Complete the discussion by the assigned due date.  
• Do not claim credit for the words, ideas, and concepts of others. 
• Do not copy and paste information or concepts from the Internet and claim that it is your work. It will be considered Plagiarism and you will receive a zero for your work.

What changes are necessary to support the current times and future times of the uses of operating systems to allow a more consistent model across many different hardware platforms? 

how Alexa interact with home devices

Week 2 Assignment

Chapter 3 –discussion question #1-4 & exercise 12 

Chapter 4 – discussion question #1-5 & Case pg. 243 

The Target story answer the two case questions on page 244 integrating concepts and examples from that case. 

The above assignments should be submitted in one-word document.Include an APA cover page and a reference page. 

Create a project that calculates the total of fat, carbohydrate, and protein calories. Allow the user to enter (in text boxes) the grams of fat, carbohydrates ,and protein. Each gram of fat is nine calories. Each gram of carbohydrates and protein are 4 calories.
Display the total calories for the current food in a text box. Use two other text boxes to display an accumulated sum of calories and a count of items entered.
Include buttons to CALCULATE to CLEAR the text boxes and PRINT and EXIT buttons.

 What resources can you find to help with the project’s task of using PHP and inserting data into MySQL? Please use this area to share at least 2 resources with a quick summary of each.In addition, as you work through the assignment, what issues have you run into? What are you stuck on? What questions do you have to move you forward? 

Payroll Lab

You will be taking in a file (payroll.txt) which details a number of departments (at least 1) and in each department are a set of employees (each department will have at least 1 employee or it would not appear on the payroll sheet). Your job is to read the file in separate out each employee and calculate the total values (hours, salary, number of employees) for each department and in each category (F1, F2, F3, F4). In your final submission please include the .cpp file which should work for any kind of payroll file I supply (which will naturally match the format of the examples below). Be sure to indicate in your submission text if you have attempted any of the bonus points .

An example file:

The IT Department
Bill 8 7 8 9 7 F1
Bob 205103 0.08 F3
Betty 8 8 7 8 8 F2
Brandon 10 10 9 6 9 F2
Brad 9 8 10 9 9 4 1 F4

The Sales Department
Kyle 88840 0.105 F3
Tyler 105203 0.085 F3
Konner 8 6 7 6 9 F2
Sam 309011 0.045 F3
Kent 9 8 9 9 9 0 0 F4
EOF

An additional example file:

The Sales Department
Mike 5 6 1 3 5 F1
Mark 98103 0.115 F3
Jill 8 8 8 8 8 F2

Frank 106101 0.095 F3

Mark 76881 0.091 F3

Department of Records
Konner 8 6 7 6 9 F2
Tammy 7 3 7 2 8 F1

Anika 8 8 8 8 8 F2

Marta 1 0 0 5 2 F1
Kent 9 8 9 9 9 0 0 F4
EOF

Last in the row after the hours comes the pay grade (F1, F2, F3, F4). The number of hours recorded is based on the pay grade of the employee. F1 and F2s will have 5 numbers for their hours. F3s are commission based where a sales amount and a commission percentage is given. F3s are also assumed to work 30 hours if their commission is 10% or below and 40 hours if their commission is above 10%. F4s will have 7 numbers (as they are on-call during the weekend). Each of the pay grades will also have different pay calculations which are as follows:

F1 = The total number of hours * 11.25
F2 = (The total number of hours – 35) * 18.95 + 400
F3 = The total sales amount * the commission rate
F4 = The first 5 hourly totals * 22.55 + Any weekend hourly totals (the last 2) * 48.75

Your output to the screen should start with the department name, followed by the total pay for all of the employees, then the total number of hours, and the total number of employees. After that you should have a breakdown of each category of employee: F1 total pay and total hours, F2 total pay and total hours…

Each department will have at least 1 employee and each department will contain the word “Department.”

The IT Department
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##
Roster: Bill, Bob, Betty, Brandon, Brad 

F1:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F2:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F3:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F4:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

The Sales Department
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##
Roster: Kyle, Tyler, Konner, Sam, Kent

F1:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F2:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F3:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F4:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

Before coding your solution, take the time to design the program. What are the possible things that the file can have that you need to anticipate? What are the actions that you need to take (read the file, add up hours…)? Are those actions things that could be placed in separate functions? What about the function – can you guess some of the things that will happen? Such as, using substring to pull out part of a line in the file maybe using stoi to convert a string to an integer to add it to the total or creating variables to hold the employee type you find before passing it to another function. Finally, how are these functions called, what is the order and what information is passed to and from? 

Scoring Breakdown

25% program compiles and runs
30% program reads in and calculates the figures for output
10% the program is appropriately commented
35% outputs the correct information in a clear format 

5% bonus to those who can output the F# responses in a columned output like that shown above.

5% order the employees in the roster according to their F status, F1’s first, then F2’s and so on.
5% bonus to those who do a chart comparing the data at the end to show the relation between the pay grades and the amount of salary spent in each (they style of chart is up to you and more points may be given for more difficult charts (like a line chart):

B Department
F1 – 00000000
F2 – 000000
F3 – 00000
F4 – 000000000000 

K Department
F1 – 0
F2 – 0000
F3 – 0000000000
F4 – 0000000 

Or event something like this instead:

0
0 0
0 0 0
0 0 0 0
0 0 0 0
F1 F2 F3 F4