Write a program that prints a letter. Ask the user for the receiver’s name, a topic (any string), and the sender name. Your program should print a letter like this:

Hi *receiver*,

This is *sender*. I would like to discuss *topic* with you.

Call me.Regards,

*sender*

Given the growth in telecommuting and other mobile work arrangements, how might offices physically change in the coming years? Will offices as we think of them today exist in the next ten years? Why or why not?

Please note that there are two posts needed to successfully complete the discussion board assignment. An initial post addressing the discussion board topic is due by end of day Saturday. A response post to at least one other student is due by end of day Tuesday.

Look for a tutorial on how to create a database, and share it with the class. What type of RDBMS (Oracle, SQL Server, MySQL, DB2, Informix) is this tutorial? Is the tutorial complete? Do you think that you can follow it to create a database on your own?

To apply all acquired knowledge in the last Project Assignments to create a Database Scheme. For this project, the ERD is provided to you.Deliverables:

• SQL Script with your name as follows: YourLastName_Project_Ph3.sql.
• MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.
• ZIP file to include the two files mentioned above.

Required Software:

• MySQL DBMS by Oracle. MySQL Community Server and MySQL Workbench.
• Follow Step 1-3 for your Course Project Phase phase 1, to install the required software components.

Lab Steps:Step 1: Analyze the ERD for a student information system provided below. Be alert for the specifications provided for: 1) Entities, 2) Attributes, 3) Primary Key, and 4) Relationships.  You will need to have a clear understanding for these components to create your database using MySQL. Step 2: Create a New Database in MySQL, Produce SQL File, Drop Table

• Create a new Database, as you did in your Course Project Phase 1 deliverable and you already created a database using the MySQL DBMS.  Reference the attached video (Course Project Ph1 Video.mp4), for a demonstration to create a new Database using MySQL. This video was initially presented to you for phase 2 of your project.  Also, reference the supplemental text: Available for Free download as part of our UC Library.  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill. ISBN: 978-0-07-160550-2.  Link to UC Library: http://search.ebscohost.com/login.aspx?direct=true&AuthType=shib&db=nlebk&AN=291311&site=eds-live&ebv=EB&ppid=pp_ii
• Utilize the SQL dialect you learned so far in this course for MySQL.  Use the file supplemental textbook:  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill, as supplement your knowledge of the MySQL dialect. 
• Create your SCRIPT file to be named: YourLastName_Project_Ph3.sql.

Step 3: Include the following commands at the tops of your scripts:

• SET FOREIGN_KEY_CHECKS=0;
• DROP TABLE IF EXISTS STUDENT;
• DROP TABLE IF EXISTS CAMPUS;
• DROP TABLE IF EXISTS ROOM;
• DROP TABLE IF EXISTS COURSE;
• DROP TABLE IF EXISTS INSTRUCTOR;
• DROP TABLE IF EXISTS APPROVED_INSTRUCTOR;
• DROP TABLE IF EXISTS CLASS;
• DROP TABLE IF EXISTS STUDENT_GRADE;
• SET FOREIGN_KEY_CHECKS=1;

Step 4: Create Tables in your database

• Create a new Table for each of the entities provided to you in the ERD diagram in Step 1.
• Add a column to represent each attribute addressed in the ERD diagram in Step 1.
• Designate Primary Key, as noted in the ERD diagram in Step 1.
• Designate a Foreign Key relationship between the tables, as noted in the ERD diagram in Step 1.
• Enable referential integrity on the relationships, as needed.
• Enable cascade updates as needed on the relationships.

Step 5: Designate Data Types. Update the data type as needed to enforce the domain constrain of the data. This needs to be completed for every column for all tables.

• Dates: they should have a date data designation type.
• Surrogate keys: shall be auto-numbered
• Character type: shall have a character data designation type.

Step 6: Column Constraints Designation.

• Grade designation must be of one of these values as follows: A, B, C, D, F, I, W, E (E=enrolled, and W = withdrawn).
• Student’s first and last names are not to be designated as NULL.
• Course Credit hours shall be BETWEEN one and four.
• The instructor first and last name must NOT be NULL
• Course name designation has to be UNIQUE and must not be NULL type.

Step 7: Data Table Addition

• Use the INSERT operator to add minimum 2-3 rows of data per each database.
• You are free to use any values you might like for each of the columns.
• NOTE/ Reminder: you are required to add data to the parent table prior to adding any data to child tables, as referential integrity is enabled.

Step 8: Executing your SCRIPT

• Must incorporate the COMMIT command at the end of your Script
• Must incorporate the SHOW TABLES command, to display the table you created. At the end of the script created.
• Must incorporate the SELECT statement to show data allocated for each table. This would be added at the end of the script.
• EXECUTE your SCRIPT.
• Copy and paste your OUTPUT into your MS Word file as follows: YourLastName_Project_Ph3_Output.doc

Step 9: Upload your work

• Upload ZIP file to include the two files as follows: 1) SQL Script with your name as follows: YourLastName_Project_Ph3.sql, and 2) MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.

Rubric:

• Tables Created: create a table for each entity as noted in the ERD diagram in Step 1. 5 points
• Columns Created: create a column for each attribute as noted the ERD diagram in Step 1. 5 points
• Primary Key designation: primary key addressed for all tables with unique constraints specified as column properties. 5 points
• Data Types: Addressed for each attribute. Should include: 1) Date data type incorporated, 2) Surrogate Key Automated, 3) Numeric data shall be numeric type, 4) Character data shall have a character type. 5 points
• Relationships Created, as noted in the ERD diagram in STEP 1. Relationships shall be enabled for referential integrity and cascade updates. 10 points.
• Data Added per row: 5 rows of data for each table. 10 points
• Column Constraints Added: As noted in the description for the project. Checked by adding rows with invalid values. Should take into consideration constraints as follows: 1) student name cannot be NULL, 2) course credit hours are restricted to allocations between 1-4, 3) course name is unique and NOT NULL, 4) instructor last name and first name can NOT be NULL, and 5) grade restrictions to the following values: A,B,C,D,F,I,W, E. 10 points

Week 1 Assignment

• Describe the concept of a “system.” Though these are the characteristics of any system,  relate it to information systems, as best as you can.
• Also, describe your understanding of System Analysis and Design.

Submit a one to two page paper in APA format by Sunday 11:59 PM. You are welcome to submit drafts for the instructor’s comments.

For APA format, include a title page. Include an abstract statement on page two. Add the body on pages 3 & 4. Put  your references on page 5. Use more than one reference for your information. Use Times New Roman 12 point font, double-spaced through the entire document. Indent paragraphs in the body. The abstract is not indented.

You can use the APA template and References tab in MS Word for easier formatting.

Social engineering is the art of manipulating people so they give up confidential information. The types of information these criminals are seeking can vary, but when individuals are targeted the criminals are usually trying to trick you into giving them your passwords or bank information, or access your computer to secretly install malicious software – that will give them access to your passwords and bank information as well as giving them control over your computer.

Explain a scenario where you or someone you know may have unknowingly given too much personal information to a stranger. How could this situation  been avoided?

Reference Article Link: 

https://www.webroot.com/us/en/resources/tips-articles/what-is-social-engineering

 Exp22_Excel_Ch12_CumulativeAssessment_Variation_Teaching_Schedule 

 Exp22 Excel Ch12 CumulativeAssessment Variation Teaching Schedule 

Excel Chapter 12 Cumulative Assessment – Variation Teaching Schedule 

Project Description:

You have just started your first career as a high school teacher. To jump start your planning process, you would like to create a teaching schedule template to help plan your weekly tasks. You will create a template, create custom macros to automatically insert dates, and inspect the document for issues.

Start Excel. Download and open   the file named   EXP22_Excel_CH12_Cumulative_Assessment_Variation_TeachingSchedule.xlsx.   Grader has automatically added your last name to the beginning of the   filename. 

Clear all data validation in the   range A1:G19. 

Delete the sample text in cell   B2

Type Teaching Schedule in cell B1.

Type Prepared by: in cell F1.

Delete the value in cell G1.

Add the following comment in   cell G1 Enter Name.

Type Monday in cell C4 and use the fill handle to fill the   range D4:G4 with the remaining days of the week. 

Use the document inspector to   inspect the document. Remove document properties and personal information and   then click or select close.
 

  Note: Mac users, from the Excel menu, open your preferences, click or select   Security, and then click or select the check box to Remove personal   information from this file on save.

Use the accessibility checker to check the document for issues.   Accept the recommended actions for merged cells and use the recommended   action to select Rose, Table Style Medium 23. Close the accessibility checker   pane.

Record a macro named ClearSchedule using the shortcut   CTRL+SHIFT+J. Add the description When run, this macro clears the values in the schedule (no period). When run, the   macro should delete the values in cell G1 and in the ranges C3:G3, C5:G6,   C8:G9, C11:G12, C14:G15, C17:G19, in that order.

Create a form control button   that fills cell F2. Assign the ClearSchedule macro and edit the button text   to Clear.

Create a form control button   that fills cell G2 and edit the button text to Insert Dates.

Open the VBA editor and create a   new module named DateStamp. Create a procedure named InsertDate. Insert the comment Inserts   weekly dates,   then enter the following code Range(“C3:G3”) = Array(Date, Date + 1, Date +   2, Date + 3, Date + 4)   and exit the VBA editor.

Assign the InsertDate macro to   the Insert Dates form control button.

Test both macros and then open   the VBA editor. Locate the module containing the ClearSchedule macro. Copy   the code and paste it starting in cell B2 in the Code worksheet. 

Locate the module containing the   InsertDate macro. Copy the code and paste it starting in cell D2.

Check the document for   compatibility with Excel 2016 and 2019.
 

  Note: Mac users, skip this step.

Save EXP22_Excel_CH12_Cumulative_Assessment_Variation_TeachingSchedule   as a macro-free workbook and close it. Exit Excel. Submit the file as   directed.

Cyber threats and trends

Section 1 — Upload final data file

Section 2 — Business/research questions

1. Using BRFSS data set, state the three business or research questions that you have attempted to answer through your analysis, and justify why they are interesting (300 words maximum)

Section 3 — Processing the data

1. Describe how you explored the data, why you did it that way, and what conclusions you drew about it (300 words maximum)

2. Describe the cleaning/fixing you did on the data, and why (300 words)

Section 4 — Data analysis

3. Explain what analysis techniques you used to answer your business/research questions, and why (300 words maximum)

4. Summarise the results of your analysis (300 words maximum)

5. What do the results say in answer to your business/research questions? (300 words maximum)

6. Describe the most salient threats to validity that remain in your analysis (300 words maximum)

Section 5 — Dealing with large data sets

7. Describe how you could represent the data in a relational database — give a suitable schema, and describe a mechanism for converting it to a suitable input form for WEKA (300 words maximum)

8. Describe a way that you could use appropriate technologies to spread the load over multiple computers, and justify why this would be a good approach (300 words maximum)

Section 6 — Privacy

9. List the three most salient privacy issues related to this analysis, and give strategies you could use to address each of them (300 words maximum)

Section 7 — Report references

10. Provide a correctly structured list of references to all the resources used for this development and report (no word limit)

 What is the weakest link in the security of an IT infrastructure?  What are some of the strategies for reducing the risks?