Categories
Writing

Learning Goal: I’m working on a writing discussion question and need a sample dr

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Learning Goal: I’m working on a writing discussion question and need a sample publish to help me learn.
Response to each student
1. Explain the differences between DDL and DML commands.
Data Definition Language (DDL) and Data Manipulation Language are SQL commands.
GeeksforGeeks (2021) explained that DDL are commands used to create, modify, and delete database structures but not the data.
Here is a list of the commands:
Create: This command creates the database or an object (table, index, function, views, store, etc.).
Drop: This command deletes objects from the database
Alter: This command alters the structure of the database
Rename: This command can rename an object that exists in the database.
GeeksforGeeks also shared these details about DML commands; it controls access to data and databases. DCL statements are grouped with DML statements. Here is a list of DML commands:
Insert: used to insert data into a table.
Update: used to update existing data within a table
Delete: used to delete records from a database table.
Select: retrieves one or more rows from a table or view.
According to GeeksforGeeks (2021), DDL creates a database schema and is used to define some constraints. DDL also defines the attributes of a table. In other words, it is like a physical container for data, not the data itself. While DML can add, retrieve or update the data in the table (GeeksforGeeks, 2021). DML offers the flexibility to retrieve, locate, and change data.
Provide practical examples of DDL and DML commands.
DDL example:
CREATE TABLE employee (
Employee_id PRIMARY KEY,
First_name varchar (50),
Last_name varchar (50),
);
DML example:
SELECT
employee_id, first_name,last_name
FROM
employees;
Keyona Teamer
2. Jamie
Greetings class,
Explain the differences between DDL and DML commands
Discussing what data definition language (DDL), data manipulation language (DML), and data control language (DCL) is taking us back to CPT 310 and what we learned from that course. Data definition language lets database administrators outline the structure and schema of a database. Alternatively, DML is a set of commands that allow the user to make changes to the data in the database (Coronel & Morris, 2019). Think of DDL as having the ability to create, alter, or destroy a database, while DML can only manipulate the data that is within the database.
Provide practical examples of DDL and DML commands
Here are some examples of DDL and DML commands.

CREATE TABLE tbldvdtitles (
ASIN varchar(15),
title varchar(100),
price double(5,2),
PRIMARY KEY (ASIN)
);

SELECT price
FROM tbldvdtitles
WHERE price IS NOT NULL;
3. Jamie (2)
Hi there everybody,
Well…this was a whopper of an assignment. I am used to things working similarly to their original counterparts, but I found that Xammp seems to work better on Windows than on a Mac. Having to use a virtual box of Windows 10, I proceeded with the assignments on my Mac Mini.
The tables were easy to build. Good old CPT310 knowledge allowed me to create a database and table quickly:
Code:
Create Database
CREATE DATABASE CST310_Website;
Create Table SQL Script:
CREATE TABLE tblUser (
id int NOT NULL AUTO_INCREMENT,
email VARCHAR(50),
password VARCHAR(100),
firstName VARCHAR(20),
lastName VARCHAR(50),
address VARCHAR(100),
phone VARCHAR(14),
salary double (10, 2),
SSN VARCHAR(11),
PRIMARY KEY (id)
);
Now the not-so-fun part. I’m good at coding, but it gets pretty frustrating when I don’t understand natural functions and how to make alterations to a web page. I knew from the start that I had to add code to the “registration.php” document that we created in Week 1’s assignment. I added a new form section to add labels and a button to submit the data under the “

” section of the body (Connolly & Hoar, 2018). The most important part is to get the form to talk to the php class doc:

Which produced the following:
Then, I needed to create a separate page to perform all the PHP functions, so I created a document called “mysql_conn.php” and went to work. The first thing was to create the error reporting and the variables. The next step was to create the functions “executeSelectQuery” and “executeQuery.” Now I am a neurotic coder, meaning that I like to have error checks everywhere. That being said, I found the need to create these functions redundant. For one, we will not even use the function “executeSelectQuery” for this assignment. Second, you pretty much have to pass the sql query variable into the function, which will use the built-in function “mysqli_query()” regardless of what the variable is. The way I made it work to satisfy the assignment request is to do some of the error checks in the function itself; otherwise, they would be indistinguishable…and that’s bad coding! Never write something twice when you don’t need to!
Next is to create a check to see if the user entered all the values in the fields using the “$_POST” method (Connolly & Hoar, 2018):
if($_SERVER[‘REQUEST_METHOD’] == ‘POST’ && isset($_POST[‘register’])) {
# Do stuff
}
Once that is done, I set the variables from the entry fields to the php variables and pass them to the function. In the future, I will be checking that type of page is being used to get user data to select the appropriate function. After all that was done, I tested my website (six times before I got it right) and had the following submitted to the database:
Setting up the database took me about 5 minutes. The php section took about 3 hrs. Let the discussion commence!

For This or a Similar Paper Click To Order Now

Leave a Reply