Monthly Archives: June 2023

i want help in doing my assignment database modelling with in short  time   

 Do some research on Threat Response software. Find one particular software package to investigate.

• What does the software do?
• What are it’s major features?
• What kind of training is required?
• How much does the software cost?

Do not do the same software as everyone else.  200 – 300 Words

Project Deliverable 1: Project Plan Inception
Due Week 2 and worth 110 points
This assignment consists of two (2) sections: a project introduction and a project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.
You are a newly appointed Chief Information Officer (CIO) of a $25 million dollar data collection and analysis company that has been operating less than two (2) years. It is expected to grow by 60% over the next eighteen (18) months. Your company currently collects data using Web analytics and combines it with operational systems data. Web analytics is an increasingly important part of most business marketing plans. Your company is looking for ways to leverage the collected data but wants to ensure that the information technology infrastructure will support the expected growth that the company is anticipating. The Chief Executive Officer (CEO) has given you sixty (60) days to deliver a comprehensive information systems project plan to address the organizational growth that the company is experiencing. The company will be expanding from one (1) floor to three (3) floors within six (6) months. Since this is a relatively new company, there is currently limited technology infrastructure to support the business. All information technology (hardware and software) must be redesigned to meet organizational needs. The solution should be implemented in either a hosted solution, on-site solution, or a hybrid model. The CEO is expecting you to integrate different technologies from different partners and incorporate industry best practices and cost-effective solutions in connection with the development of technological systems. In addition, the CEO is extremely interested in cloud computing technologies and Software-as-a-Service (SaaS) but is leery of security issues that may be associated. However, he is sure that you will implement proper security protocols. The company currently consists of twenty (20) employees of which four (4), including yourself, are dedicated to the IT organization.
Section 1: Project Introduction
Write a four to six (4-6) page project introduction that documents the current state of the organization, expands upon the information given above, and includes the following:
Background information of the company.
Details regarding the type of business that the company is engaged in.
A description of current outsourcing and offshoring activities.
Identification of current skilled information systems personnel in position and responsibilities.
The specific types of data that the company collects.
A description of the information systems that the company currently has to support the business. The description at a minimum should include the following:
Operational Systems and Databases
Analytics and Interfaces
Infrastructure and Security
The use of at least two (2) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
Section 2: Project Plan
use Microsoft Project to:
Create a project plan (summary and detailed) using Microsoft Office Project. The project plan should:
Record all tasks, subtasks, resources, and time related to the project.
Outline the planning, analysis, design, and implementation phases.
Develop in accordance with the systems development life cycle (SDLC).
The specific course learning outcomes associated with this assignment are:
Describe the various functions and activities within the information systems area, including the role of IT management and the CIO, structuring of IS management within an organization, and managing IS professionals within the firm.
Use technology and information resources to research issues in information systems.
Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions

download the attachment and contact user

Part 1 – Microsoft Access

View Glossary

Use Access to create a database in which you can store and retrieve information about the Rio Salado Theme Park operating departments, their managers, and their employees.

1. Create a new blank database.
2. Save the database with the filename RSC_Theme_Park_Database_MEID.accdb. Replace “MEID” with your actual MEID.

Structure of the Database 

NOTE: Read the requirements for the database and be sure you understand how it should work before creating your design.

You will need to complete the following:

• Create two tables.
• Establish table relationships.
• Create one form.
• Create two queries.
• Create one report.

As you work on the project, remember to follow best practices for creating databases as described in your TestOut materials and the online lesson content.

Create the Tables

Tables and their relationships form the backbone of a relational database. In this database, you will create a table for the Rio Salado Theme Park operating departments and their managers, and a table for employees in each department. When creating fields for your tables, it is important to break down your data into the smallest chunks you can (fine granularity) to make it easier to extract data from the database later. Remember to assign the most appropriate data type to each of the fields and that one of the fields in each of your tables must be set as the Primary Key using the AutoNumber data type. You do not need to enter data records into your tables at this time; you will create a form later in this project for data entry.

Department Table

Create a table named Department Table. At a minimum, your table should include the following fields:

• Department ID
• Department Name
• Manager First Name
• Manager Last Name
• Manager Email Address
• Manager Phone Number

Employee Table

Create a table named Employee Table. At a minimum, your table should include the following fields:

• Employee ID
• Department ID
• Employee First Name
• Employee Last Name
• Employee Date of Hire
• Employee Rate of Pay

Establish Table Relationships

Once the design of the tables has been completed, the next step is to establish relationships between the tables. You will join the Department Table with the Employee Table on common fields through the following tasks:

1. Join the primary key of the Department Table with the foreign key of the Employee Table in a One-To-Many relationship.
2. Enforce referential integrity.
3. Cascade update related fields.
4. Cascade delete related records.

Create a Form

Once the tables have been designed and the relationships have been established, it is time to enter data. You will use one form to enter and edit data in the two tables:

1. Create one form named Department Form that can be used to enter data into both tables.
2. Insert a row below the Employee Table subform. Add a button in the new row to perform the Add New Record action with the text: Add Record.
3. Use the form to enter a minimum of four departments (e.g., Concessions, Rides, Business Office, Guest Services) and a minimum of four employees for each department. Include your name as one of the employees in the Business Office department.
4. Apply the Retrospect theme to the form.

Create a Query

The ability to extract data from one or more tables is one of the most important functions provided by a database. You will now design, save, and run a query to show only the employees in the rides department by following these tasks:

1. Create a query named Ride Employees Query based upon the Employee Table.
2. Include the Employee First Name, Employee Last Name, and Department ID fields.
3. Use a Number Criteria for the Department ID field to select only the employees in the Rides Department.
4. Hide the Department ID field.
5. Save and run the query.

Create a Query

Next, you will design, save, and run a query to show the number of employees per department:

1. Create a query named Number of Employees Query based upon the Department and Employee Tables.
2. Include the Department Name and the Employee ID fields.
3. Use the Total Row to Count the number of employees per department.
4. Save and run the query.

Create a Report

Reports are used to generate printouts from the tables in a database. The Report Wizard can be used to access multiple tables, select fields, and group data in a report:

1. Use the Report Wizard to create a report named Department Report.
2. From the Department Table, include the Department Name and Managers’ First and Last Names.
3. From the Employee Table, include the Employees’ First and Last Names.
4. Group by Department Name.
5. Sort Ascending by Employee Last Name.
6. Use a Stepped Layout in Landscape Orientation and be sure the report fits on one page.

Save and close your RSC_Theme_Park_Database_MEID.accdb database.

———————————————————————————————————————————————-

Part 2 – Microsoft Excel

View Glossary

Use Excel to create a workbook containing three worksheets. The Excel workbook will include employee home contact information and a bank account ledger for the Rio Salado Theme Park.

1. Create a new blank workbook.
2. Save the workbook with the filename RSC_Theme_Park_Workbook_MEID.xlsx. Replace “MEID” with your actual MEID.

Structure of the Workbook 

Your workbook must contain three worksheets:

• Employee Data – This worksheet will contain employee home contact information.
• Bank Account Ledger – This worksheet will show the debits and credits for the Rio Salado Theme Park bank account.
• Line Chart – This worksheet will contain a line chart depicting the daily balance for the Rio Salado Amusement Park bank account.

Employee Data Worksheet

One of the best features of Excel is how easily it can work with data from other programs. Because you already created employee data in Access, you can import that data into Excel to reduce time and effort in creating this worksheet.

1. Import the Employee Table from your RSC_Theme_Park_Database_MEID.accdb database into a new worksheet.
2. Rename the worksheet as Employee Data.
3. Assign the worksheet tab a color of your choice other than the Office default.
4. Resize the table to add the following columns to the right of the Employee Rate of Pay column:
   1. Home Address
   2. City
   3. State
   4. Zip Code
   5. Email Address
   6. Phone Number
5. Enter data into the newly added columns for each employee.
6. Increase the column widths to ensure that you can view the longest data entry in each cell of the worksheet.
7. Hide the following columns:
   1. Department ID
   2. Employee Date of Hire
   3. Employee Rate of Pay
8. Align Left the values in the Employee ID and Zip Code columns.
9. Remove Hyperlinks, if any, from the email addresses.
10. Sort the table by Employee Last Name.
11. Apply Outside Borders to the entire table.
12. Apply an appropriate Table Style of your choice other than the Office default.
13. Freeze the column header row of the table.
14. Use the Page Setup Dialog Box to perform the following tasks:
    1. Set the Page Orientation to Landscape.
    2. Scale to Fit to one page wide by one page tall.
    3. Add a Footer to the worksheet:
       1. Enter your Name in the left section.
       2. Enter your MEID in the center section.
       3. Enter the Course Number and your Section Number in the right section.

Bank Account Ledger Worksheet

The Rio Salado Theme Park wants you to create a new worksheet to keep track of their bank account transactions using the following specifications:

1. Add a new blank worksheet to the workbook.
2. Rename the worksheet as Bank Account Ledger.
3. Assign the worksheet tab a color of your choice other than the Office default.
4. In the first row, insert the title RSC Bank Account Ledger.
5. In the second row, create a new table with the following column headers:
   1. Entry Number
   2. Date
   3. Transaction Description
   4. Debits
   5. Credits
   6. Balance
6. Merge and center the title in the first row over the table columns in the second row.
7. Change the Font Size of the title to 18 pt.
8. Apply a Fill Color of your choice, other than the Office default, to the title cell.
9. Make one entry in the table for each of ten consecutive dates. Be sure to include the Entry Number, Date, Transaction Description, and either a Debit or Credit for each entry. Your first entry should be a deposit (make additional deposits as necessary) so that you do not ever have a negative balance.
10. Use a formula (not a function) with cell references based on the Debits and Credits to calculate the first Balance.
11. Use a formula with cell references based on the Debits and Credits and the previous Balance to calculate the remaining balances.
12. Increase the column widths to ensure that you can view the longest data entry in each cell of the worksheet.
13. Using the Table Tools, add a Total Row to your table and use functions to calculate the Total Debitsand Total Credits.
14. Apply the appropriate Number Formatting to all cells in your table.
15. Align Center the Entry Numbers.
16. Use Conditional Formatting to identify the Top 2 Debits in your table.
17. Apply an appropriate Table Style of your choice other than the Office default.
18. Resolve any Error Messages you might receive in any cells.
19. Freeze the first two rows of the worksheet.
20. Use the Page Setup Dialog Box to perform the following tasks:
    1. Scale to Fit to one page wide .
    2. Add a Footer to the worksheet:
       1. Enter your Name in the left section.
       2. Enter your MEID in the center section.
       3. Enter the Course Number and your Section Number in the right section.

Line Chart Worksheet

The Rio Salado Amusement Park wants a visual depiction of the daily balances from the bank account ledger:

1. Select the Bank Account Ledger worksheet.
2. Insert a Line Chart using the data from the Date and Balance fields.
3. Using the Chart Tools, move the chart to a new sheet named Line Chart.
4. Assign the worksheet tab a color of your choice other than the Office default.
5. Select a Chart Style of your choice other than the Office default.
6. Change the Chart Title to Bank Account Balances.
7. Add horizontal and vertical Axis Titles and add meaningful titles.
8. Add Data Labels.
9. Use the Page Setup Dialog Box to perform the following tasks:
   1. Set the Page Orientation to Landscape
   2. Add a Footer to the worksheet:
      1. Use the Insert File Name button in the center section.

Required Worksheets

Arrange the worksheets in the following order:

1. Employee Data
2. Bank Account Ledger
3. Line Chart

Save and Close your RSC_Theme_Park_Workbook_MEID.xlsx workbook.

Submit Your Assignment

After completing both sections of the project, submit your Access and Excel files following the instructions in the lesson.

Review Section 1.3 on effective versus ineffective security governance in Westby, J. R., and Allen, J. H. (2007), Governing for Enterprise Security (GES) Implementation Guide, which is located in your Module 3 readings (and available online from http://www.sei.cmu.edu/reports/07tn020.pdf (Links to an external site.)).   Compare and contrast the effectiveness criteria in Table 1 on pp. 8-9 of Westby and Allen (2007) with Table 25.3 on pp. 287-288 of Hopkin (2014).  Be sure to identify any effectiveness criteria from Westby and Allen (2007) that you believe should be added to the criteria outlined in Hopkin (2014). 

Discussion 6.1

Read the following scenario and provide provide a viable resolution  based on FMLA.

One of your nurses, Betty, displayed signs of depression, such as crying openly at work in front of staff and residents. One of her co-workers even reported to the nursing home’s administrator that Betty was becoming increasingly depressed and being overworked to the point of exhaustion. Betty became ill with diarrhea after her three consecutive shift days and called in sick for two days. On the second day, Betty informed her boss that she was also experiencing vomiting and chest pains, and was going to see her physician. The physician diagnosed Betty with clinical depression, prescribed Prozac, and advised her to take a medical leave of absence from work for two months.

Betty advised her boss that her doctor told her to stay home for two months. Betty did not disclose her clinical diagnosis, did not ask for Family and Medical Leave Act (FMLA) leave, and did not ask for leave as a reasonable accommodation under the Americans with Disabilities Act (ADA). Betty’s boss required her to produce a medical certification from her physician regarding her condition. Betty indicated that her physician was away for the holidays and would not be back for three weeks.

Two weeks later, Betty received a termination letter stating that she was being fired for failing to submit a medical certificate within 15 days of requesting leave. As a result, her leave request was being denied and her failure to come to work was being deemed a voluntary resignation.

This story was brought to your attention as the HR professional after Betty’s termination letter was sent. Now what? Remember that your resolution must be based on FMLA guidelines.

************************

In order to get a full grade, 

1) please make sure that your initial post is at least 150 – 200 words in length

Discussion 6.2

An unhealthy work environment can lower productivity, contribute to low morale, and increase medical and workers’ compensation costs. Consider ways to improve the work environment.

Case Study 6.1 4 Pages

There are two (2) case studies per chapter. You are to respond to one (1) case from Chapter 11 and one (1) case study from Chapter 12.

Chapter 11 – Employee Benefit (Choose one case study)

Case Study 1 – Adobe’s Family-Friendly Benefits: An Unexpected Backlash, pg. 450 and answer the questions

Case Study 2 – Evaluate the Work-Life Climate in Your Company. pg. 451 and answer the questions

Chapter 12 – Promoting Safety and Health (Choose one case study)

Case Study 1 – Rambo Goes Violent, pg. 490 and answer the questions

Case Study 2 – Too Much Fatigue and Stress? You Decide, pg. 491 and answer the questions

Weekly Summary 6.1

Write 2 pages of weekly summary based on the chapter 11 and 12 PPT attached.

1. Discuss what ethical leadership is and how it impacts the organizational culture.
2. What are the various dimensions of ethical leadership?
3. Note some failures in ethical leadership, please find an example, explain the failure and note possible solutions to fix the issue with leadership.
4. How do trustworthy and ethical leaders enhance knowledge sharing in organizations?  How does this impact the rate of information technology implementations?  How does this impact data management within organizations? 
5. How does servant leadership assist with transferring knowledge in an organization?
6. When thinking about data analytics, how does transformational leadership assist with building good data structures?

Please be sure to answer all the questions above in the initial post

At least one scholarly (peer-reviewed) resource should be used in the initial discussion thread.   Use APA references and in-text citations.

If you were part of a government entity, what would you say about the potential benefits and drawbacks of encryption? What is the difference between symmetric and asymmetric encryption? 

This is a Database Programming course. This course covers advanced topics in databases. It starts by reviewing basic knowledge on databases and ends with advanced database concepts like security.

In this project, you will use the knowledge you acquired throughout the course to build a simple database and query it to extract information from it. You will create tables and relationships among them, in addition to the necessary keys and indexes. The next step will be to populate the database with suitable data. Populating the tables with sufficient and appropriate example data is an important step in testing and validating your design. When your database is ready, you will write SQL queries to retrieve information.

Note: This assignment was created with MySQL in mind. Therefore, dates, numbers, etc. have been set up with that tool in mind.

Upon completion of this project, you will be able to:

• Write SQL queries to create tables
• Write SQL queries to create relationships among tables
• Identify indexes and create them in a database
• Write queries to extract important information from a database

Prompt

In this project you will build a database for a public library. This database is aimed to collect and analyze information about the clients’ reading interests. The project concentrates only on books and the clients’ interests in books. The analyses that will result from this project will be used by the library’s management to decide on the future purchasing policy.

A. Write the SQL statements in order to create the tables for the database. Use the Entity Relationship Diagram (ERD) of the database shown in Figure 1. For simplicity, we are assuming in this project that a book cannot be written by more than one author. You need to create the tables as well as the required constraints, including the keys (primary and foreign), and the relationships between table.

Use the attach document to complete this assignment.