Just follow the instructions on the attached “WORD” documents. The final product should be for the “Week 5” document

Our papers are 100% unique and written following academic standards and provided requirements. Get perfect grades by consistently using our writing services. Place your order and get a quality paper today. Rely on us and be on schedule! With our help, you'll never have to worry about deadlines again. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

Just follow the instructions on the attached “WORD” documents. The final product should be for the “Week 5” document

Just follow the instructions on the attached “WORD” documents. The final product should be for the “Week 5” document
In this lab you will create a database and a table in that database. You will insert data into the table. Show screen shots of your commands being carried out. Creating a Database Launch MYSQL command prompt or Workbench Create a database called contacts The command to create a database is: CREATE DATABASE database_name; Command: CREATE DATABASE contacts; To get access to your database you will carryout the USE command. USE contacts; Creating a Table Before you can store data in a database, you must first create a table for your data. You do this by using the CREATE TABLE statement. The syntax for the CREATE TABLE statement is as follows. CREATE TABLE database_name.table_name (column_1 data_type_1, column_2 data_type_2, … [PRIMARY KEY (columns)] ); To create a table in your default database, you do not need to qualify the table name with the database name. From now on, the book examples will use sales as the default database. Listing 1.1 shows a CREATE TABLE statement for creating a contact_info table with four columns. Listing 1.1: Creating a contact_info table with four columns CREATE TABLE contact_info ( contactID VARCHAR (6), firstname VARCHAR (15), lastname VARCHAR (15), phone VARCHAR (13), PRIMARY KEY (contactID) ); Adding data to your table Once you have a table, you can add data to it using the INSERT statement. The syntax for the INSERT statement is as follows INSERT INTO table (column_1, column_2, … ) VALUES (value_1, value_2, … ) ); For example, Listing 1.2 shows an SQL statement that inserts a row into the product table. Listing 1.2: Inserting a row into the contact_info table INSERT INTO contact_info (contactID, firstname, lastname, phone) VALUES (100, ‘John’, ‘Smith’, ‘718-555-1234′); After you execute the statement in Listing 1.2, your product table will have one row. You can query your table using this statement. SELECT * FROM contact_info; +——–+——–+——-+————+ You can insert more than one row in an INSERT statement. The INSERT statement in Listing 1.3 add five more rows to the product table. Listing 1.3: Adding five more rows to the product table INSERT INTO contact_info (contactID, firstname, lastname, phone) VALUES (100, ‘John’, ‘Smith’, ‘718-555-1234′) (200, ‘Jane’, ‘Doe’, ‘347-555-1234′), (300, ‘Fred’, ‘Brown’, ‘212-555-1234′), (400, ‘Donald’, ‘Duck’, ‘646-555-1234′); ############################################################################## WEEK 5 ASSIGNMENT Make sure that the database and table are created as detailed above from week 3 assignment. Make sure the data is entered as detailed above. Conduct the queries below and provide screenshots of your results. Week 5 Assignment Queries: Select all contacts showing only their names. Select and show contacts phone numbers Select and show contacts with the last name Brown Select contacts with the contact ID greater than 200 Place your results as a screen shot below:
Just follow the instructions on the attached “WORD” documents. The final product should be for the “Week 5” document
In this lab you will create a database and a table in that database. You will insert data into the table. Show screen shots of your commands being carried out. Creating a Database Launch MYSQL command prompt or Workbench Create a database called contacts The command to create a database is: CREATE DATABASE database_name; Command: CREATE DATABASE contacts; To get access to your database you will carryout the USE command. USE contacts; Creating a Table Before you can store data in a database, you must first create a table for your data. You do this by using the CREATE TABLE statement. The syntax for the CREATE TABLE statement is as follows. CREATE TABLE database_name.table_name (column_1 data_type_1, column_2 data_type_2, … [PRIMARY KEY (columns)] ); To create a table in your default database, you do not need to qualify the table name with the database name. From now on, the book examples will use sales as the default database. Listing 1.1 shows a CREATE TABLE statement for creating a contact_info table with four columns. Listing 1.1: Creating a contact_info table with four columns CREATE TABLE contact_info ( contactID VARCHAR (6), firstname VARCHAR (15), lastname VARCHAR (15), phone VARCHAR (13), PRIMARY KEY (contactID) ); Adding data to your table Once you have a table, you can add data to it using the INSERT statement. The syntax for the INSERT statement is as follows INSERT INTO table (column_1, column_2, … ) VALUES (value_1, value_2, … ) ); For example, Listing 1.2 shows an SQL statement that inserts a row into the product table. Listing 1.2: Inserting a row into the contact_info table INSERT INTO contact_info (contactID, firstname, lastname, phone) VALUES (100, ‘John’, ‘Smith’, ‘718-555-1234′); After you execute the statement in Listing 1.2, your product table will have one row. You can query your table using this statement. SELECT * FROM contact_info; +——–+——–+——-+————+ You can insert more than one row in an INSERT statement. The INSERT statement in Listing 1.3 add five more rows to the product table. Listing 1.3: Adding five more rows to the product table INSERT INTO contact_info (contactID, firstname, lastname, phone) VALUES (100, ‘John’, ‘Smith’, ‘718-555-1234′) (200, ‘Jane’, ‘Doe’, ‘347-555-1234′), (300, ‘Fred’, ‘Brown’, ‘212-555-1234′), (400, ‘Donald’, ‘Duck’, ‘646-555-1234′); PLACE YOUR SCREEN SHOTS HERE: Screenshot 1 creating your database Screenshot 2 creating your table contact_info table Screenshot 3 adding data to the table – show results by command Select * From contact_info;

Writerbay.net

We offer the best essay writing services to students who value great quality at a fair price. Let us exceed your expectations if you need help with this or a different assignment. Get your paper completed by a writing expert today. Nice to meet you! Want 15% OFF your first order? Use Promo Code: FIRST15. Place your order in a few easy steps. It will take you less than 5 minutes. Click one of the buttons below.


Order a Similar Paper Order a Different Paper