plz do finish on time!!! plz pick this one who can finish and read carefully

 

MGS 404 – Fall 2016Homework 2– Due 10/03 before 5:00pmTotal Points: 30For all the exercises below copy and paste your queries, and paste the screenshot of the resultyou obtained. Submit printed hard copies.Exercise 1: Creating database in MySQL (5 points)Create a new database. Give any name.“Use” this database.Exercise 2: Creating tables in MySQL (5 points)Use the CREATE TABLE command to create a table for the PARTS entity, with the attributes displayedin tables 1(see below). Make the “PART_NUM” attribute as a primary key. Make the “ON_HAND”attribute as NOT NULL.Use the DESC command to check whether you created the table properly.Exercise 3: Adding values to tables in MySQL (5 points)Use the INSERT INTO command to populate the table you created in exercise 2. Use the sample tablebelow (table 1) for the data values.Use the SELECT * command to display the table you created with the data values in them.Exercise 4: Single table queries (5*3 = 15 points)Using a MySQL query list the description of all the parts with price of $400 or less.Using a MySQL query list all the rows for the parts that were both of class ‘HW’ andavailable at the warehouse 3.Using a MySQL query list the description of the parts that were in the warehouses otherthan 3.HINT:You can use either one of these: <>, != or NOT

Attachments:

• 1495154878-Assignment 21.pdf