Category: Computer Science

Deliverable 1: DB Analysis & Query (60 points)
D1: DB Project Analysis & Query: Develop a reasonable and realistic plan and outline the steps to accomplish the integrated project by the end of the course. You can also refer to Garden Glory project questions in §1~3 of the Textbook (at the end of each chapter).
Using these data presented in the list, state assumptions about functional dependencies among the columns of data. Justify your assumptions on the basis of these sample data and also on the basis of what you know about service businesses. Indicate what assumptions need to be checked with the users (GG) and what suggestions you may have about the determinants/keys (e.g., do you need a surrogate key?)
v Hint: refer to Text Chapter 2 for ” Functional Dependency ” and apply that technique to the GG project case
Based on the above analysis and assumptions, split the sample list into tables such that each has only one theme. Demonstrate that the modification problems you identified in question 2 have been eliminated.
v Hint: refer to Text Chapter 2 for ” Normalization Process ” and apply that technique to the GG project case. You can also refer to the 9 possible designs provided in the GG Project Questions section at the end of Chapter 2 in Text book, and choose the best one you believe.

Task 1:
In this task, you will use the scenario to develop an investigative plan of action that will prepare your investigative team to conduct an analysis of the gathered evidence. After reviewing the lesson material within the Course of Study, you will be ready to start the task. First, read the task scenario to gain an understanding of what the task is asking for. Use the task requirements and rubric as a guide to develop your paper.

Overview
As a security analyst, even though it may not relate immediately to your day-to-day job, it’s a best practice to be aware of emerging trends in the industry because they may eventually affect your organization. Think about how fast mobile devices have evolved and become pervasive in both business and personal applications. Managing emerging technologies requires a two-pronged approach: the technological aspect and the social aspect. You might need to upgrade your system and your policies that affect employee behaviors. There is often no right or wrong answer when integrating emerging technologies as long as the technology isn’t detrimental to your system; however, following best practices as defined by the industry, staying current with trade publications, and networking with your peers will help you be successful. As you address the technological and policy-related updates of implementing emerging technology in your organization, it is important to think about what it means to use the technology and adhere to the policies you are updating. Using a systems-thinking approach can help with this.
Scenario
You are a cybersecurity analyst, and your organization has noticed a new trend. More and more employees are bringing their personal devices to work and connecting them to the company’s Wi-Fi. The security team has recognized this as an issue and has decided to create a new segmented network for employees to use for their personal devices. This is a more secure solution because it separates data traffic for personal use and allows the organization to encrypt the communication. This benefits both the employees who want to use their personal devices at work and the organization.
This change to the system includes two steps from two different teams. The IT team is going to build the isolated secure network for employees only, and the security team needs to update the bring your own device (BYOD) policy. Your manager has asked you to draft the update to this policy. Your requirement is to update the policy to reflect the changes in the system in response to this new initiative.
Prompt
Review your organization’s BYOD policy in the Module Six Activity document linked in the Supporting Materials below. After reviewing the BYOD policy, write a response in which you describe a possible modification you would make to this policy to reflect the changes in the system from the scenario. Your response should also describe the impact that this policy update could have on organizational culture.
You must address the critical elements listed below.
Policy Update
Identify three of the most important policy statements from the BYOD policy and explain why they are essential to protecting the organization.
Describe a possible revision to the BYOD policy to meet the new requirement from the emerging workplace trend.
Organizational Impacts
Describe the impacts of this policy update on the organizational culture. For example, if you are aware that your use of personal devices on the company network is being monitored, would this change your behavior? Should it?
From a systems thinking approach, explain how this policy update may affect other organizational processes. For example, will the policy update affect the workflow of other employees?
What to Submit
Your submission should be 1 to 2 pages in length. Use double spacing, 12-point Times New Roman font, and one-inch margins. All sources must be cited using APA format. Use a file name that includes the course code, the assignment title, and your name—for example, CYB_123_Assignment_Firstname_Lastname.docx.
Supporting Materials
The following resource supports your work on the assignment:
Resource: Module Six Activity
This document describes your organization’s BYOD policy. Use this resource to complete the activity.

Overview
As a security analyst, even though it may not relate immediately to your day-to-day job, it’s a best practice to be aware of emerging trends in the industry because they may eventually affect your organization. Think about how fast mobile devices have evolved and become pervasive in both business and personal applications. Managing emerging technologies requires a two-pronged approach: the technological aspect and the social aspect. You might need to upgrade your system and your policies that affect employee behaviors. There is often no right or wrong answer when integrating emerging technologies as long as the technology isn’t detrimental to your system; however, following best practices as defined by the industry, staying current with trade publications, and networking with your peers will help you be successful. As you address the technological and policy-related updates of implementing emerging technology in your organization, it is important to think about what it means to use the technology and adhere to the policies you are updating. Using a systems-thinking approach can help with this.
Scenario
You are a cybersecurity analyst, and your organization has noticed a new trend. More and more employees are bringing their personal devices to work and connecting them to the company’s Wi-Fi. The security team has recognized this as an issue and has decided to create a new segmented network for employees to use for their personal devices. This is a more secure solution because it separates data traffic for personal use and allows the organization to encrypt the communication. This benefits both the employees who want to use their personal devices at work and the organization.
This change to the system includes two steps from two different teams. The IT team is going to build the isolated secure network for employees only, and the security team needs to update the bring your own device (BYOD) policy. Your manager has asked you to draft the update to this policy. Your requirement is to update the policy to reflect the changes in the system in response to this new initiative.
Prompt
Review your organization’s BYOD policy in the Module Six Activity document linked in the Supporting Materials below. After reviewing the BYOD policy, write a response in which you describe a possible modification you would make to this policy to reflect the changes in the system from the scenario. Your response should also describe the impact that this policy update could have on organizational culture.
You must address the critical elements listed below.
Policy Update
Identify three of the most important policy statements from the BYOD policy and explain why they are essential to protecting the organization.
Describe a possible revision to the BYOD policy to meet the new requirement from the emerging workplace trend.
Organizational Impacts
Describe the impacts of this policy update on the organizational culture. For example, if you are aware that your use of personal devices on the company network is being monitored, would this change your behavior? Should it?
From a systems thinking approach, explain how this policy update may affect other organizational processes. For example, will the policy update affect the workflow of other employees?
What to Submit
Your submission should be 1 to 2 pages in length. Use double spacing, 12-point Times New Roman font, and one-inch margins. All sources must be cited using APA format. Use a file name that includes the course code, the assignment title, and your name—for example, CYB_123_Assignment_Firstname_Lastname.docx.
Supporting Materials
The following resource supports your work on the assignment:
Resource: Module Six Activity
This document describes your organization’s BYOD policy. Use this resource to complete the activity.

python script files (or ipynb) with the code for your analysis. Use proper formatting and commenting for readability. All Data files, or links to the data files, used for the analysis Title Slide: Title of the project, course, student name, and date. Problem description: Short description of the problem Data Overview: Explain how you gathered data; explored the data; discuss aspects of the dataset. Hypothesis: Based on your data exploration result, clearly state your hypotheses for prediction. Approach for solving: How you decided to approach the problem Results: Include at least two visualizations and explain what each means. Give results in relation to your hypothesis. Conclusion: Were you correct in your prediction? What lessons can you draw from this? References NO PLAGIARISM!

For the second part of the IR series of explorations, you’ll conduct a natural language search using Google Scholar’s ADVANCED search mode. To access the advanced search option, click on the three line icon in the upper left corner of the Google Scholar search page. Click on Advanced search. As with the Google assignment in Module 1, you are asked to clearly document the steps you took in such a way that anyone can reproduce your search. Use the term ‘fuzzy retrieval’.
Note: Using natural language means using key terms, NOT typing in an entire sentence. The search engine (usually) will ignore terms like ‘a,’ ‘an,’ and ‘the,’ so entering a query like ‘Where can I find information on X?’ isn’t best practice. It’s about using unique terms that you believe with generate on-target results. But don’t take my word for it – take time to experiment (a.k.a. play!) I like to think of words likely to be found in the title or abstract of an article, if that’s what I’m seeking, for example. A search for migrant health Texas in the title field of articles found 16 more pertinent articles; the same search for these terms without specifying the field found 87,700 items with varying levels of pertinence to my need.
About the writing:
Rather than using screenshots, use text to explain. I hate to use a lot of ‘don’t’ statements, but please DON’T structure your report using bullet points. This should be done in an essay format, using subheadings to identify what you’re discussing. I’m very interested in your opinions about the utility of the resources you’re exploring during the semester, but you should consider the writing as a more technically-focused work.
What I mean by this: Support your opinions with evidence, and tell your reader what you have seen, as well as your thoughts about the resource. Go through the directions provided below, making notes on methods, results, and observations. Then go back and write a clear, succinct report that would allow your readers to reproduce what you’ve done. Avoid rambling, and use complete sentences. I do not give expected word or page counts, because we’re all different, but I do look at how clearly and succinctly you have explained processes and outcomes. Here’s an example of the kind of writing I expect:
For my first search I typed “motherboard” into the search bar, then pressed search to the right of the Search Bar. Once the page loaded, I was confronted with centered ads for motherboards. To the left is relevant processor brand categories for more specific results. On my next try I typed in “AMD Motherboards” and was directed to a page with pictures, summaries and price of various kinds of AMD Motherboards.
Here’s what I don’t want:
enter MOTHERBOARD
review results of various kinds
Instructions:
Explain how to get to the advanced search page
Test the capabilities of Google Scholar: Consult the Markey reading, especially Table 12.3 found on pages 225-226, to describe the capabilities of this search engine to perform features described (e.g., Boolean AND, OR, and NOT; word order, truncation, etc.).
Next, conduct a search in Advanced Google Scholar for the same term used in the last module. Describe search options and how you conducted your search.
What are the options for your search? Try specifying that your term or phrase must show up in the TITLE of the page; experiment with date restrictions, and with other filtering options, describing both your process and the result.
Describe what your search retrieved (volume, type of resources: e.g., definitions, commercial sites (ads), scholarly content, news items).
Based on your results, what can you say about the ranking algorithm?
Find a good general research article that defines and describes the topic.
Evaluate its age and authority.
How many times has your chosen article been cited by others?
Create a citation by finding the CITATION link, and copy it into your document. Specify APA format.
Finally, compare and contrast your Google Scholar results with those you got from the Google search in the last module. How does it differ in
How it works (advanced search options)?
The kind of information retrieved (format, intended audience)?
Filtering capabilities?
Be sure to put your name, the course, and assignment name at the top of your document – see the ASSIGNMENT section of the course menu for information on formatting documents.
Double spaced 12 pt writing is required.
Grading will be based on how well you have addressed each of the elements described above: following directions and presenting your work in a well-written manner.

Part 2: Linux Knowledge Check (Paper); (Based on Handling storage, creating partitions, and filesystems, applying ownership and permission, changing permission on a file)
Purpose
A thorough understanding of the Linux file system will assist you in cyber security jobs as well as system engineering jobs. This paper offers you the opportunity to reflect on the knowledge you have gained so far.
Instructions
Based on the knowledge you have achieved thus far, compose a brief synopsis compiling what you have learned about the Linux file system. Describe how you think you will use this knowledge to create Linux (Unix) based systems in the future, whether at home or at your job.

Tell us something about yourself, your experiences, or activities that you believe would reflect positively on your ability to succeed at Penn State.

describes the unique qualities that attract you to the specific undergraduate, college or school to which you are applying at the University of Michigan how would that curriculum support your interests?

Homework Assignment: Research Paper and Webpage Design Wireframe/Storyboard on HTML, CSS, and JavaScript
Project Descriiption:
The objective of this assignment is to research and write a paper defining HTML, CSS, and JavaScript, and then design a wireframe or storyboard for a basic webpage layout. The goal is to understand the foundational web development technologies and apply design principles similar to algorithm design in programming by creating a blueprint for a webpage.
You will use the GCFGlobal Programming Tutorials as your primary resource to explore these technologies and then visualize your understanding through a wireframe or storyboard.
Assignment Details:
1. Research and Writing:
Utilize the GCFGlobal Programming Tutorials to understand the following key concepts:
• HTML (HyperText Markup Language): Research how HTML forms the structure of a webpage by organizing content such as text, images, and links.
• CSS (Cascading Style Sheets): Explore how CSS is used to style the webpage, focusing on design elements such as colors, fonts, spacing, and layout.
• JavaScript: Investigate how JavaScript adds interactivity and dynamic content to webpages, allowing users to engage with the website beyond simple text and images.
2. Writing the Research Paper:
• Introduction: Provide an introduction that outlines the role of HTML, CSS, and JavaScript in web development.
• HTML Section: Define HTML and explain its components, such as tags, elements, and attributes, that structure the content of a webpage.
• CSS Section: Define CSS and explain its role in styling the webpage, covering concepts like selectors, properties, and responsive design.
• JavaScript Section: Define JavaScript and explain how it enhances user interaction through events, dynamic changes, and form validation.
• Conclusion: Summarize the importance of wireframe or storyboard design to a webpage design using HTML, CSS, and JavaScript.
3. Webpage Design Wireframe/Storyboard:
• Wireframe/Storyboard: Create a basic wireframe or storyboard for a webpage that introduces yourself. No need to design the page using HTML, CSS, and Javascriipt yet! This is similar to designing an algorithm before coding, where you plan the structure and features of the webpage in a visual form.
• The wireframe or storyboard should include:
• Page layout with headings, text, images, links, and buttons.
• Visual indication of where CSS styling (colors, fonts, spacing) will be applied.
• Areas where JavaScript interaction or dynamic features will be included (e.g., buttons, forms, or animations).
• You can create the wireframe or storyboard using any of the following tools:
• Hand-drawn sketches scanned and submitted.
• You may also use other digital tools like Balsamiq, Figma, or even PowerPoint.
4. Submission Requirements:
• Your paper should be 300-500 words and include clearly labeled sections for HTML, CSS, and JavaScript.
• Submit a wireframe or storyboard in either PDF, image, or digital format.
• Upload both the research paper and wireframe/storyboard to BrightSpace by the due date shown below.
Due Date: Sunday at noon, October 6, 2024
Grading Criteria:
• Research Paper Content (40%): Clear and accurate definitions of HTML, CSS, and JavaScript based on the GCFGlobal tutorials.
• Wireframe/Storyboard Design (30%): Thoughtful and detailed wireframe or storyboard that demonstrates understanding of webpage structure and design principles.
• Structure and Organization (20%): Clear organization of the research paper with logical flow and distinct sections.
• Grammar and Style (10%): Proper grammar, punctuation, and clarity in writing.
Hints:
• Use the GCFGlobal Programming Tutorials or W3Schools.Com to guide your research.
• Think of the wireframe or storyboard as the webpage’s “algorithm”—a step-by-step design plan before coding.
• Keep your wireframe simple but clear, focusing on how HTML, CSS, and JavaScript will be integrated.
Good luck, and we will learn about webpage design and development next week!