My Blog

Tag: Web Development & Systems

  • [Solved] Secure network

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In this assignment, you will apply the various concepts you have learned throughout this course to the design of the single most secure network possible, capable of supporting three IT services: e-mail, file transfer (centralized), and VPN. Use the network diagram and the 3 data flow diagrams provid…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    In this assignment, you will apply the various concepts you have learned throughout this course to the design of the single most secure network possible, capable of supporting three IT services: e-mail, file transfer (centralized), and VPN. Use the network diagram and the 3 data flow diagrams provided to   Write a paper where you  Explain the function and configuration of at least four-fifths of all required network devices, citing specific, credible sources.

    Authentication server (Microsoft Active Directory).

    Routers, switches, and/or hubs.

    Local and remote users.

    Workstations.

    File share (CIFS).

    Mail server.

    Web servers (both internal and external).

    Firewalls.

    Internet cloud.

    Web proxy.

    E-mail proxy.

    FTP server (for internal-to-external transport).

    Explain how the overall network design protects the organization from both inside and outside attacks, addressing all required network design features and considerations and citing specific, credible sources that support your assertions and conclusions. Address:

    Physical and virtual access.

    Logging requirements.

    Security policy.

    Firewalls.

    Proxy servers.

    The VPN tunnel.

    DMZ isolation.

    User authentication.

    Distribution of layer routers and switches.

    Explain how your layered design compensates for possible device failures or breaches in network security, addressing all key design features and considerations and citing specific, credible sources that support your assertions and conclusions. Include:

    Load balancing.

    Swappable devices.

    Standby backup devices.

    QoS prioritization.

    Vendor support for core and services.

    Explain how to make the file transfer process more secure, fully addressing FTP security risks and how specific FTP replacement devices add protection, clearly delineating the features of each device, and citing specific, credible sources that support one's assertions and conclusions.

    Support your main points, assertions, arguments, or conclusions with at least four specific and credible academic sources synthesized into a coherent analysis of the evidence.

    – [\
    \
    dataflowdiagram1.png](https://www.sweetstudy.com/files/dataflowdiagram1-png "dataflowdiagram1.png")
    – [\
    \
    dataflowdiagram2.png](https://www.sweetstudy.com/files/dataflowdiagram2-png "dataflowdiagram2.png")
    – [\
    \
    dataflowdiagram3.png](https://www.sweetstudy.com/files/dataflowdiagram3-png "dataflowdiagram3.png")
    – [\
    \
    Overallnetworkdiagram.png](https://www.sweetstudy.com/files/overallnetworkdiagram-png "Overallnetworkdiagram.png")

    – 2 years ago

  • [Solved] Discussion – Data Modeling

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering Discussion – Data Modeling.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] Data Warehouse and BI

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering Data Warehouse and BI.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] PHISHING EMAIL

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    – 2 years ago **files (1)** – ## GoPhishing.docx **## GoPhishing.docx** From: Bannffield Pet Hospital ( [bannfield1@gmail.com](mailto:bannfield1@gmail.com)) To: Optimumm Wellness Plan Members Subject: CANCELLATION OF OPTIMUMM WELLNESS PLAN ![](https://www.sweetstudy.com/questions/phishing-email-2089…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    – 2 years ago

    **files (1)**

    – ## GoPhishing.docx

    **## GoPhishing.docx**

    From: Bannffield Pet Hospital (
    [bannfield1@gmail.com](mailto:bannfield1@gmail.com))

    To: Optimumm Wellness Plan Members

    Subject: CANCELLATION OF OPTIMUMM WELLNESS PLAN

    ![](https://www.sweetstudy.com/questions/phishing-email-20893103)

    ![](https://www.sweetstudy.com/questions/phishing-email-20893103)

    SUSPENSION OF Optimumm Wellness Plan (OWP)

    Dear Customer

    We are writing to inform you that the payment information for your pet’s Optimumm Wellness Plan (OWP) was unable to be processed.

    In order to avoid cancellation of your pet’s insurance a payment must be received in the next 24 hours through the provided link.

    Please click on the link provided to update your payment information:

    [www.bannffieldpethospital.com/updatebilling](http://www.bannffieldpethospital.com/updatebilling)

    Got questions? Call your Hollywood team at (954) 725-1956

    ![](https://www.sweetstudy.com/questions/phishing-email-20893103)![](https://www.sweetstudy.com/questions/phishing-email-20893103)![](https://www.sweetstudy.com/questions/phishing-email-20893103)![](https://www.sweetstudy.com/questions/phishing-email-20893103)![](https://www.sweetstudy.com/questions/phishing-email-20893103)

    Banfield Pet Hospital © 2023 Mars or Affiliates

    18101 SE 6th Way

    Vancouver, WA 98683 Terms  |  Privacy  |  Contact Us |  Unsubscribe

    By using the information that I have learned from this class, I expect my specific phishing attempt to be successful because I have chosen to target pet owners. It’s a known fact that pet owner’s love their pets like their children. They would not want their pet to be without pet insurance. I love my 4-legged babies and care for them in the best way possible. For this reason, I believe the pet owner’s that don’t notice the spelling errors will click my link and update their credit card information.

    In order to avoid falling prey to phishing attempts I will educate myself first about phishing scams. I will learn as much as I can about what phishing scams are and how they work. I will check the sender’s email address and look closely for misspellings or irregular domain names. Checking for misspelled words and unusual language. Before clicking on any links in the email, I will hover my mouse cursor over them to preview the actual URL. To make sure it matches the official website which it is coming from.

    I know that most companies won’t ask me to provide sensitive information via email. If directed to a website, I will ensure it is secure by looking for "https://" in the URL and a padlock symbol in the browser's address bar. I will enable 2FA to add an extra layer of security to your online accounts and makes it more difficult for phishers to gain access. Installing an antivirus and anti-phishing software on my devices will help detect and block phishing attempts. I will try to keep myself up to date with the latest phishing tactics and stay informed about current phishing campaigns and scams.

    If I came across a phishing email I would avoid interacting with the email's content. I wouldn’t click on any links or download any attachments. I would report phishing emails to my email provider to help prevent others from falling victim to the same scam. Then I would move the phishing email to my spam or trash folder and permanently delete it. I would also contact the company the email claims to be from and inform them about the phishing attempt I just received. I would also tell my co-workers, family and friends my experience and knowledge about phishing attempts to help them avoid falling victim to similar scams.

    Specific clues and telltale signs that help me identify whether an email is a phishing attempt are common characteristics that can raise suspicion. I would look at the type of greeting as these types of emails often use "Dear User" or "Dear Customer" instead of my name. Phishing emails often create a sense of urgency or use threatening language to pressure me into taking immediate action. Look for spelling errors these companies normally proofread their communications prior to sending them out to their customers. Confirm the email addresses it will look similar to real ones but contain slight misspellings or unusual domain names.

    If I were to receive an email from a company that I didn't expect to hear from or you haven't done business is very alarming. If an email offers me something that seems too good to be true, like winning a lottery or getting a large sum of money for no apparent reason, it's likely a phishing scam. These phishing emails may include logos and graphics that appear legitimate but are actually copied or spoofed. Another clue would be the email is being sent to a large number of recipients.

    I feel that the elderly are most likely to fall prey to these phishing attempts because they are less educated and less experienced with technology. They also lack awareness and might even be gullible to this type of emails. The urgency of the subjects would make them click on the provided links in order to make the issues cleared. I think that fear or anxiety, would be able to manipulate them making them much more vulnerable than other individuals. Also, these emails may promise money that all they need is to click the link and curiosity may get the best of them. They elderly don't have strong email security practices either. This reason to make the eldery the primary target to these individuals.

    ## image5.png

    ## image6.png

    ## image7.png

    ## image1.png

    ## image2.png

    ## image3.png

    ## image4.png

    **## GoPhishing.docx**

    From: Bannffield Pet Hospital (
    [bannfield1@gmail.com](mailto:bannfield1@gmail.com))

    To: Optimumm Wellness Plan Members

    Subject: CANCELLATION OF OPTIMUMM WELLNESS PLAN

    ![](https://www.sweetstudy.com/questions/phishing-email-20893103)

    ![](https://www.sweetstudy.com/questions/phishing-email-20893103)

    SUSPENSION OF Optimumm Wellness Plan (OWP)

    Dear Customer

    We are writing to inform you that the payment information for your pet’s Optimumm Wellness Plan (OWP) was unable to be processed.

    In order to avoid cancellation of your pet’s insurance a payment must be received in the next 24 hours through the provided link.

    Please click on the link provided to update your payment information:

    [www.bannffieldpethospital.com/updatebilling](http://www.bannffieldpethospital.com/updatebilling)

    Got questions? Call your Hollywood team at (954) 725-1956

    ![](https://www.sweetstudy.com/questions/phishing-email-20893103)![](https://www.sweetstudy.com/questions/phishing-email-20893103)![](https://www.sweetstudy.com/questions/phishing-email-20893103)![](https://www.sweetstudy.com/questions/phishing-email-20893103)![](https://www.sweetstudy.com/questions/phishing-email-20893103)

    Banfield Pet Hospital © 2023 Mars or Affiliates

    18101 SE 6th Way

    Vancouver, WA 98683 Terms  |  Privacy  |  Contact Us |  Unsubscribe

    By using the information that I have learned from this class, I expect my specific phishing attempt to be successful because I have chosen to target pet owners. It’s a known fact that pet owner’s love their pets like their children. They would not want their pet to be without pet insurance. I love my 4-legged babies and care for them in the best way possible. For this reason, I believe the pet owner’s that don’t notice the spelling errors will click my link and update their credit card information.

    In order to avoid falling prey to phishing attempts I will educate myself first about phishing scams. I will learn as much as I can about what phishing scams are and how they work. I will check the sender’s email address and look closely for misspellings or irregular domain names. Checking for misspelled words and unusual language. Before clicking on any links in the email, I will hover my mouse cursor over them to preview the actual URL. To make sure it matches the official website which it is coming from.

    I know that most companies won’t ask me to provide sensitive information via email. If directed to a website, I will ensure it is secure by looking for "https://" in the URL and a padlock symbol in the browser's address bar. I will enable 2FA to add an extra layer of security to your online accounts and makes it more difficult for phishers to gain access. Installing an antivirus and anti-phishing software on my devices will help detect and block phishing attempts. I will try to keep myself up to date with the latest phishing tactics and stay informed about current phishing campaigns and scams.

    If I came across a phishing email I would avoid interacting with the email's content. I wouldn’t click on any links or download any attachments. I would report phishing emails to my email provider to help prevent others from falling victim to the same scam. Then I would move the phishing email to my spam or trash folder and permanently delete it. I would also contact the company the email claims to be from and inform them about the phishing attempt I just received. I would also tell my co-workers, family and friends my experience and knowledge about phishing attempts to help them avoid falling victim to similar scams.

    Specific clues and telltale signs that help me identify whether an email is a phishing attempt are common characteristics that can raise suspicion. I would look at the type of greeting as these types of emails often use "Dear User" or "Dear Customer" instead of my name. Phishing emails often create a sense of urgency or use threatening language to pressure me into taking immediate action. Look for spelling errors these companies normally proofread their communications prior to sending them out to their customers. Confirm the email addresses it will look similar to real ones but contain slight misspellings or unusual domain names.

    If I were to receive an email from a company that I didn't expect to hear from or you haven't done business is very alarming. If an email offers me something that seems too good to be true, like winning a lottery or getting a large sum of money for no apparent reason, it's likely a phishing scam. These phishing emails may include logos and graphics that appear legitimate but are actually copied or spoofed. Another clue would be the email is being sent to a large number of recipients.

    I feel that the elderly are most likely to fall prey to these phishing attempts because they are less educated and less experienced with technology. They also lack awareness and might even be gullible to this type of emails. The urgency of the subjects would make them click on the provided links in order to make the issues cleared. I think that fear or anxiety, would be able to manipulate them making them much more vulnerable than other individuals. Also, these emails may promise money that all they need is to click the link and curiosity may get the best of them. They elderly don't have strong email security practices either. This reason to make the eldery the primary target to these individuals.

    ## image5.png

    ## image6.png

    ## image7.png

    ## image1.png

    ## image2.png

    ## image3.png

    ## image4.png

  • [Solved] SQL3 Help

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    SQL statements help – 2 years ago **files (3)** – ## Lesson3Questions.docx – Screenshot2025-03-19213507.png – Screenshot2025-03-19213402.png **## Lesson3Questions.docx** You are required to complete exercises 8, 9, 10, and 11 from Chapter 3. For each exercise, you need to create SQL statements and r…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    SQL statements help

    – 2 years ago

    **files (3)**

    – ## Lesson3Questions.docx

    – Screenshot2025-03-19213507.png
    – Screenshot2025-03-19213402.png

    **## Lesson3Questions.docx**

    You are required to complete exercises 8, 9, 10, and 11 from Chapter 3. For each exercise, you need to create SQL statements and related CSV files. Here's what you need to do:

    · Exercise 8: Write your SQL statement in a file named CIS276DA_Lesson3Exercise8_ JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson3Exercise8_ JAM2334209.csv.

    · Exercise 9: Write your SQL statement in a file named CIS276DA_Lesson3Exercise9_ JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson3Exercise9_ JAM2334209.csv.

    · Exercise 10: Write your SQL statement in a file named CIS276DA_Lesson3Exercise10_ JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson3Exercise10_ JAM2334209.csv.

    · Exercise 11: Write your SQL statement in a file named CIS276DA_Lesson3Exercise11_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise11_ JAM2334209.csv .

    · Custom Query 1: Create a SELECT statement that uses WHERE. Save this SQL statement as CIS276DA_Lesson3Custom1_ JAM2334209.sql .  Run the script and export the results to CIS276DA_Lesson3Custom1_ JAM2334209.csv.

    · Custom Query 2:  Create a SELECT statement that uses ORDER BY and LIMIT.  Save this SQL statement as CIS276DA_Lesson3Custom2_ JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson3Custom2_ JAM2334209.csv.

    **Submission Instructions:**

    1. Place all SQL files(6) and CSV files(6) in a folder labeled "Lesson 3".

    2. Replace "MEID" in the file names with your actual MEID.

    **Screenshot2025-03-19213507.png**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot2025-03-19213507-png)

    **Screenshot2025-03-19213402.png**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot2025-03-19213402-png)

    **Screenshot2025-03-19213402.png**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot2025-03-19213402-png)

    **## Lesson3Questions.docx**

    You are required to complete exercises 8, 9, 10, and 11 from Chapter 3. For each exercise, you need to create SQL statements and related CSV files. Here's what you need to do:

    · Exercise 8: Write your SQL statement in a file named CIS276DA_Lesson3Exercise8_ JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson3Exercise8_ JAM2334209.csv.

    · Exercise 9: Write your SQL statement in a file named CIS276DA_Lesson3Exercise9_ JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson3Exercise9_ JAM2334209.csv.

    · Exercise 10: Write your SQL statement in a file named CIS276DA_Lesson3Exercise10_ JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson3Exercise10_ JAM2334209.csv.

    · Exercise 11: Write your SQL statement in a file named CIS276DA_Lesson3Exercise11_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise11_ JAM2334209.csv .

    · Custom Query 1: Create a SELECT statement that uses WHERE. Save this SQL statement as CIS276DA_Lesson3Custom1_ JAM2334209.sql .  Run the script and export the results to CIS276DA_Lesson3Custom1_ JAM2334209.csv.

    · Custom Query 2:  Create a SELECT statement that uses ORDER BY and LIMIT.  Save this SQL statement as CIS276DA_Lesson3Custom2_ JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson3Custom2_ JAM2334209.csv.

    **Submission Instructions:**

    1. Place all SQL files(6) and CSV files(6) in a folder labeled "Lesson 3".

    2. Replace "MEID" in the file names with your actual MEID.

    **Screenshot2025-03-19213507.png**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot2025-03-19213507-png)

    **Screenshot2025-03-19213402.png**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot2025-03-19213402-png)

    **## Lesson3Questions.docx**

    You are required to complete exercises 8, 9, 10, and 11 from Chapter 3. For each exercise, you need to create SQL statements and related CSV files. Here's what you need to do:

    · Exercise 8: Write your SQL statement in a file named CIS276DA_Lesson3Exercise8_ JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson3Exercise8_ JAM2334209.csv.

    · Exercise 9: Write your SQL statement in a file named CIS276DA_Lesson3Exercise9_ JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson3Exercise9_ JAM2334209.csv.

    · Exercise 10: Write your SQL statement in a file named CIS276DA_Lesson3Exercise10_ JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson3Exercise10_ JAM2334209.csv.

    · Exercise 11: Write your SQL statement in a file named CIS276DA_Lesson3Exercise11_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise11_ JAM2334209.csv .

    · Custom Query 1: Create a SELECT statement that uses WHERE. Save this SQL statement as CIS276DA_Lesson3Custom1_ JAM2334209.sql .  Run the script and export the results to CIS276DA_Lesson3Custom1_ JAM2334209.csv.

    · Custom Query 2:  Create a SELECT statement that uses ORDER BY and LIMIT.  Save this SQL statement as CIS276DA_Lesson3Custom2_ JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson3Custom2_ JAM2334209.csv.

    **Submission Instructions:**

    1. Place all SQL files(6) and CSV files(6) in a folder labeled "Lesson 3".

    2. Replace "MEID" in the file names with your actual MEID.

    **Screenshot2025-03-19213507.png**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot2025-03-19213507-png)

    **Screenshot2025-03-19213402.png**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot2025-03-19213402-png)

  • [Solved] computering

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    Select three of the scenarios below and write up a paragraph for EACH scenario analyzing the ethical issues. Use the Ten Commandments of Computer Ethics as your frame of reference. At a minimum, identify the violator(s), violation(s), which commandment(s) they violate, why, and/or how, and what you …

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Select three of the scenarios below and write up a paragraph for EACH scenario analyzing the ethical issues. Use the Ten Commandments of Computer Ethics as your frame of reference. At a minimum, identify the violator(s), violation(s), which commandment(s) they violate, why, and/or how, and what you feel should happen to the violator(s).

    A company’s employee uses their work computer to test some software that their friend bought. It only takes a few minutes and they uninstall it after they are done.

    A company’s employee gives a friend who works at a different company a copy of a proprietary software for them to use.

    A company’s employee was curious as to what the “higher-ups” pay looks like.They break the passcodes and take a quick peek at the salaries.

    A bank teller transfers money from a customer account into their account to pay a bill that is overdue. Three days later, the bank teller gets paid and transfers the money back.

    A college student shares their password and computer lab access id with a fellow student who is not taking a computer class that requires a lab. The fellow student uses three hours of computer time to complete the government homework and prints a few recipes for their mom.

    You are a software developer and you are asked to develop an app that will intentionally generate inaccurate information for a client. You are told in no uncertain terms that you must develop the app or lose your job.You write the program.

    Be sure to reference ethical guidelines you learned from the module content and clearly identify the ethical dilemma(s) and/or violation(s).

    Minimum requirements:

    A minimum of one full paragraph per each scenario

    Submit only one document via the link title above.

    Use paragraph structure. Use complete sentences and proper grammar and spelling.

    Place a header on your page that contains your first and last name, the assignment name, and the course code from page two of the syllabus.

    Your document must be one of the following formats (.doc, .docx, or .rtf).

    Cite any and all sources.

    Save the file as <LastNameFirstInitial_M3HW> Example: OserK_M3HW

    – 2 years ago

  • [Solved] Vig Ass

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering Vig Ass.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] SQL 10 help

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    SQL statements – 2 years ago **files (1)** – ## Lesson10questions.docx **## Lesson10questions.docx** In this project, you will create a Node.js application that interacts with a MySQL database. You'll practice executing various types of queries, such as INSERT, SELECT, UPDATE, and DELETE, to manage …

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    SQL statements

    – 2 years ago

    **files (1)**

    – ## Lesson10questions.docx

    **## Lesson10questions.docx**

    In this project, you will create a Node.js application that interacts with a MySQL database. You'll practice executing various types of queries, such as INSERT, SELECT, UPDATE, and DELETE, to manage employee records in the database.

    **Instructions:**

    **Setup:**

    Make sure you have Node.js and MySQL installed on your system. Create a new folder for your project and navigate to it using the command line.

    **Database Setup:**

    Create a new MySQL database named "employee_db" or a name of your choice. Create a table named "employees" with columns "id" (INT), "name" (VARCHAR), and "job_title" (VARCHAR).

    **Node.js Application:**

    Inside your project folder, create a new file named "app.js".

    **Connect to the Database:**

    Require the mysql npm package and create a connection to the MySQL database using your database credentials.

    **INSERT Statement:**

    Write a function to insert a new employee record into the "employees" table. Use the connection.query() method to execute an INSERT query.

    **SELECT Statement:**

    Write a function to retrieve the names of all employees from the "employees" table. Use the connection.query() method to execute a SELECT query.

    **UPDATE Statement:**

    Write a function to update the job title of an employee. Use the connection.query() method to execute an UPDATE query.

    **DELETE Statement:**

    Write a function to delete an employee record from the "employees" table. Use the connection.query() method to execute a DELETE query.

    **Execution:**

    Run your Node.js application using the command node app.js. Check the console output for the results of each query.

    **Example Code Snippets:**

    Here's an example of how your "app.js" file could be structured:

    const mysql = require('mysql');

    const connection = mysql.createConnection({
    host: "localhost",
    user: "yourusername",
    password: "yourpassword",
    database: "employee_db"
    });

    connection.connect(function(err) {
    if (err) throw err;
    console.log("Connected to MySQL server!");

    // Write your INSERT, SELECT, UPDATE, and DELETE functions here

    // Close the connection
    connection.end(function(err) {
    if (err) throw err;
    console.log("Connection closed");
    });
    });

    Note: Replace 'yourusername' and 'yourpassword' with your actual MySQL credentials.

    **Submission Instructions**

    1. Place all of your files for this project in a folder labeled "Lesson 10." In the file names, be sure to replace MEID with your actual MEID.

    CIS276DA_XXXXX_JAM2334209.sql

    **## Lesson10questions.docx**

    In this project, you will create a Node.js application that interacts with a MySQL database. You'll practice executing various types of queries, such as INSERT, SELECT, UPDATE, and DELETE, to manage employee records in the database.

    **Instructions:**

    **Setup:**

    Make sure you have Node.js and MySQL installed on your system. Create a new folder for your project and navigate to it using the command line.

    **Database Setup:**

    Create a new MySQL database named "employee_db" or a name of your choice. Create a table named "employees" with columns "id" (INT), "name" (VARCHAR), and "job_title" (VARCHAR).

    **Node.js Application:**

    Inside your project folder, create a new file named "app.js".

    **Connect to the Database:**

    Require the mysql npm package and create a connection to the MySQL database using your database credentials.

    **INSERT Statement:**

    Write a function to insert a new employee record into the "employees" table. Use the connection.query() method to execute an INSERT query.

    **SELECT Statement:**

    Write a function to retrieve the names of all employees from the "employees" table. Use the connection.query() method to execute a SELECT query.

    **UPDATE Statement:**

    Write a function to update the job title of an employee. Use the connection.query() method to execute an UPDATE query.

    **DELETE Statement:**

    Write a function to delete an employee record from the "employees" table. Use the connection.query() method to execute a DELETE query.

    **Execution:**

    Run your Node.js application using the command node app.js. Check the console output for the results of each query.

    **Example Code Snippets:**

    Here's an example of how your "app.js" file could be structured:

    const mysql = require('mysql');

    const connection = mysql.createConnection({
    host: "localhost",
    user: "yourusername",
    password: "yourpassword",
    database: "employee_db"
    });

    connection.connect(function(err) {
    if (err) throw err;
    console.log("Connected to MySQL server!");

    // Write your INSERT, SELECT, UPDATE, and DELETE functions here

    // Close the connection
    connection.end(function(err) {
    if (err) throw err;
    console.log("Connection closed");
    });
    });

    Note: Replace 'yourusername' and 'yourpassword' with your actual MySQL credentials.

    **Submission Instructions**

    1. Place all of your files for this project in a folder labeled "Lesson 10." In the file names, be sure to replace MEID with your actual MEID.

    CIS276DA_XXXXX_JAM2334209.sql

  • [Solved] Virtualization

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    ## **Instructions** For this assignment, the Caduceus CTO, Eliza, has asked you to create a working proof of concept. **Step 1: Access Your AWS Academy Learner Lab Virtual Environment** CMIT 495 requires you to complete hands-on assignments in a virtual environment. We will be using Amazon Web Servi…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    ## **Instructions**

    For this assignment, the Caduceus CTO, Eliza, has asked you to create a working proof of concept.

    **Step 1: Access Your AWS Academy Learner Lab Virtual Environment**

    CMIT 495 requires you to complete hands-on assignments in a virtual environment. We will be using Amazon Web Services (AWS) for this. Accessing the link through your LEO classroom will automatically add you to an AWS Academy Learner Lab.

    Review the following AWS Academy Student Guide found in the AWS Academy Learner module.

    _**Note**_ _: The_ [_AWS Academy Student Guide_](https://learn.umgc.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1247086&type=lti&rcode=UMUC-9389772&srcou=1300302) _provides students with instructions for using AWS Academy Learner Labs. The Learner Lab offers a lab environment suitable for student projects over a period designated by the department._

    **Step 2: Download the Week 1 Project Template**

    Download the template you will use to submit your project: [Project 1 Virtualization Assignment Template](https://learn.umgc.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1247086&type=coursefile&fileId=Project+1+Virtualization+Assignment+Template+(2252).docx)

    **Step 3: Install and Configure an AWS EC2 Instance (Virtual Machine)**

    Using your AWS Learner Lab Virtual Environment, install and configure an Ubuntu Server virtual machine (VM) using the most recent version of the 64-bit operating system.

    You will need to provide a detailed overview of the steps required to install the Ubuntu server operating system on the virtual machine, including screenshots of each step in the process in the Week 1 Assignment Template.

    Review the following documentation detailing an overview and step-by-step procedure on how to install and configure an AWS EC2 instance.

    – [Getting Started with Amazon EC2](https://aws.amazon.com/pm/ec2/?trk=36c6da98-7b20-48fa-8225-4784bced9843&sc_channel=ps&sc_campaign=acquisition&sc_medium=ACQ-P|PS-GO|Brand|Desktop|SU|Compute|EC2|US|EN|Text&s_kwcid=AL!4422!3!536323490070!p!!g!!aws%20ec2%20virtual%20machine&ef_id=CjwKCAjw9LSSBhBsEiwAKtf0n3WxjDO0dwhp9lmbp0oWuMpp_xMV-WOsQI9AMrxo9Cn3__C-gIOe7RoCUycQAvD_BwE:G:s&s_kwcid=AL!4422!3!536323490070!p!!g!!aws%20ec2%20virtual%20machine)
    – [Create an EC2 instance and install a web server](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Tutorials.WebServerDB.CreateWebServer.html)
    – [Get started with Amazon EC2 Linux instances](https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/EC2_GetStarted.html)

    **Step 4: Complete the Week 1 Project and Upload to the Assignment Folder**

    Answer the questions and embed the appropriate screenshots of your Ubuntu server installation. When providing a detailed overview of the steps required to install the Ubuntu server operating system on the virtual machine, make sure to include screenshots of each step in the process. Further details and instructions are included within the Week 1 Assignment Template.

    **How Will My Work Be Evaluated?**

    The following evaluation criteria aligned to the competencies will be used to grade your assignment:

    – 1.1.3: Present ideas in a clear, logical order appropriate to the task.
    – 1.4.1: Produce grammatically correct material in standard academic English that supports communication.
    – 2.3.1: State conclusions or solutions clearly and precisely.
    – 11.1.3: Install the software.
    – 11.2.1: Configure technology according to stakeholder specifications and requirements.
    – 11.3.1: Add and update systems as required.
    – 13.2.1: Evaluate vendor recommendations in the context of organization requirements.

    – 2 years ago

  • [Solved] Research

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering Research.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.