Let’s assume that you are going to design a database for someone you know – a friend or a family member. Gather some information about the type of database the person interviewed is interested. Based on what you find out, answer the followings: (250-850 words)
Part A: Profile an Old Testament Leader
Part B: Profile a leader in current events, evaluating the leader via at least one leadership theory.
When looking at the threat landscape, there are different types adversaries and they pose different types of threats depending on their capabilities, intentions, and the assets they are targeting. For example, nation states might target research companies or military websites trying to steal confidential and proprietary data. In addition, companies react to the loss of assets differently. The level and types of mitigation strategies will vary among organizations depending on whether there is a loss of one asset or of an entire category of assets.
For your initial post, identify a recent cybersecurity incident (within the last two years). Briefly summarize the incident, and post a link to an article on the incident if possible. Try to identify the threat actor(s) and the goal or intent of the attack. If there is no “why” put on your adversarial thinking cap and hypothesize what you think is the “why”.
A 3 page paper using 4-8 sources, with title page and reference page. The focus of the paper should be on the crime, policy, and cybersecurity aspects and concepts.
The question is attached in the dataandtaskabstration word file. the resouces are attached too.
Project Description:
Quill Financial Services has recently started working with student loans. You will build the company’s database. The initial set of financed student loans are stored in an Excel spreadsheet. You have already compiled the list of colleges and universities into an Access table. You will use your expertise to import the information from Excel, modify the table, create relationships, create queries, create forms, and create reports.
1
To start, you have been provided with a database the Information Technology department created. The database has one table. You will be importing an Excel spreadsheet into a table and creating a primary key.
Start Access. Open the downloaded Access file named Exp19_Access_Ch03_CapAssessment_Student_Loans.accdb.
2
Import the exploring_acap_grader_a1_Clients.xlsx Excel workbook into a table named Clients. While importing the data, make sure to select the option First Row Contains Column Headings, and select ClientID as the primary key field.
3
Now that you have imported the data from the spreadsheet, you will modify the field properties in the Clients table and demonstrate sorting.
Open the Clients table in Design view. Change the ClientID field size to 6 and remove the @ symbol from the ClientID format property. Change the ZIP field size to 5. Change the ExpectedGraduation field to have 0 Decimal Places. Delete the Comments field. Add a new field named LastContact as the last field in the table. Change the data type to Date/Time, and change the format to Short Date. Switch to Datasheet View, and apply Best Fit to all columns. Sort the table on the LoanAmount field in descending order, then save and close the table.
4
Now that the table is imported and modified, you will create a relationship between the Colleges and Clients tables.
Open the Relationships window. Add the Clients and Colleges tables to the window, and create a one-to-many relationship between the CollegeID fields in the Clients and Colleges tables. Enforce referential integrity between the two tables and select the cascade updates and cascade delete options. Save the changes, and close the Relationships window.
5
Polly Esther, a financial adviser, would like your assistance in helping her find certain information. You will create a query for her and demonstrate how she can change information.
Create a new query using Design view. From the Clients table, add the LastName, FirstName, Email, Phone, and ExpectedGraduation fields, in that order. From the Colleges table, add the CollegeName field. Sort the query by LastName and then FirstName, both in ascending order. Set the criteria in the ExpectedGraduation field to 2019. Run the query. Save the query as 2019 Graduates and close the query.
6
Now that you have created the query, you will create a second query for Polly that will calculate the loan payments for which each student will be responsible (assuming monthly payments).
Create a copy of the 2019 Graduates query. Name the copy Loan Payments and open the query in Design view. Remove the criteria from the ExpectedGraduation field. Create calculated field named MonthlyPayment that determines the estimated monthly student loan payment. The loan will have a fixed rate of 5% interest, paid monthly, for 10 years. Using the Pmt function, replace the rate argument with 0.05/12, the num_periods argument with 10*12, and the present_value argument with the LoanAmount field. Use 0 for the future_value and type arguments. Format the field as Currency.
Run the query. Ensure the payment displays as a positive number. Add a total row to Datasheet view. Average the MonthlyPayment field and count the values in the LastName column. Save and close the query.
7
Stann Dupp, the director of finance, needs to summarize information about all of the student loans Quill Financial Services offers based on each college. You will create a totals query for him to summarize the number of loans, average loan amount by college.
Create a new query using Design View. From the Colleges table, add the CollegeName field. From the Clients table, add the ClientID and LoanAmount fields. Display the Total row, and group by CollegeName. Show the count of ClientID and the average LoanAmount.
Change the caption for the ClientID field to Num Loans, and the caption for LoanAmount to Avg Loan. Format the LoanAmount field as Standard. Run the query. Save the query as Loan Summary by College and close it.
8
Jay Walker, one of the company’s administrative assistants, will handle data entry. He has asked you to simplify the way he inputs information into the Clients table. You will create a form based on the Clients table.
Create a Split Form using the Clients table as the source. Change the height of all of the fields and labels to .25 collectively. Reorder the fields in the bottom half of the split form so the FirstName displays before the LastName field. Switch to Form view and click the row for Riya Gonzalez. Change her expected graduation date to 2022. Save the form as Client Information and close it.
9
Stann is hoping you can create a more print-friendly version of the query you created earlier for him to distribute to the executives. You will create a report based on the Loan Payments query.
Create a report using the Report Wizard. From the Loan Payments query, add the LastName, FirstName, Email, ExpectedGraduation, CollegeName, and MonthlyPayment fields. Do not add any grouping or sorting. Ensure the report is in Landscape orientation. Save the report as Loans by Client and view the report in Layout view. Adjust the width and position of the fields and labels so that all of the values are visible. Save the report.
10
Now that you have included the fields Stann has asked for, you will work to format the report to make the information more obvious.
Apply the Integral theme. Group the report by the ExpectedGraduation field. Sort the records within each group by LastName then by FirstName, both in ascending order. Switch to Print Preview mode and verify that the report is only one page wide (Note: it may be a number of pages long).
11
Save the database. Close the database, and then exit Access. Submit the database as directed.
Pls see attached
Please review the below post and provide a response of 300 words.
Protection of Patient Data:
Healthcare data securities are much important component of laws with accountability and also portable with insurances. The organizations of healthcare can digitalize the exchange of data and also services will be provided through enhancements, the data mostly remains threatened by such speed or efficiency. Security breaches might harm the individuals in millions (DeLaHaye, 2015).
As per cyber attack frequencies, it’s grown at earlier times, the needs of secured sensitivity data healthcare from attacks of cyber. The policies have communicated through healthcare through others can be neither used nor safe. Members of the organizations in HIPAA can be data liable to patients. They guarantee the information with patients can use to such reasons that followed individuals in order to authorize the patient’s information. The health of patients will be abused damaging the company connections and efficiency in between patients as well as others. This will lead to many instances and effects emotionally the people to depend on situations of their health. So, decreasing the patient data by management institute other records in both clinical or non-clinical records (DeLaHaye, 2015).
Many of us are aware of the act that is famous in the year 1996 of healthcare industries which is portable one called as an act of HIPAA. The data of health is much accountable and also can transfer the data classified which handles the manner in a secured way that avoids such data to misuse. With a surge over healthcare using concerns in past a year back a hit by the pandemic, the hospitals availability, as well as treatment, is been focused on regulations of HIPAA and bit rules have overlooked the security especially sockets/transport layers which is been outdated (Totic, 2019).
The effective way to protect the patients is from hacking which implements the secured concept for accessing patients’ data health. The access that restricted the persons not authorized cannot guarantee the compliance of HIPAA and also likelihood reduces the proceedings over the patient data breaches. Implementing the responses over crisis can measure by organizations will help the information that theft. Maintaining the breaches to prepare over the planned responses and instructs regularly staff by procedure and their strategies. Making the information to store in policies over data protection and cannot contain personal or technical data (Totic, 2019).
Technologies can rapidly advance the strengthen healthcare and confuse often. With technologies of the advent of healthcare, each individual can computerize. Cyber attackers will be completed as per data manipulation contains in their databases. For example, in comprehensive services medical there are many medical centers from various regions. In order to prevent such attacks, educating about the importance of healthcare professionals can be used appropriately in procedures and practices over cyber security needs the part of HIPAA regulations (Totic, 2019).
Circuit City was an American consumer electronics company founded by Samuel Wurtzel in 1949. By 1990s, Circuit City became the second largest consumer electronics store in the United States with annual sales of $12 billion. On March 8 2009, Circuit City shutdown all its stores. On January 8th at the 2018 Consumer Electronics Show in Las Vegas, Circuit City CEO announced a comeback and relaunch of Circuit City into “a dynamic, a social-focused ecommerce site” and a new business strategy for its retail stores12 .
In this case study, assume that Circuit City hired you as the new chief information officer (CIO) to help relaunch the company into a global e-commerce multinational company.
Assignment should be of 11 pages. APA Format. 4 -5 Professional References. Attached the project rubrics for reference. Make sure to check the rubrics for good score.
Create an Assignment & PowerPoint presentation containing the IT strategic plan that will address Circuit City ecommerce initiatives.
The following information should be covered in the Assignment / presentation.
Abstract
1. Introduction / History of Circuit City
2. What were the issues and challenges that caused the collapse of Circuit City in 2009?
3. What are the issues and challenges with Circuit City 2018 latest e-commerce initiative?
4. Discuss the major competitors in global e-commerce.
5. How would IT deliver value to the business?
6. Proposed the IT infrastructure required to support global e-commerce
7. Proposed the IT budget/cost analysis for the e-commerce initiative
8. Discuss the IT based risks associated with global e-commerce
9. Discuss how IT can leverage innovative technologies such as social media, big data and business intelligence to provide value to the business
10. Discuss the future or emerging technologies that would be leveraged to give Circuit City a competitive advantage.
11. Conclusion
Links:
1 http://circuitcitycorporation.com/circuit-city-to-announce-official-company-relaunch-at-the-2018-consumerelectronics-show-on-january-8th/
2 http://fortune.com/2018/01/09/circuit-city-relaunch-website/
