Part 2

Software skills: Database design and querying

Business skills: Inventory management

In this exercise, you will use database software to design a database for managing inventory for a small business. Kamen Rider, located in New York, sells road, mountain, hybrid, leisure, and children’s bicycles. Currently, Kamen Rider’s purchases bikes from three suppliers but plans to add new suppliers in the near future. Using the information found in the tables given in the small desktop database, help manage information about Kamen Rider’s suppliers and products. Perform the following.

1. Execute a query that identifies the five most expensive bicycles (for customers). The query should list the bicycles in descending order from most expensive to least expensive (by Selling Price), the quantity on hand for each, and the markup percentage for each. Save this query as Q1_Five_Most_Expensive_Bicycles. Hint: Profit Mark Up = (Selling Price – Cost Price)/Cost Price. (2.5 points)

2. Execute a query that lists each supplier, its products, the quantities on hand, and associated reorder levels. For each supplier, the products should be sorted alphabetically. Include a criterion for bicycles that have Quantity_on_Hand that is more than 5. Hint: This requires hierarchical sorting and a numerical filter. Save this query as Q2_Supplier_Product (2.5 points)

3. Execute a query listing only the bicycles with names starting with “E” as well as those that end with “er”, and their corresponding suppliers. In your query, include the Product Name, Purchase Cost, and the supplier’s Company_Name. This needs a little bit of thinking. Save this query as Q3_BR_bicycles (2.5 points).

4. To enhance the database, we need a table of supplier information. Create a table called Supplier_Info that has supplier telephone numbers. For full credit here, include an appropriate input mask. Populate the table with the appropriate fields. Populate the table with the suppliers to demonstrate our ability to enter data to a database and to check that it works. Be sure to enter all suppliers (there should be 5). Make up the telephone numbers. This requires some thinking on what field(s) to include other than telephone numbers in the new table. Recall that databases should be normalized, and we should join apples to apples, oranges to oranges; and we want to avoid redundancies. For purposes of this assignment, create the table accordingly. There’s no need to join other tables. Save this table as Supplier_Info (2.5 points).

Your work will be evaluated on the accuracy of the results, quality of your answers, and ability to apply the concepts. Submit your work on Canvas. There should be 2 documents: (1) a single word document (or pdf) for part 1, and (2) the database file (Access file) for part 2 by the due date. Late submissions will result in a 5% penalty for each day late.

1. Do some Internet research to identify businesses who have suffered because of cloud security weaknesses or failures. What can companies who are contemplating cloud computing services learn from the negative experiences of these businesses?

 2. Do some Internet research on security mechanisms associated with virtualization. How can virtualization be used by cloud service providers to protect subscriber data? 

 3. Choose one of the following cloud services categories: SaaS, IaaS, PaaS. Do some Internet research that focuses the security issues associated with the selected cloud service category. Summarize the major security risks associated with the cloud service category and identify mechanisms that can be used to address these risks. 

 Read the Case Study and answer the “Discussion Points” in a clear but concise way. Be sure to reference all sources cited and use APA formatting throughout. 

Answer the following 12 questions by selecting the single BEST answer for each. Using your course materials and/or other credible resources, provide a 50–100-word explanation on why you chose your answer. Please cite your sources for your answers from your course materials or other credible resources.

1. You must provide SOC 2 and SOC 3 reports on the security, availability, confidentiality, processing integrity, and privacy of operational controls. As part of these reports, you must provide information regarding the disclosure of data to third parties. To which tenet of SOC 2 and SOC 3 does this information apply?

A. Privacy
B. Security
C. Confidentiality

2. You must provide SOC 2 and SOC 3 reports on the security, availability, confidentiality, processing integrity, and privacy of operational controls. As part of these reports, you must provide information regarding the backup and restoration of data. To which tenet of SOC 2 and SOC 3 does this information apply?

A. Privacy
B. Availability
C. Security

3. As part of routine maintenance, your organization requires that system administrators perform a routine access review and audit. As part of this process, you decide to audit user access to files and folders. Which Windows audit policy should you enable?

A. Object access
B. Logon events
C. Account logon events
D. Directory service access

4. You have received a list of users and their jobs. You need to implement the principle of least privilege. What is the next step that should be performed?

A. Determine the minimum set of privileges needed to perform the user’s job.
B. Determine the maximum set of privileges needed to perform the user’s job.
C. Configure the appropriate privileges for the user’s account.

5. Which statement best describes a two-man control?

A. Two operators work together to complete a given task.
B. Two operators review and approve each other’s work.
C. An operator handles more than one position within an organization.

6. Which type of security identifies the process of safeguarding information assets after the implementation of security?

A. Physical security
B. Operations security
C. Application security

7. Several users in your organization have administrative-level user accounts. During a recent security audit, the auditors suggest that new user accounts be created for these users to grant the users the minimum permissions that they need to carry out their daily tasks. The users should only use their administrative-level accounts when performing administrative-level tasks. Which operations security principle is being implemented?

A. Separation of duties
B. Least privilege
C. Job rotation

8. As an organization’s security administrator, you must prevent conflicts of interest when assigning personnel to complete certain security tasks. Which operations security tenet are you implementing?

A. Separation of duties
B. Due diligence
C. Due care

9. Which of the following is MOST important to the success of an information security program?

A. Senior management sponsorship
B. Security awareness training
C. Adequate start-up budget and staffing

10. What is the BEST defense against a structured query language injection attack?

A. Regularly updated signature files
B. Strict controls on input fields
C. A properly configured firewall

11. Which of the following is the MOST important consideration when implementing an intrusion detection system?

A. Patching
B. Tuning
C. Encryption

12. Which of the following is the MOST important consideration when securing customer credit card data acquired by a point-of-sale cash register?

A. Authentication
B. Hardening
C. Encryption

Prepare a 3-5 page paper on cryptocurrencies and security and dispute  resolution and support your findings with research. How have  cryptocurrencies taken a dominant role in this area? Explain.

Your paper should be 3 pages long (excluding the title and reference pages) and formatted according to APA.

Compose your essay in APA format, including the introduction and  conclusion, and in-text citations for all sources used. In addition to  your 3-5 page essay, you must include an APA-style title page and  reference page.

Discussion 5.1

What is the Model Builder? Explain. 

Provide the examples of the industries where it will it be the most useful.

Discussion 5.2

When will be useful to apply for Spatial Analyst extension? Give some examples. 

Minimum 110 words excluding references 

Case Study 6.1

Case Study 12.1 The Problems of Multitasking

1. How does multitasking confuse the resource availability of project team personnel?
2. “In modern organizations, it is impossible to eliminate multitasking for the average ­employee.” Do you agree or disagree with this statement? Why?
3. Because of the problems of multitasking, project managers must remember that there is a difference between an activity’s duration and the project calendar. In other words, 40 hours of work on a project task is not the same thing as one week on the baseline schedule. Please comment on this concept. Why does multitasking “decouple” activity duration estimates from the project schedule?

Writing Requirements

• 2-3 pages in length  (excluding cover page, abstract, and reference list)
• APA 6th edition, Use the APA template located in the Student Resource Center to complete the assignment.
• Please use the Case Study Guide as a reference point for writing your case study.