Assignment Instructions Part 1: Skills Review

Assignment Instructions Part 1 50complete The Skills Review Starti

Part 1 (50%) Complete the Skills Review – starting at Step 3 on pages Access 19 – Access 21 in Module 1: Getting Started with Access 2016, in the Friedrichsen text. You must create a new database, so pay close attention to Step 3.a. You are “not” required to print the tables for Step 8.c. (Note: the ProspectID field should be set as the primary key for the Prospects table after Step 3.b). Name the Access database file Last Name_LakeHomeMarketing (i.e., Smith_LakeHomeMarketing).

Paper For Above instruction

The first part of this assignment focuses on developing practical skills in Microsoft Access 2016, specifically through the completion of a database creation exercise outlined in the Friedrichsen text. Starting from Step 3 on pages Access 19 to Access 21 of Module 1: Getting Started with Access 2016, students are instructed to create a new database. This task emphasizes understanding foundational database design principles, including selecting appropriate primary keys and organizing data effectively. The emphasis on not printing the tables in Step 8.c allows students to concentrate on the database structure and relationships without the additional step of documentation. Naming conventions are stressed, with the required database filename formatted as Last Name_LakeHomeMarketing, such as Smith_LakeHomeMarketing, reinforcing best practices in file management and identification.

The primary objectives here are to ensure students are familiar with the process of database creation, understand primary key assignment, and develop attention to detail in naming conventions. These skills are fundamental for database management and essential for future assignments or real-world applications where data integrity and organization are paramount. Completing this part of the assignment sets a strong foundation for more advanced database operations and enhances proficiency in using Access for data management tasks.

By engaging with this exercise, students will learn to navigate Access’s interface, input data according to specified guidelines, and appreciate the importance of structure in database design. This assignment also encourages careful reading of instructional materials and attentive following of procedural steps, which are crucial skills in any technical or data-centric workflow. Overall, this part of the assignment aims to strengthen practical skills that are highly valued in business, IT, and data analysis roles, supporting overall academic and professional development in database management.

Part 2: Review Questions and Analysis

The second component of this assignment involves answering Review Question 3.10 from the Connolly text on page 96. This question asks students to describe the three service models defined by the National Institute of Standards and Technology (NIST), analyze the most important benefit of cloud computing and justify their choice, and identify the most critical risk associated with cloud computing and reason their selection.

Firstly, the three service models defined by NIST are Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS). Infrastructure as a Service (IaaS) provides virtualized computing resources over the internet, allowing users to rent servers, storage, and networking infrastructure. PaaS offers a platform allowing developers to build, test, and deploy applications without managing underlying infrastructure. SaaS delivers ready-to-use software applications accessible via web browsers, eliminating the need for local installation and maintenance. These models vary in complexity, control, and management responsibilities, offering different levels of abstraction suited to diverse business needs.

The most important benefit of cloud computing, in my opinion, is scalability. Cloud services offer dynamic resource allocation, enabling organizations to easily expand or contract their IT infrastructure based on demand. This flexibility results in cost savings by reducing the need for physical hardware investments and allows businesses to adapt quickly to market changes. For example, during peak periods, such as seasonal sales or new product launches, companies can leverage cloud scalability to meet increased customer demand without additional hardware investments, thus providing a competitive edge. The ability to scale efficiently can directly impact operational resilience and customer satisfaction, making it a primary advantage of cloud computing adoption.

Conversely, a significant risk associated with cloud computing is data security and privacy. Storing sensitive data outside the organization’s physical infrastructure raises concerns about unauthorized access, data breaches, and compliance with data protection regulations. As reliance on third-party cloud providers increases, organizations entrust them with critical information, which can be vulnerable to cyberattacks or mishandling. For my part, I consider data security and privacy the most pressing risks because a breach can lead to substantial financial losses, reputational damage, and legal consequences. Ensuring robust security measures and compliance protocols is vital to mitigate this risk and protect organizational assets in a cloud environment.

In summary, understanding NIST’s service models provides foundational knowledge of cloud service offerings, while recognizing scalability as the most beneficial feature underscores the strategic advantage cloud computing provides. Simultaneously, addressing the primary risk of data security emphasizes the importance of comprehensive security strategies. These insights collectively guide organizations in leveraging cloud technology effectively and responsibly, aligning technological capabilities with business objectives.

References

  • Friedt, M. (2019). Getting Started with Access 2016. Friedrichsen Publishing Group.
  • Connolly, T., & Begg, C. (2014). Database Systems: A Practical Approach to Design, Implementation, and Management (6th ed.). Pearson.
  • National Institute of Standards and Technology. (2011). The NIST Definition of Cloud Computing. Special Publication 800-145.
  • Armbrust, M., Fox, A., et al. (2010). A view of cloud computing. Communications of the ACM, 53(4), 50-58.
  • Marston, S., Li, Z., et al. (2011). Cloud computing — The business perspective. Decision Support Systems, 51(1), 176-189.
  • Zhang, Q., Cheng, L., & Boutaba, R. (2010). Cloud computing: State-of-the-art and research challenges. Journal of Internet Services and Applications, 1(1), 7-18.
  • Fang, H., Zhang, Y., & Liu, G. (2013). A survey of cloud computing security. Journal of Cloud Computing, 2(1), 3.
  • Subashini, S., & Kavitha, V. (2011). A survey on security issues in service delivery models of cloud computing. Journal of Network and Computer Applications, 34(1), 1-11.
  • Rimal, B. P., et al. (2017). Understanding cloud computing: Challenges and opportunities. Proceedings of the IEEE, 106(8), 1364-1381.
  • Garrison, G., et al. (2012). Strategic cloud computing: Opportunities and challenges. Business Horizons, 55(2), 139-149.

Related Assignments