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 …
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