Encryption

 

1). Using the Web or other resources, write a brief paper about RSA, its history, its methodology, and where it is used.

2). Send a brief message (ten words minimum) using the Caesar Cypher.

MGT311 week 9

Page 498, Skill Builder 15.1
What Would You Do?
Three people applied to you for an opening as a lathe operator. One is totally unqualified. One is experienced, but has a poor attitude. The third lacks experience, but seems especially eager for the job; you think she would be a good worker if she had more experience, but you’re not sure. You have some rush work you need to get out. Which of the following courses would you choose?
1. If the eager applicant has good references, hire her for a probationary period. But keep looking for a more qualified person in case she doesn’t work out.
2. Pass up the three applicants. Keep looking.
3. Hire the experienced person, ignoring his attitude—you’ve got work to get out!
Question 1: Say what you would do and why you would choose that option.

Pages 499-500, Case 15.1
Question 2: What avenues are now open to Trent? What des this case say to you about the need for supervisors to act morally?

Exp19_Access_AppCapstone_Comp – Drivers 1.0

Exp19_Access_AppCapstone_Comp – Drivers 1.0

Exp19 Access AppCapstone Comp Drivers 1.0 

Access Application Capstone – Comp Drivers

  

Project Description:

In this project, you will add fields to a table and set data validation rules. You will also import a text file into a database, design advanced queries, and create a navigation form. Additionally, you will use SQL to modify a record source and create an embedded macro to automate opening a report. Finally, you will create a pie chart in a report.

     

Start   Access. Open the file named Exp19_Access_AppCapstone_Comp_Drivers.   Grader has automatically added your last name to the beginning of the   filename. Save the file to the location where you are storing your files.

 

You   have discovered that the insurance company data that you want is stored in an   external text file, so you will import the file as a table in the database,   and not need to design the table from scratch.
 

  Create a table in the database by importing the downloaded delimited text   file named Insurance_Text.txt. Use   the first row of the file as field names, use InsuranceID as the primary key, and then name the table InsuranceCos_Text. Accept all other default options. Do   not save the import steps.

 

You   will modify a table to add fields that store the websites and photos of   agents, add a lookup field, and set data validation to ensure that valid   values are entered in a field.
 

  Create a new field in the Agency Info   table after InsPhone named Website with the Hyperlink
data type. Save the table. In Datasheet view,   add the website http://William_Smith.com   to the
William Smith record (Record 1).

 

Create   a new field in the Agency Info table after Website named AgentPhoto   with the Attachment data type.   Save the table. In Datasheet view for Record 1 (William Smith), add the downloaded picture file named WmSmith.jpg to the AgentPhoto field.

 

Set   the validation rule of the InsuranceCo   field to accept the values AS,   NAT, or SF   only. Set the validation text to read Please enter AS,   NAT, or SF. (include the period).

 

Make   InsuranceCo a lookup field in the   Agency Info table. Set the lookup to get values from the InsuranceID field in the InsuranceCos_Text table. Accept all   other defaults and save the table. In Datasheet view, select the first InsuranceCo value, type AT and press ENTER. Click OK in the   message box, press ESC, and then close the table.

 

You   will create queries to locate records that have missing values, update values   in a table, and delete specific records from the database.
 

  Create a new query using Design view. From the Insurance table, add the DriverID, AutoType, TagID, and TagExpiration fields (in that order). Save the query as Missing Tag Dates.

 

Set   the criteria in the TagExpiration   field to find null values. Run the query (two records will display). Save   and close the query.

 

Create   a new query using Design view. From the Drivers table, add the Class field. Change the query type to   Update and set the criteria to   update drivers whose class is Minor   to Junior. Run the query (eight records will   update). Run the query again and note that there are no records to update.   Save the query as Driver Class_Update   and close the query. View the updates in the Drivers table and close the   table.

 

Create   a new query using Design view. From the Drivers table, add the Class field. Save the query as Driver Class_Delete.

 

Change   the query type to Delete and set   the criteria to delete drivers whose class is Special.   Run the query (one record will be deleted). Save and close the query. View   the changes in the Drivers table and close the table.

 

Create   a new query using Design view. From the Insurance table, add the InsuranceAgentID, AutoType, AutoYear, and TagID fields   (in that order). Save the query as Agent_Parameter.

 

Set   the criteria in the InsuranceAgentID   field to display the prompt as Enter the Agent   ID:   and run the query. In the parameter prompt, enter AS8842   and click OK to view the results   (two records). Save and close the query.

 

The   Performance Analyzer makes suggestions as to how a selected table can be made   more efficient or to work better with other tables in the database.
 

  Use the Analyze Performance tool to analyze the Drivers table. Note the idea   to change the data type of the Weight field from Short Text to Long Integer.   In the Drivers table, set the data type of the Weight field to Number   (Long Integer), then save and close the table.

 

A   navigation form enables users to select key objects in the database in a   user-friendly manner. The form will launch automatically to present the   frequently used forms and report to the end users.
 

  Create a Navigation form based on   the Vertical Tabs, Left template. Drag and drop the Drivers form onto the first tab of   the form. Drop the Insurance form   onto the second tab.

 

Drag   and drop the Drivers report onto   the third tab of the Navigation form. View the form in Form view, click each   of the tabs, and then save the form as Navigator.   Close the form.

 

Set   the option in the database so that the Navigator   form launches automatically when the database opens. Close the database   and reopen it to ensure that the Navigator form opens. Close the form.

 

You   will modify the record source of a report to display specific records. The   report will not rely on an underlying query to select records; the criteria are   handled by the SQL statement. You will add a command button to a form that   will open a form with associated records.
 

  Open the Drivers report in Design view. Modify the record source of the   report using a SQL statement to select all Drivers   records with a Class   of Adult. Print Preview the report (eight   records will display).

 

Modify   the SQL record source to display Junior   drivers. Print Preview the report (eight records will display). Save and   close the report.

 

You   will add a command button to a form that will open a form with associated   records.
 

  Open the Drivers form in Design view, click to add a command button at the intersection of the 6-inch mark on the   horizontal ruler and the 3-inch mark on the vertical ruler.

 

Set   the command button to open the Insurance form. Use the default picture as the   button. Set the name and the caption of the button to Open Insurance Form. Set the width of the button to 1.5″. Save the form. View the form in Form   view and click the command button.

 

You   will create a chart in a report that compares the number of licenses that   were issued by year. The chart will graphically depict the mix of drivers   according to the years of driving experience.
 

  Open the Auto Year report in   Design view. Click the Report Footer   section bar. Open the Property Sheet and set the height of the Report   Footer section to 3″. Close   the Property Sheet. Click in the blank   space below the Count function.

 

Insert   a pie chart by clicking at the 0.5″ mark on the vertical ruler and the   2.5″ mark on the horizontal ruler. In the Chart Settings pane, set the   Auto Year_Parameter query as the   data source. In the Axis (Category), select the AutoType check box, then in the parameter prompt, type 2012. Close the Chart Settings pane.

 

Click   in the Chart Title box in the   Property Sheet, and type Auto Type.   Close the Property sheet, then save and close the report. Reopen the report   and type 2010   at the prompts. Note that the data in the report and chart displays according   to the year input. Close the report.

 

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

Cybersecurity testing and validation scheme

 Assessment Description

Cybersecurity is a daily process. As an organization continues to evolve, making sure the security is continuously protected effectively against the latest threats is important. 

Create a matrix of requirements with pass/fail criteria based on the organizations framework controls. Make sure to include:

  1. Five technical controls specified within your guiding framework. If your guiding framework does not have technical controls enumerated, use NIST Special publication 800-53 and select technical controls appropriate for your organization.
  2. Using your design/architecture, create test cases for each of the five technical controls that are appropriate for your design.

APA style is not required, but solid academic writing is expected.

Refer to “CYB-690 Cybersecurity Test and Validation Scheme Scoring Guide,” prior to beginning the assignment to become familiar with the expectations for successful completion.

You are not required to submit this assignment to LopesWrite.

SQL Statements

In this assignment, you are to write Oracle SQL statements to:

  • Create a table.
  • Accept user input to populate the table.
  • Check if the data has been added to the table properly.

Use the following as references for your assignment.

  • Date, Time Exercise (with answers)
    Help with writing SQL commands to format date and time.
  • Text Processing Exercise (with answers)
    Help with formatting the output and allowing users to communicate with the database.
  • Sequence Exercise (with answers)
    Help with writing SQL statements to create sequence and alias.

 

This assignment consists of three parts:

  • Write Oracle SQL statements to create a table called Employee with the following attributes and associated data types.

Employee

EmployeeIDCHAR(9)LNameCHAR(15)FNameCHAR(15)PhoneNoCHAR(10)

  • Write Oracle SQL statements to insert new records to the Employee table. The program should do the following:

— Trident Bookstore —
Please enter the Employee ID: Jimmy2345
Please enter employee First Name: Jimmy
Please enter employee Last Name: William
Please enter the phone number of the employee: 714-456-3456
Note: Add at least 2 records of the data

  • Check whether data has been loaded to the table properly.

Oracle live SQL does not support some of the commands such as ACCEPT. It is helpful to learn these commands though.

Assignment Expectations

  • Copy the Oracle SQL commands to a Word document, and turn it in to the dropbox. Please note that there is no need to turn in the output of the commands, since you would most likely get a “Commands not supported” error message because of reserved words ACCEPT in your SQL.
  • Apply what you have learned in this module to accomplish all three parts of the assignment.

HW

 

Discuss how the theory (Orem’s theory of self care) might be used to support nursing practice (clinical, education, or administration). Include in the discussion the purpose of the practice application and how the concept of interest might be operationally defined in practice. Provide an example of how you might use the theoretical and operational definitions of your concept of interest in your future practice or research. Include a potential research or practice question based on the propositions of your theory.

STYLE & FORMAT:

The paper will be written using APA standards. The paper will include a title page (using specified format), 2-3 pages of text, and a reference list. It will be double-spaced, written in 12-point Times New Roman font, and have 1-inch margins. Professional and orderly presentation of ideas (precision, clarity, format, headings, grammar, spelling, & punctuation) with appropriate citation of sources in text and reference list is required. Up to 0.5 points will be deducted for each type of grammar, spelling, punctuation, or format error.

SUBMISSION INSTRUCTIONS:

Secondary sources such as, textbooks, literature reviews, systematic reviews, dissertations and concept analyses are NOT to be used. Only primary sources and empirical research articles are to be used for this assignment.

Blockchain

 Industry experts believe blockchain is a technology that has the potential to affect the business of most IT professionals in the next five years. Pick an industry you feel will be most affected by blockchain and how blockchain may be used in that industry. As an IT manager, how would you embrace blockchain? For instance, how would training occur for your team, what strategies might you use, what security methods may you recommend be used?

Your paper should meet the following requirements:

  • Be approximately four to six pages in length, not including the required cover page and reference page.
  • Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
  • Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The school Library is a great place to find resources.
  • Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.