Category: Computer Science

Need all of the labs for this completed I will give the login information to complete and access the labs online.

Need all of the labs for this completed I will give the login information to complete and access the labs online.

For this assignment, you will be diagramming a simple relational database, sometimes called a database schema. This assignment will be the first step in understanding how data is organized in a relational database.
Background
We have learned that the most common type of database is the relational database. No matter what area of Information Technology or Cybersecurity you work in, you will encounter a relational database at some point. This assignment is not intended to make you professional database designers. Rather, it will help you to recognize a relational database so that later in the course, you understand how a relational database can be protected.
Instructions
NOTE: The schema you complete in this assignment will be used in Lab 1.
Use the following Set of Requirements to create your schema. After each field name, enter the data type you think would be correct for the data that will be entered (e.g., for the field ‘HireDate’ show it in your diagram as HireDate (Date):
Two tables: Person and CourseInstructor
Person will have the following fields:
ID (primary key) (Note: Lab 1 uses this fieldname, however PersonID might be better for understanding.)
FirstName
LastName
HireDate
EnrolmentDate
PersonType (Note: values would be Student, Instructor, or Staff)
CourseInstructor will have the following fields:
CourseID (primary key)
InstructorID (Note: Lab 1 uses this fieldname, however PersonID might be better for understanding.)
Be sure to identify the primary key and the relationship line in your diagram!
Using the given set of requirements, create your relational database schema using any application you are familiar with (Access, Word, PowerPoint, Visio, Draw, etc.) [Note: Consider creating a free account at drawSQL (https://drawsql.app). It is easy to create tables and it allows students to show data types/attributes, primary keys, and relationship lines, etc.]
Convert your final one-page schema into PDF format.

Module 1 covered the fundamentals of data, databases, and database management systems (DBMS). Databases are everywhere and whether we realize it or not, we use them in almost all our daily activities. We know that some companies collect terabytes of user data every single day. But did you know that there are organizations that have collected massive amounts of data and are making that data available to the general public for free? One benefit of using these public databases is that queries can be made with a simple input form or two! As you learn more about databases throughout this course, you will begin to appreciate the skill and knowledge required to develop and populate these types of databases.
Below are some large public databases. For this discussion, you may use one of these or any large public database you find.
Annotated Human Genome Data: This is a large database (310 GB) of genome information for humans and about 50 other species. The database has several different methods to access the data, including a simple web interface, export via FTP, MySQL server queries, Perl API, and even a data-mining tool.
Historical Weather Datasets: The National Oceanic and Atmospheric Administration (NOAA) provides time series data and climatological data in several different databases. The various databases provide different series of data. The data can be accessed via a browser interface as well as via specific tools that are provided by the administration.
The Library of Congress: This massive database contains 133 Terabytes of compressed data. A single search could take up to 24 hours to complete. The Library of Congress also has numerous interesting databases containing information on a variety of subjects. Although there is extensive information, it is available through website interfaces rather than through specialized tools or APIs.
The CIA World Factbook: This massive database provides information on history, people, societies, government, economy, energy, geography, communications, transportation, military, and transnational issues for 267 world entities. It includes a variety of world, regional, country, oceanic, and time zone maps; flags of the world; and a country comparison function that ranks country information and data in more than 75 Factbook fields.
Pew Research Center: Pew Research Center is a nonpartisan fact tank that informs the public about the issues, attitudes, and trends shaping the world. They conduct public opinion polling, demographic research, content analysis, and other data-driven social science research.
US Labor, Economic, and Census Data: Various departments of the US government provide large datasets containing information about the US economy, plus labor, commerce, housing, and census data. These databases can be accessed through a browser as well as customized APIs and downloads. Various departments include:
The U.S. Bureau of Labor Statistics website
The United States Census Bureau website
Instructions
For this discussion you will be selecting a large public database and doing some research. Your initial posting should at least include the following, but feel free to add any other interesting things you discover. (Please note the examples are just to get you started, your answers should be more substantial.):
The name and link to the database (e.g., The U.S. Bureau of Labor Statistics at https://www.bls.gov/data/ )
What kind of data does this database collect? (e.g., This database collects data about employment, compensation, living and working conditions….)
Why did you choose this public database? (e.g., I am thinking about a job change and .…)
What were you trying to find out? (e.g., I wanted to find out the average salary of a private archivist.)
Provide keywords or query text you used in your search
OR if you are just clicking on links
Provide a breadcrumb trail to where you found the information: (below is an example of a breadcrumb)
Bureau of Labor Statistics > Publications > Occupational Outlook Handbook > Education, Training, and Library
Provide the results of your search or an explanation why you think you were not able to get the results you expected. (e.g., A private archivist makes an average of $60,050 per year.)

Follow the Excel Exam Project: Community Outreach Link for attachments.
Download and open the Excel_Exam_Project_Instructions attachment. The instruction document will provide you with detailed instructions, requirements and points, and video links to required skill demonstrations.
Grading Rubric-Points: 118-130 Exemplary, 105-117 Proficiency, 92-104 Developing, 79-

Question 3 Information
name: hani alotaibo
id :s230032721
hello, I hope you pay attention. I want correct and perfect work. I want all the questions to be solved correctly and completely without plagiarism. I emphasize this important point. Any percentage of plagiarism will lead to the cancellation of the work. I want a correct solution with references and maintaining the file format without any errors. If you are sure of yourself and that you will do the work correctly, accept the work and make sure of it and your capabilities.

DUE DATE on or before 10/8
Assignment
Describe the 6 symptoms of Group-Think. Then tell me how each symptom can influence a critical thinking skill in groups. Please group your answers together by symptom.
Just do a short paragraph for each.
Turning it in.
Use a word processor to type this. Make sure you type your name, CSE-1100, and the date at the top. Save the file then upload it below by dragging the file onto the box with the Rocket in it. Once you have done that don’t forget to click the submit button in the bottom right corner of the page.

In this class, each student will write an individual capstone project report.
Subject: The topic of research will be an area the student covered in the Cloud Computing program. The project should incorporate hands-on work and theory, covering all aspects of the program study areas.
Criteria:
· The paper must be at least 20 pages long.
· The paper needs to be supported by evidence (citations from peer-reviewed sources).
· A minimum of four (10) peer-reviewed journal citations are required.
· No references should be more than five years old.
· Only three figures, photos, or charts will be accepted in the project report.
· APA formatted citations are required for the final submission.

For this project, you will apply the CompTIA 6-Step Troubleshooting Process to explain how you would tackle Hudson Fisher Associates Help Desk Tickets. There are three groups of tickets, Level 1, Level 2, and Level 3. You will pick two tickets from each group. As you prepare to analyze and hopefully solve these typical IT help desk tickets, keep in mind that for this course, it is more about the process and less about finding the “correct” answer. You may not always find an exact answer from the information given. The problems are structured to approximate what you will find in the workplace. Use a logical and repeatable process (e.g., the CompTIA 6-Step Troubleshooting Process) and eliminate the improbable as you work your way through each scenario. CompTIA 6-Step Troubleshooting Process: Identify the problem. Establish a theory of probable cause. Evaluate the theory to determine the actual cause. Establish a plan of action to resolve the problem and implement the solution. Verify full system functionality and if applicable implement preventative measures. Document findings, actions, and outcomes. How Will My Work Be Evaluated? As you progress in your information technology and cybersecurity career, you may find yourself making presentations to customers, client audiences, and management. For this assignment, you should articulate your findings from the six support cases. But the challenge you face is in expressing a technical solution to a nontechnical audience. Avoid jargon and acronyms. Find a way to relay your solution (and challenges) in language that your audience will find easily relatable. Communicating in this manner will not always be easy. You may struggle to find the right analogy or metaphor. But if you can master the skill of summarizing your results and recommendations to management in an effective presentation, you will demonstrate how you use your technical knowledge to convey your ideas to others in a professional setting. You will also earn the respect and trust of your peers, your supervisor, and upper management as an effective communicator. You will be viewed as an employee ready for advancement. The following evaluation criteria aligned to the competencies will be used to grade your assignment: 1.1.1: Articulate the main idea and purpose of a communication. 1.1.3: Present ideas in a clear, logical order appropriate to the task. 1.3.3: Integrate appropriate credible sources to illustrate and validate ideas. 2.1.1: Identify the issue or problem under consideration. 2.3.1: State conclusions or solutions clearly and precisely. 12.7.2: Explain the process of analyzing IT incidents. 13.1.1: Create documentation appropriate to the stakeholder. Your deliverable for the project is an annotated PowerPoint Presentation covering the following: List of the six tickets you selected (two each from Level 1, Level 2, and Level 3) One to two slides for each ticket, in which you: State the problem. Describe the steps taken to troubleshoot/analyze the problem. Propose a brief resolution. One summary slide: What did you find challenging or interesting about one or two of the support cases (opinion-based)? One reference slide (two to six IEEE references). Include references for materials you consulted in TestOut or on the internet. If you haven’t already done it last week, download the Support Queue Case Study Presentation Template to get started. Delete the instructional text from the template before you submit. Select two help desk tickets from each level and explain in the PowerPoint template how you would solve them. Level 1.1 Ticket 1002: subject mouse not working Assignee: Open Raised by: Irene Fredericks, Human Resources, 10 min ago Category: Mouse?peripherals Priorty: Med Message: My mouse has stopped working. I checked the Windows device manager, and the mouse entry is not there. I need my mouse! Level 1.2 1003 ticket subject black computer screen Assignee: Open Raised by: Todd Schneider, Payroll, 05 min ago Category: Video issue Priority: Med Message: My computer screen is black. I turned the computer off and on and the lights are on the front PC, but that did not resolve the issue. Level 2.1 ticket subject Dell machine making clicking sounds Assignee: Open Raised by: Juan Delarosa, Human Resources, 11 min ago Category: Booting Issue Priority: Med Message: My Dell OptiPlex 9020 Mini Tower will not go to the Windows desktop. I heard a series of audible sounds, like Morse code?!? I think the pattern is one, followed by three, then two. What does that mean? Level 2.2 ticket subject cannot connect to online share drive Assignee: Open Raised by: Blake Chaudhary, Sales Inventory Analyst Category: Network Connectivity Issue Priority: High Message: I need to access my sales projections on the shared drive. I could access them yesterday afternoon, no problem. My boss is really leaning on me to get those figures in and he needs access right away. Follow-Up from Help Desk Associate Jen: When I had Blake do an IPCONFIG for me, he read his IP address as 169.254.2.8. The network address for his unit is 10.20.30.x. I am not sure why it is different. What do you think is going on? level 3.1 Ticket 3003: subject frozen computer Assignee: Open Raised by: Bettina Müller, Fashion Design Category: Computer Crashing Priority: Med Message: My computer is totally frozen. All I see is an error message that says, “controller has failed.” I have a short deadline to pitch for a new line of bags to be show at the Fashion Goods and Accessories Exposition in Osaka. I tried rebooting my machine, but the problem comes back after a few minutes. I have an OptiPlex GX240. LEVEL 3.2 Ticket subject Restart/Update Loop Assignee: Open Raised by: Marci Wallace, Buyer, Tokyo Office Category: Windows Update Priority: High Message: When I turned on my PC at the office today, it started to boot, and then started doing a Windows 10 update. But it keeps trying to reboot and update. It is on the sixth try and still won’t boot up; it’s just the same Windows update install over and over. What should I do? Follow-Up from Help Desk Associate Jen: Windows update is not completing, sending Marci’s PC into an endless loop. From my experience, there can be several underlying issues that may cause Windows Update to fail. You may need to try several different things to resolve the issue. I recommend consulting Microsoft’s knowledge base. https://www.support.com/how-to/how-to-fix-a-windows-pc-that-keeps-rebooting-12992 (File 1 : Presentation slides to use for the template of assignment)

The CompTIA A+ certification demonstrates to employers that you have the knowledge, ability, and skills in entry-level PC technology. Many industry insiders started with the CompTIA A+, and that led them to higher-paying, more complex jobs in both IT and cybersecurity. Many large corporations such as Apple, Cisco, Microsoft, and others recognize the value of the CompTIA A+ certification. For those of you in the military or working for the US Department of Defense, the credential is recognized under Information Assurance Technical (IAT) Level 1 of the DoD 8140/8570 IA Workforce baseline certifications. These skills will serve as your foundation for the more advanced cybersecurity certifications offered by CompTIA (Cloud+, CySA+, Linux+, Network+, Security+, Server+) and other organizations. For this discussion, choose one of the following options (be sure to include the option number in your post title): Option 1: This course and the CompTIA A+ certification will help you prepare for and meet the knowledge and skill requirements needed for job roles including: desktop support specialist field service technician help desk technician help desk support specialist IT support specialist PC technician service desk analyst technical support specialist Go to indeed.com or ziprecruiter.com and conduct research on the A+ certification. Choose a city, state, zip code, or ”remote” area of interest. What did you find? What surprised you? Are the salaries what you expected? Would you be willing to relocate to find a better position or garner more pay? Option 2: Visit the CompTIA.org/CertsRoadmap. Explore the IT careers. What did you find interesting? Where did find the A+ certification? Choose a path and talk about what interests you. Does the tool help you see a career track? Why or why not?