Structured Query Language for Data Management

/in /by

 Task Name:Phase 5 Individual ProjectDeliverable Length:2–4 pagesDetails:Weekly tasks or assignments (Individual or Group Projects) will be due by Monday and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.

This assignment requires you to take your extended design from Week 4 IP and add proper indexes, a function, and a stored procedure. Your changes will provide functionality used by the teachers for screens such as a grade book. Be sure any code is properly formatted and has appropriate comments.

Part 1: Function

Write a user-defined function (UDF) that calculates a student’s GPA for a given time frame. Inputs are StudentId int, ClassStartDateStart datetime, and ClassStartDateEnd datetime. The output should be the student’s GPA for all classes that were taken between ClassStartDateStart and ClassStartDateEnd. Also, supply the script to call this new function, passing it parameter values of your choice.

Part 2: Stored Procedure

Write the DDL script to make a stored procedure that returns data needed to display a grade book screen for a professor. The only input for the stored procedure is a ClassId. Outputs need to include student names and grades for all assignments as well as a calculated overall grade for the class for each student. Provide an example calling this new stored procedure, passing it parameter values of your choice. Include a screenshot of the output.

Part 3: Indexes

Provide a list of suggested indexes and the DDL script to create them. Include an explanation of the purpose of indexes and how you made your decision for the fields to include in your list of suggested indexes.Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Upload your document to the Submitted Tasks.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Annotated Bibliography

/in /by

  

This assignment will be one of several throughout your PhD program that we use to help you prepare for the dissertation process. One of the core competencies necessary to succeed in a doctoral program is the ability to identify other research that pertains to your own. This means you’ll have to identify similar research, read the papers, and assimilate prior work into your own research. An annotated bibliography helps you develop and hone these research skills.

This is worth 10% of your grade. Your paper will be an annotated bibliography, specifically focusing on the ” 

You paper must be in correct APA format, use correct grammar, and will need to include at least seven (7) resources, ALL of which must:

1) Be current. Published within the last few years.

2) Be peer-reviewed.

3) Relate directly to Defense in depth in the context of protecting National Infrastructure.

Remember that an annotation is not the same as an abstract. Abstracts are descriptive. Your annotations are to be evaluative and critical. Give me enough information for me to decide if I’m interested enough to read the paper, and also how you perceive the paper. Don’t go skimpy on these annotations, but DO NOT write too much here. Quality is far more important that quantity. This exercise is for each of you to demonstrate that you can identify, categorize, and digest multiple research papers. 

Every resource you choose must be peer reviewed. That means the paper must have undergone a formal peer review before being published in a journal or presented at a conference. You must ensure that your resources have undergone rigorous reviews. In most cases, you can find out the review process for a conference or journal by visiting the appropriate web site. Do not simply assume that a resource is peer reviewed – check it out. 

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Chapter 8 summary essay

/in /by

 Assignment Instructions:

· no less than 1000 words and make use of at least three references other than your text

· Do NOT resort to polemics or personal attacks and avoid the rote repetition of platitudes or dogma

· State your hypothesis and then attempt to prove it with facts not wants or feelings.

Questions

1. Discuss the difference in the speeds of Green IT transformation of a business unit versus the society.

2.Describe how the practice of videoconferencing, telecommuting, and mobile commuting assist in carbon reduction. What challenges are faced by organizations implementing these practices?

Reference:

(This is Text Book).

Unhelkar, B. (2016). Green IT strategies and applications: using environmental intelligence. CRC Press.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Physical secuirty

/in /by

Fennelly (2017) stated that the key to risk management is to knowingly determine an acceptable level, rather than unwittingly accepting it. In relation to security risk management, these decisions are based on the consequence of loss of the asset, the defined threat, and the risk tolerance of the enterprise. 

For this assignment, you will research and expound on the following questions as they relate to physical security? What is risk management? What is Vulnerability assessment? What is the difference between security and safety? What is the relationship between risk management and vulnerability assessment?

Assignment Requirements You must write a minimum of three paragraphs, with two different in-text citations for each question. Every paragraph should have at least four complete sentences. Every question should have a subtitle (Bold and Centered) Every paragraph must be indented Do not continuously cite at the end of each paragraph.
You are required to write and cite according to APA 6th Edition format.
Your SafeAssign Score needs to be no more than 30%.
Please ensure that you use the Individual Project Header for this and every IP assignment.  Please proofread your work and correct all grammatical, punctuation, and spelling errors before posting your assignment.  Failure to comply with these requirements will result in a low or zero grade.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

IT Security Policy Framework

/in /by

1. What are some of the best practices for IT Security policy framework creation?

2. Which information systems security factors should you consider when creating your IT security policy framework?

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

CIS 500 UCERTIFY Quiz: 7. Service Design Roles WEEK 5

/in /by

Quiz: 7. Service Design Roles, 1 of 19
Q: How frequently should CAB meetings be held?

Monthly

Yearly

Weekly

As required
Quiz: 7. Service Design Roles, 2 of 19
Q: Which of the following activities should a service owner undertake?

1. Representing a specific service across the organization
2. Updating the known error database with details of errors that have been identified for the service
3. Attending the CAB meeting to discuss changes to the service
4. Attending service reviews with the business

1, 2, and 3 only

1, 3, and 4 only

1 and 2 only

All the answers are correct
Quiz: 7. Service Design Roles, 3 of 19
Q: Which of the following roles is responsible for a particular service within an organization?

The Service Continuity Manager

The Service Level Manager

The Business Relationship Manager

The Service Owner
Quiz: 7. Service Design Roles, 4 of 19
Q: Which of the following statements about the RACI model is true?

It records Configuration Items (CI).

It defines roles and responsibilities.

It performs performance analysis.

It monitors services.
Quiz: 7. Service Design Roles, 5 of 19
Q: What does RACI stand for?

Review, Authorize, Consult, Inform

Recorded, Assessed, Consulted, Informed

Responsible, Accountable, Consulted, Involved

Responsible, Accountable, Consulted, Informed
Quiz: 7. Service Design Roles, 6 of 19
Q: Which role should update process documentation following a change?

The change manager

The process manager

The knowledge manager

The process owner
Quiz: 7. Service Design Roles, 7 of 19
Q: Which of the following is not one of the responsibilities of a service owner?

Designing the metrics for the process and ensuring that these provide the necessary information to judge the effectiveness and efficiency of the process

Communicating with the customer as required on all issues regarding the delivery of the service

Being the escalation (notification) point for major incidents affecting the service

Representing the service across the organization and attending service review meetings with the business.
Quiz: 7. Service Design Roles, 8 of 19
Q: Who is responsible for ensuring the right numbers of staff are assigned to the various roles within the process and that they understand what is required of them?

Process owner

Process manager

Process practitioner

Service owner
Quiz: 7. Service Design Roles, 9 of 19
Q: The RACI model is used to __________.

Define roles and responsibilities

Manage Configuration Items (CI)

Monitor services

Performance analysis
Quiz: 7. Service Design Roles, 10 of 19
Q: What is the RACI model used for?

Defining the roles and responsibilities for a process

Defining the different responsibilities of the service owner and the process owner, manager, and practitioner

Defining the process requirements for a new service

Risk assessment for each configuration item
Quiz: 7. Service Design Roles, 11 of 19
Q: Which of these statements is not true?

There may be several process managers for each process.

There may be several process owners for each process.

Every process must have a process manager.

There may be several process practitioners for each process.
Quiz: 7. Service Design Roles, 12 of 19
Q: What does RACI stand for?

Linear Responsibility Chart

Responsible Accountable Consulted Informed

RACI matrix

Responsibility Assignment Matrix
Quiz: 7. Service Design Roles, 13 of 19
Q: Which of the following is true?

Accountability can be shared.

There may be more than one person responsible.

Someone must always be consulted for each process step.

The process owner is the person informed for every process step.
Quiz: 7. Service Design Roles, 14 of 19
Q: Which of the following is a valid role in the RACI matrix?

Configuration

Consulted

Complex

Controlled
Quiz: 7. Service Design Roles, 15 of 19
Q: Who is responsible for producing evidence that the process activities have been carried out correctly, in the form of records?

Process manager

Process practitioner

Process owner

Service owner
Quiz: 7. Service Design Roles, 16 of 19
Q: Which of the following versions of the RACI is used by Project Management Institute (PMI)?

RACIO

DACI

RSI

RASCI
Quiz: 7. Service Design Roles, 17 of 19
Q: Who does ITIL say is responsible for identifying improvements to a process?

1. The service owner
2. The process improvement manager
3. The process manager
4. The process owner

1 and 2 only

3 and 4 only

All the answers are correct.

4 only
Quiz: 7. Service Design Roles, 18 of 19
Q: Which of the following is the responsibility of a Process Owner?

Monitoring and improving the process

Use tools to support the process

Ensuring that targets specified in a SLA are met

Carrying out activities defined in the process
Quiz: 7. Service Design Roles, 19 of 19
Q: Which of the following versions of RACI centralizes decision making and clarifies who can re-open discussions?

DACI

CAIRO

RACIO

VARISC

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Error Handling in an Activity Diagram

/in /by

Assignment 1: Error Handling in an Activity Diagram

 

Refer to the activity diagram Figure 2-15 on page 59 of the textbook. The diagram omits several error-handling pathways.

 

Write a two to three (2-3) page paper in which you:

1.           Using Microsoft Visio or an open source alternative such as Dia, update the diagram to include two (2) error-handling pathways. Note: The graphically depicted solution is not included within the required page length. Produce a narrative which describes the added error-handling pathways that includes: an overview of the errors being checked an explanation of the main reasons why checking for such errors is important an overview of other possible errors Use at least three (3) quality resources outside of the suggested 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, your 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.

·              Include charts or diagrams created in Visio or an open source alternative such as Dia. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

 

The specific course learning outcomes associated with this assignment are:

·              Analyze techniques for requirements determination, collection, and organization.

·              Use technology and information resources to research issues in systems analysis and design.

·              Write clearly and concisely about advanced systems analysis and design topics using proper writing mechanics and technical style conventions .

 

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 150

Assignment 1: Error Handling in an Activity Diagram

Criteria Unacceptable

Below 70% F Fair

70-79% C Proficient

80-89% B Exemplary

90-100% A 1. Using Microsoft Visio or an open source alternative such as Dia, update the diagram to include two (2) error-handling pathways.

Weight: 25%

Did not submit or incompletely updated the diagram to include two (2) error-handling pathways, using Microsoft Visio or an open source alternative such as Dia.

Partially updated the diagram to include two (2) error-handling pathways, using Microsoft Visio or an open source alternative such as Dia.

Satisfactorily updated the diagram to include two (2) error-handling pathways, using Microsoft Visio or an open source alternative such as Dia.

Thoroughly updated the diagram to include two (2) error-handling pathways, using Microsoft Visio or an open source alternative such as Dia. 2a. Produce a narrative which describes the added error-handling pathways that includes an overview of the errors being checked.

Weight: 20%

Did not submit or incompletely produced a narrative which describes the added error-handling pathways that includes an overview of the errors being checked.

Partially produced a narrative which describes the added error-handling pathways that includes an overview of the errors being checked.

Satisfactorily produced a narrative which describes the added error-handling pathways that includes an overview of the errors being checked.

Thoroughly produced a narrative which describes the added error-handling pathways that includes an overview of the errors being checked. 2b. Produce a narrative which describes the added error-handling pathways that includes an explanation of the main reasons why checking for such errors is important.

Weight: 20%

Did not submit or incompletely produced a narrative which describes the added error-handling pathways that includes an explanation of the main reasons why checking for such errors is important.

Partially produced a narrative which describes the added error-handling pathways that includes an explanation of the main reasons why checking for such errors is important.

Satisfactorily produced a narrative which describes the added error-handling pathways that includes an explanation of the main reasons why checking for such errors is important.

Thoroughly produced a narrative which describes the added error-handling pathways that includes an explanation of the main reasons why checking for such errors is important. 2c. Produce a narrative which describes the added error-handling pathways that includes an overview of other possible errors.

Weight: 20%

Did not submit or incompletely produced a narrative which describes the added error-handling pathways that includes an overview of other possible errors.

Partially produced a narrative which describes the added error-handling pathways that includes an overview of other possible errors.

Satisfactorily produced a narrative which describes the added error-handling pathways that includes an overview of other possible errors.

Thoroughly produced a narrative which describes the added error-handling pathways that includes an overview of other possible errors. 3. 3 references

Weight: 5%

No references provided.

Does not meet the required number of references; some or all references poor quality choices.

Meets number of required references; all references high quality choices.

Exceeds number of required references; all references high quality choices. 4. Clarity, writing mechanics, and formatting requirements

Weight: 10%

More than 6 errors present

5-6 errors present

3-4 errors present

0-2 errors present

 

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

4

/in /by

4.1. Using a Web browser, identify at least five sources you would want to use when training a CSIRT.

4.2. Using a Web browser, visit www.mitre.org. What information is provided there, and how would it be useful?

4.3. Using a Web browser, visit www.securityfocus.com. What is Bugtraq, and how would it be useful? What additional information is provided under the Vulnerabilities tab?

4.4. Using a Web browser, visit www.cert.org. What information is provided there, and how would it be useful? What additional information is provided at www.cert.org/csirts/?

Discussion

 Search “scholar.google.com” or your textbook. Discuss the technical skills required to have a CSIRT response team consisting of employees with other job duties (i.e., not a full-time CSIRT job category)? Why or why not? What factors will influence their decision?  

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Social Networking

/in /by

List three positive and three negative impacts of social networking. In your opinion, determine whether the positive impacts outweigh the negative impacts for a company determined to increase company awareness. Describe the role of the CIO in relationship to social networking and the organization. Describe the key activities that the CIO should be engaged in. Discuss ways that the IT organization can counter the negative impacts of social networking. Explain how the IT organization can maintain an ethical posture while managing organizational behavior related to social networking.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

App(7)

/in /by

  Assignment Instructions

Turn-Ins:  “Birthday Widget” :

(A)    Create your program/project “Birthday Widget”  in Android Studio. (hint: MacLean Book Chapter 21 Figure 21-4)  “Birthday Widget” project should show a name, the date of the next birthday, and how many days from today until the birthday. It will also create an onClick area where you can click to buy gifts. This click will open a browser and take you to www.google.com.. Your project should produce similar screen as Figure 21-4.

(B)    Run on the Emulator
(C)    Run on a real phone (optional)
(D)    Take screenshot(s) of either (B) or (C)
(E)    Put the screenshots in a Word document. Please have a cover sheet with your name and the name of the assignment. Name the file following naming convention “ENTD322Week6Assignment_First_Last.doc”
(F)    Zip your complete project
(G)   Submit the word document (E) and the zip file  (F) as an attachment.
Note: for turn-ins, your project should be done using Android Studio, not Eclipse.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.