Application of MFT Models Humanities Assignment Help

Key Assignment Final Draft

Part 1:

The Key Assignment for this course will involve creating polices for the various laws that are covered in the employee handbook. The purpose of the handbook is to equip managers with the information they need to lead their teams. For this assignment, you will create a paper of 1000-1500 words. You should also research and utilize 4 academic sources in your assignment.

Include the information below in your assignment. When discussing each act, provide an example of how it might be violated by an employer or employee and the approach that can be used (such as EEOC, diversity, grievances, counseling, documentation, or termination) to address the violation.

• A policy for the Americans with Disabilities Act (ADA)
• A policy for the Age Discrimination in Employment act (ADEA)
• A policy for dealing with different types of harassment.
• A policy for the Occupational Safety and Health Act (OSHA)
• A policy for the Family Medical Leave Act (FMLA)
• A policy for the Fair Labor Standards Act (FLSA)
• A policy for the Equal Pay Act (EPA)

Part 2:

Finalize your project by reviewing the feedback that you received from your instructor and your peers. Then, prepare a PowerPoint training presentation for employees to review the new policies (6-8 slides). At the end of the presentation, include 2 slides addressing:

• For the employee handbook, create a policy for employee use of technology because new sources of social media and more advanced electronic devices are regularly being introduced to the market. Address topics such as: refraining from workplace commentary on social media, maintaining a professional image, what can be shared and what not to share on social media, harassment, privacy, and IT security.

Please submit your assignment.

For the Book Exchange Project, analyze the cost vs benefits of:

• -desktop app vs web app
• -buy/configure/maintain on site webserver vs cloud-based host such as Amazon
• -Since this is a new system, there will be no “current level”
• -Define at least 5 potential performance factors
• -Then estimate 1 year, 2 year & 5 year estimates for those factors

For the Book Exchange Project, build a growth estimating spreadsheet

• -Since this is a new system, there will be no “current level”
• -Define at least 5 potential performance factors
• -Then estimate 1 year, 2 year & 5 year estimates for those factors

*Book Exchange Project is attached!*

YOUR TASK: Database administration is an important element of database planning. Security and performance issues need to be considered prior to the actual implementation of the database in the production environment. Write a Database Administration Plan document of 4–5 pages for the case study organization. Complete the following:

• Use data control language (DCL) to control access to the data by writing structured query language (SQL) statements to add a group of 5 users who have been granted permission to perform specific system privileges (CREATE object) and object privileges (INSERT, SELECT, UPDATE, and EXECUTE).
• Write the SQL-stored procedures that will support the efficient execution (using COMMIT and ROLLBACK) of 3 transactions (INSERT, UPDATE, and DELETE) in the database.
• Generate an execution plan for each query created in the Week 4 IP and provide a performance analysis of the results of each plan.
  • Provide a screenshot of the execution plan for each query.
  • In your analysis, discuss which queries you would change, including how and why you would change the queries.
• Create a backup plan under the full recovery model and provide a rationale for your model.
• Be sure to cite your sources in-text and in the References section by using APA style.
• Add the Week 5 IP to the database system plan and complete the plan (incorporating feedback as needed).
• Name the document as follows:
  • yourname_IT610_IP5.doc
• Submit the document for grading

PLEASE PLEASE PLEASE READ THE ATTACHED POWERPOINT. A lot of the concepts are overviewed on there. If you find any good online sources to help you with this, cite them in in-text format APA and put it on the last references page

THIS ASSIGNMENT IS AN ADD ON TO WHATS ALREADY BEEN DONE, SO PLEASE PLEASE PLEASE READ THE PAPER FIRST TO UNDERSTAND IT AND MAKE THE DATABASE PLAN AROUND THAT.

for better understanding, here’s an overview of what the paper currently has:

• System Requirements Specification (Week 1): Include a feasibility analysis that details what specific steps need to be performed at this phase of the project, clarifies the scope of the project, provides an estimate for cost and time to develop the database, and justifies the need for the proposed database.
• Conceptual Data Model (Week 2): Identify the entities and highest-level relationships using an embedded diagram. Describe the problem and data requirements in the narrative, as well as your rationale for the conceptual model. Justify your design by discussing how the design will solve the problem presented in the case scenario.
• Entity Relationship Diagram (Week 3): Create an entity relationship (ER) diagram that includes the primary keys for all entities, the relationships between different entities, the attributes (and data types) for each entity, and junction tables to support any many-to-many relationships. Be sure that the design meets a minimum of third normal form (3NF).
  • Describe the steps that you took to ensure that your design was normalized to the desired level and any exceptions you had to make to prevent anomalies and a loss in data integrity.
• SQL Statements (Week 4): Create the data definition language (DDL) and data manipulation language (DML) SQL statements that will be used to create the database schema. Be sure to include indexes, constraints, and relationships.
  • Include SQL statements that use data manipulation language (DML) to do the following:
    • INSERT 15 records into each table.
    • UPDATE 5 sets of records in each table using 1 specific criteria per update statement (e.g., EXACT MATCH, LIKE, BETWEEN, IN, or HAVING).
    • DELETE 2 records from 1 table based on specific criteria (e.g., EXACT MATCH or LIKE).
  • Create stored procedures to support the retrieval of the data from the database, using SELECT statements to accomplish the following:
    • Aggregate (group) functions (e.g., count, avg, min, max, and sum)
      • Write 4 queries using group functions.
    • Group By
      • Write 2 queries using the Group By, Having, and Order By syntax.
    • Simple queries.
      • Write 4 queries that manipulate data in 1 table.
    • Join queries
      • Write 4 queries that join 2 or more tables

      Feel free to ask me any questions and THANKS IN ADVANCE!! 😀

Assignment Due: September 19 at 9:30 AM. Complete the four homework questions after completing all Khan Academy modules up through and including Logic and If Statements. My suggestion is that you give yourself time to think and plan your approach before attempting to write any code. If you become stuck please take advantage of my office hours. Copy the code that you write to a Word document and attach it to this assignment. Also, save your project on Khan Academy with the title Homework 1 – Your Last Name (and of course, substitute your last name in for the italicized Your Last Name!) Please do assignment on khan academy and then submit it to me with the Word document of the code. Thanks.