We can't get this table to work, here is the information for it.  we need week four done and are having difficulty doing it.  The script we have is attached for the test data and this:

Execute the following queries in the Diamond Broker database:

• Create an 1-page inventory list showing all the attributes for each diamond in inventory (both in stock and not in stock)
• Show the total price and costs for all in stock inventory items
• Show a 1-page list of all diamonds that are in stock and have a carat weight of over 1.0 carats
• Show a 1-page list of customer names and order numbers for those customers that have placed an order in the past twelve months
• Show a 1-page list of all orders with customer name and include all items that are on that order

 

Your team has been chosen to develop and design an inventory management system for Sparkle Diamonds, Inc. Sparkle Diamonds (SD) is headquartered in Phoenix, AZ, and is a large wholesale distributor of high quality diamonds to retailers throughout the United States. Diamond retailers purchase diamonds from SD based on the carat, clarity, cut, and color of the diamond and usually purchase multiple diamonds on the same order. The sales team at SD is looking for a database management system (DBMS) that will allow them to query their existing diamond inventory and prepare a sales order for their customers. Their customers are very specific with their purchasing needs and the DBMS must capture and maintain the data about Sparkle Diamonds' customers, inventory, and orders. 

Include the following requirements in the system:

• Customers - Each customer is assigned a unique customer number but may have multiple locations to ship to. The sales team needs to be able to select the customer and the location for preparing sales orders.
• Inventory Table - The sales team will want to query the inventory to find diamonds that meet the following specifications of their customers:Cost - what SD has paid for the stone
• Price - what SD will sell the stone for
• Carat - weight
• Clarity - clarity scale for diamonds offered are IF, VVS1, VVS2, VS1, VS2*
• Cut - cut scale for diamonds offered are Excellent, Very Good, Good
• Color - color scale for diamond offered are D, E, F, G, H, I, J*

Note: The data for diamonds that have been sold will remain in the inventory table but should be marked as "not in stock." For insurance purposes, SD will want to know the total value of their inventory (cost and price). 

• Order Table - The sales team will want to prepare a sales order for existing customers and make sure they are selling only diamonds that are in inventory. The DBMS must be designed such that customers can purchase multiple diamonds on one sales order.

Include the following specifications for your deliverables:

• Define the attributes for tables that will support Sparkle Diamonds' required functionality. Each table must include a primary key and at least five different attributes using appropriate data types.
• Using Visio^®, Lucidchart, or another software tool of your choice, build an Entity-Relationship Diagram (ERD) that models the table relationships for SD. The database must be normalized to 3rd Normal Form. Foreign keys must be set up with constraints and relationships established between entities.
• Using MySQL^â¢, build the tables defined in the ERD.
• Using scripts, populate each table with at least ten records. 
• The following five queries must be created to provide management insight into their inventory and sales:Create an inventory list showing all the attributes for each stone in inventory (both in stock and not in stock)
• Show the total price and costs for all in stock inventory items
• Show all diamonds that are in stock and have a carat weight of over 1.0 carats
• Show a list of customer names and order numbers for those customers that have placed an order in the past twelve months

 

Week Two Deliverables:

Start working on your Learning Team Database and Presentation outlined above with delivery in Week Four. Begin by analyzing the requirements provided. Identify the tables, fields, field attributes, and table relationships required.

Build a 1-page Entity Relationship Diagram (ERD) that models the required tables and relationships using Microsoft^® Visio^®, Lucidchart, or another software tool of your choice. The table design and relationships must support the following functionality:

• Customers - Each customer is assigned a unique customer number but may have multiple locations to ship to. The sales team needs to be able to select the customer and the location for preparing sales orders.
• Inventory Table - The sales team will want to query the inventory to find diamonds that meet the following specifications of their customers:Cost - what SD has paid for the stone
• Price - what SD will sell the stone for
• Carat - weight
• Clarity - clarity scale for diamonds offered are IF, VVS1, VVS2, VS1, VS2*
• Cut - cut scale for diamonds offered are Excellent, Very Good, Good
• Color - color scale for diamond offered are D, E, F, G, H, I, J*
• Order Table - The sales team will want to prepare a sales order for existing customers and sell only diamonds that are in inventory. The DBMS must be designed such that customers can purchase multiple stones on one sales order.

Write a 175- to 350-word Status Update for your Learning Team using Microsoft^® Word describing the work you have completed this week. The Status Update is a simple Microsoft^® Word document that lets the instructor know what the team has accomplished during the week.

 

Week Three Deliverables:

Normalize your tables designed in Week Two.

Using the MySQL^⢠Workbench, or through scripts, construct the tables in MySQL^⢠from the logical database design from your normalized ERD.

Populate each table with at least ten data records that would support the user's functional requirements.

Write a 175- to 350-word Status Update for your Learning Team using Microsoft^® Word describing the work you have completed this week. The Status Update is a simple Microsoft^® Word document that lets the instructor know what the team has accomplished during the week.

 

Week Four Deliverables:

Complete work on your Learning Team Database.

Execute the following queries in the Diamond Broker database:

• Create a 1-page inventory list showing all the attributes for each diamond in inventory (both in stock and not in stock)
• Show the total price and costs for all in stock inventory items
• Show a 1-page list of all diamonds that are in stock and have a carat weight of over 1.0 carats
• Show a 1-page list of customer names and order numbers for those customers that have placed an order in the past twelve months
• Show a 1-page list of all orders with customer name and include all items that are on that order

*Diamond Scale Reference (below)*

• Clarity:IF- Internally Flawless
• VVS1 - Very, very slightly included (pavilion)
• VVS2 - Very, very slightly included (crown)
• VS1 - Very slightly included (under 10X magnification)
• VS2 - Very slightly included (to the naked eye)
• Color:D, E, F - Colorless - color between D, E, and F diamonds can be detected only by a gemologist in side by side comparisons, and rarely by the untrained eye
• G, H, I, J, K - Near Colorless - diamonds color rated by a gemologist
  CREATE TABLE COUNTRY (
      country_id SMALLINT (10) NOT NULL,
      country VARCHAR (40) NOT NULL,
      last_update TIMESTAMP NOT NULL,
      PRIMARY KEY (country_id)
  );
  
  CREATE TABLE CITY (
      city_id SMALLINT(10) NOT NULL,
      city VARCHAR(40) NOT NULL,
      last_update TIMESTAMP NOT NULL,
      PRIMARY KEY (city_id),
      FOREIGN KEY (country_id)
          REFERENCEs COUNTRY (country_id)
  );
   
  CREATE TABLE ADDRESS (
      address_id SMALLINT NOT NULL,
      address VARCHAR(40) NOT NULL,
      address2 VARCHAR(40) NOT NULL,
      postal_code VARCHAR(10) NOT NULL,
      last_update TIMESTAMP NOT NULL,
      PRIMARY KEY (address_id),
      FOREIGN KEY (city_id)
          REFERENCES city (city_id)    
  );
  
  CREATE TABLE CUSTOMER (
      customer_id SMALLINT NOT NULL,
      first_name VARCHAR(45) NOT NULL,
      last_name VARCHAR(45) NOT NULL,
      email VARCHAR(50) NOT NULL,
      last_update TIMESTAMP NOT NULL,
      PRIMARY KEY (customer_id),
      FOREIGN KEY (Address_id)
          REFERENCES Address (Address_id)    
  );
  
  
  CREATE TABLE STORE (
      store_id SMALLINT NOT NULL,
      store_name VARCHAR(45) NOT NULL,
      last_update TIMESTAMP NOT NULL,
      PRIMARY KEY (store_id),
      FOREIGN KEY (Address_id)
          REFERENCES Address (Address_id)    
  );
  
  CREATE TABLE STAFF (
      staff_id SMALLINT NOT NULL,
      first_name VARCHAR(45) NOT NULL,
      last_name VARCHAR(45) NOT NULL,
      email VARCHAR(50) NOT NULL,
      last_update TIMESTAMP NOT NULL,
      PRIMARY KEY (staff_id),
      FOREIGN KEY (store_id)
          REFERENCES Store (Store_id),
      FOREIGN KEY (Address_id)
          REFERENCES Address (Address_id)    
  );
  CREATE TABLE PAYMENT (
      payment_id SMALLINT NOT NULL,
      amount DECIMAL NOT NULL,
      payment_date DATETIME NOT NULL,
      last_update TIMESTAMP NOT NULL,
      PRIMARY KEY (payment_id),
      FOREIGN KEY (customer_id)
          REFERENCES Customer (customer_id),
      FOREIGN KEY (Staff_id)
          REFERENCES Staff (Staff_id)    
  );
  CREATE TABLE CLARITY (
      clarity_id SMALLINT NOT NULL,
      Inter_Flaw VARCHAR(40) NOT NULL,
      VVS1 VARCHAR(40) NOT NULL,
      VVS2 VARCHAR(40) NOT NULL,
      VS1 VARCHAR(40) NOT NULL,
      VS2 VARCHAR(40) NOT NULL,
      last_update TIMESTAMP NOT NULL,
      PRIMARY KEY (clarity_id)
  );
  
  CREATE TABLE COLOR (
      color_id SMALLINT NOT NULL,
      D VARCHAR(40) NOT NULL,
      E VARCHAR(40) NOT NULL,
      F VARCHAR(40) NOT NULL,
      G VARCHAR(40) NOT NULL,
      H VARCHAR(40) NOT NULL,
      I VARCHAR(40) NOT NULL,
      J VARCHAR(40) NOT NULL,
      K VARCHAR(40) NOT NULL,
      last_update TIMESTAMP NOT NULL,
      PRIMARY KEY (color_id)
  );
  
  CREATE TABLE ORDERS (
      order_id SMALLINT NOT NULL,
      qty_sold INT NOT NULL,
      unit_price DECIMAL NOT NULL,
      last_update TIMESTAMP NOT NULL,
      PRIMARY KEY (order_id),
      FOREIGN KEY (Address_id, inventory_id)
  );
  
  CREATE TABLE INVENTORY (
      inventory_id SMALLINT NOT NULL,
      last_update TIMESTAMP NOT NULL,
      PRIMARY KEY (inventory_id),
      FOREIGN KEY (diamond_id)
          REFERENCES Diamonds (diamond_id)
  );   
        
  CREATE TABLE DIAMONDS (
      diamond_id SMALLINT NOT NULL,
      cost DECIMAL NOT NULL,
      price DECIMAL NOT NULL,
      carat SMALLINT NOT NULL,
      cut SMALLINT NOT NULL,
      last_update TIMESTAMP NOT NULL,
      PRIMARY KEY (diamond_id),
      FOREIGN KEY (color_id)
          REFERENCES Color (color_id),
      FOREIGN KEY (clarity_id)
          REFERENCES Clarity (clarity_id),
      FOREIGN KEY (inventory_id)
          REFERENCES Inventory (inventory_id)
  );
  
  -- Data Insertion Queries
  INSERT INTO CUSTOMER(customer_id, first_name, last_name, email, last_update)
  Values(1, 'Aaron', 'Gonzalez', 'gonzalez1@mail.edu', ('2017/04/18'));
  INSERT INTO CUSTOMER(customer_id, first_name, last_name, email, last_update)
  Values(2, 'Rick', 'Grimes', 'grimes1@mail.edu', ('2017/04/18'));
  INSERT INTO CUSTOMER(customer_id, first_name, last_name, email, last_update)
  Values(3, 'Robert', 'Ford', 'ford1@mail.edu', ('2017/04/18'));
  INSERT INTO CUSTOMER(customer_id, first_name, last_name, email, last_update)
  Values(4, 'Sarah', 'Mitchel', 'mitchel1@mail.edu', ('2017/04/18'));
  INSERT INTO CUSTOMER(customer_id, first_name, last_name, email, last_update)
  Values(5, 'Erica', 'Swayze', 'swayze1@mail.edu', ('2017/04/18'));
  INSERT INTO CUSTOMER(customer_id, first_name, last_name, email, last_update)
  Values(6, 'John', 'Denver', 'denver1@mail.edu', ('2017/04/18'));
  INSERT INTO CUSTOMER(customer_id, first_name, last_name, email, last_update)
  Values(7, 'Jill', 'May', 'may1@mail.edu', ('2017/04/18'));
  INSERT INTO CUSTOMER(customer_id, first_name, last_name, email, last_update)
  Values(8, 'Christopher', 'Barnett', 'barnett1@mail.edu', ('2017/04/18'));
  INSERT INTO CUSTOMER(customer_id, first_name, last_name, email, last_update)
  Values(9, 'Mike', 'Staggs', 'staggs1@mail.edu', ('2017/04/18'));
  INSERT INTO CUSTOMER(customer_id, first_name, last_name, email, last_update)
  Values(10, 'Tom', 'Brady', 'brady1goat@mail.edu', ('2017/04/18'));
  
  -- Data Insertion Queries
  INSERT INTO    ADDRESS(address_id, address, address2, postal_code, last_update)
  Values(1, '123 Smith Street', 'Suite 2', '90374', ('2017/04/17'));
  INSERT INTO    ADDRESS(address_id, address, address2, postal_code, last_update)
  Values(2, '838 Cross Street', '', '90274', ('2017/04/17'));
  INSERT INTO    ADDRESS(address_id, address, address2, postal_code, last_update)
  Values(3, '5405 Ave X', '', '00374', ('2017/04/17'));
  INSERT INTO    ADDRESS(address_id, address, address2, postal_code, last_update)
  Values(4, '5434 River Drive', '', '30374', ('2017/04/17'));
  INSERT INTO    ADDRESS(address_id, address, address2, postal_code, last_update)
  Values(5, '4732 Smith Street', 'Suite 5', '90374', ('2017/04/17'));
  INSERT INTO    ADDRESS(address_id, address, address2, postal_code, last_update)
  Values(6, '21 Pyle Drive', '', '44874', ('2017/04/17'));
  INSERT INTO    ADDRESS(address_id, address, address2, postal_code, last_update)
  Values(7, '867 Tutone Drive', '', '77374', ('2017/04/17'));
  INSERT INTO    ADDRESS(address_id, address, address2, postal_code, last_update)
  Values(8, '5309 Tom Street', '', '60374', ('2017/04/17'));
  INSERT INTO    ADDRESS(address_id, address, address2, postal_code, last_update)
  Values(9,'893 Tower Street', 'Suite 24', '40374', ('2017/04/17'));
  INSERT INTO    ADDRESS(address_id, address, address2, postal_code, last_update)
  Values(10, '4560 Mall Street', 'Suite 4', '11374', ('2017/04/17'));
  
  -- Data Insertion Queries
  INSERT INTO CITY(city_id, city, last_update)
  Values(1, 'Sacramento', ('2017/04/17'));
  INSERT INTO CITY(city_id, city, last_update)
  Values(2, 'Elk Grove',  ('2017/04/17'));
  INSERT INTO CITY(city_id, city,  last_update)
  Values(3, 'Lagunna',  ('2017/04/17'));
  INSERT INTO CITY(city_id, city,  last_update)
  Values(4, 'Meadowview Rd', ('2017/04/17'));
  INSERT INTO CITY(city_id, city,  last_update)
  Values(5, 'Crystal City',  ('2017/04/17'));
  INSERT INTO CITY(city_id, city,  last_update)
  Values(6, 'Stanley Rd', ('2017/04/17'));
  INSERT INTO CITY(city_id, city,  last_update)
  Values(7, 'Pentagon City', ('2017/04/17'));
  INSERT INTO CITY(city_id, city,  last_update)
  Values(8, 'Baltimore', ('2017/04/17'));
  INSERT INTO CITY(city_id, city,  last_update)
  Values(9, 'SpringField', ('2017/04/17'));
  INSERT INTO CITY(city_id, city,  last_update)
  Values(10, 'Florin Rd', ('2017/04/17'));
  
  -- Data Insertion Queries
  INSERT INTO COUNTRY(country_id, country, last_update)
  Values(1, 'Fiji Island', ('2017/04/17'));
  INSERT INTO COUNTRY(country_id, country, last_update)
  Values(2, 'New Zealand', ('2017/04/17'));
  INSERT INTO COUNTRY(country_id, country, last_update)
  Values(3, 'Australia', ('2017/04/17'));
  INSERT INTO COUNTRY(country_id, country, last_update)
  Values(4, 'Brazil', ('2017/04/17'));
  INSERT INTO COUNTRY(country_id, country, last_update)
  Values(5, 'South Africa', ('2017/04/17'));
  INSERT INTO COUNTRY(country_id, country, last_update)
  Values(6, 'Japan', ('2017/04/17'));
  INSERT INTO COUNTRY(country_id, country, last_update)
  Values(7, 'South Korea', ('2017/04/17'));
  INSERT INTO COUNTRY(country_id, country, last_update)
  Values(8, 'India', ('2017/04/17'));
  INSERT INTO COUNTRY(country_id, country, last_update)
  Values(9, 'China', ('2017/04/17'));
  INSERT INTO COUNTRY(country_id, country, last_update)
  Values(10, 'Samoa', ('2017/04/17'));
  
  -- Data Insertion Queries
  INSERT INTO STORE(store_id, store_name, last_update)
  Values(1, 'Crystal', ('2017/04/17'));
  INSERT INTO STORE(store_id, store_name, last_update)
  Values(2, 'Rogers', ('2017/04/17'));
  INSERT INTO STORE(store_id, store_name, last_update)
  Values(3, 'Jared', ('2017/04/17'));
  INSERT INTO STORE(store_id, store_name, last_update)
  Values(4, 'Miles', ('2017/04/17'));
  INSERT INTO STORE(store_id, store_name, last_update)
  Values(5, 'Millers', ('2017/04/17'));
  INSERT INTO STORE(store_id, store_name, last_update)
  Values(6, 'Johnsons', ('2017/04/17'));
  INSERT INTO STORE(store_id, store_name, last_update)
  Values(7, 'Thomasons', ('2017/04/17'));
  INSERT INTO STORE(store_id, store_name, last_update)
  Values(8, 'Melendezs', ('2017/04/17'));
  INSERT INTO STORE(store_id, store_name, last_update)
  Values(9, 'Morrisutu', ('2017/04/17'));
  INSERT INTO STORE(store_id, store_name, last_update)
  Values(10, 'Greens', ('2017/04/17'));
  
  -- Data Insertion Queries
  INSERT INTO STAFF(staff_id, first_name, last_name, email, last_update)
  Values(1, 'Brent', 'Mylett', 'brentmylett@yahoo.com', ('2017/04/17'));
  INSERT INTO STAFF(staff_id, first_name, last_name, email, last_update)
  Values(2, 'Niclas', 'Ferrel', 'niclasferrel@yahoo.com', ('2017/04/17'));
  INSERT INTO STAFF(staff_id, first_name, last_name, email, last_update)
  Values(3, 'Johnton', 'Bobka', 'johntonbobka@yahoo.com', ('2017/04/17'));
  INSERT INTO STAFF(staff_id, first_name, last_name, email, last_update)
  Values(4, 'Patrick', 'Zimmerman', 'patrickzimmerman@yahoo.com', ('2017/04/17'));
  INSERT INTO STAFF(staff_id, first_name, last_name, email, last_update)
  Values(5, 'Max', 'Ogles', 'maxogles@yahoo.com', ('2017/04/17'));
  INSERT INTO STAFF(staff_id, first_name, last_name, email, last_update)
  Values(6, 'Ronald', 'Prasad', 'ronaldprasad@yahoo.com', ('2017/04/17'));
  INSERT INTO STAFF(staff_id, first_name, last_name, email, last_update)
  Values(7, 'John', 'Bernard', 'johnbernard@yahoo.com', ('2017/04/17'));
  INSERT INTO STAFF(staff_id, first_name, last_name, email, last_update)
  Values(8, 'Pisa', 'Tamanalevu', 'pisatamanalevu@yahoo.com', ('2017/04/17'));
  INSERT INTO STAFF(staff_id, first_name, last_name, email, last_update)
  Values(9, 'Amber', 'Singh', 'ambersingh@yahoo.com', ('2017/04/17'));
  INSERT INTO STAFF(staff_id, first_name, last_name, email, last_update)
  Values(10, 'Arshana', 'Lynn', 'arshanalynn@yahoo.com', ('2017/04/17'));
  
  -- Data Insertion Queries
  INSERT INTO PAYMENT(payment_id, amount, payment_date, last_update)
  Values(1, '1000.00', ('2017/06/09'), ('2017/04/17'));
  INSERT INTO PAYMENT(payment_id, amount, payment_date, last_update)
  Values(2, '1060.00', ('2017/06/10'), ('2017/04/17'));
  INSERT INTO PAYMENT(payment_id, amount, payment_date, last_update)
  Values(3, '1050.00', ('2017/06/11'), ('2017/04/17'));
  INSERT INTO PAYMENT(payment_id, amount, payment_date, last_update)
  Values(4, '1200.00', ('2017/06/12'), ('2017/04/17'));
  INSERT INTO PAYMENT(payment_id, amount, payment_date, last_update)
  Values(5, '1600.00', ('2017/06/13'), ('2017/04/17'));
  INSERT INTO PAYMENT(payment_id, amount, payment_date, last_update)
  Values(6, '2300.00', ('2017/06/14'), ('2017/04/17'));
  INSERT INTO PAYMENT(payment_id, amount, payment_date, last_update)
  Values(7, '1230.00', ('2017/06/15'), ('2017/04/17'));
  INSERT INTO PAYMENT(payment_id, amount, payment_date, last_update)
  Values(8, '2400.00', ('2017/06/16'), ('2017/04/17'));
  INSERT INTO PAYMENT(payment_id, amount, payment_date, last_update)
  Values(9, '1325.00', ('2017/06/17'), ('2017/04/17'));
  INSERT INTO PAYMENT(payment_id, amount, payment_date, last_update)
  Values(10, '2150.00', ('2017/06/18'), ('2017/04/17'));
  
  -- Data Insertion Queries
  INSERT INTO ORDERS(order_id, qty_sold, unit_price, last_update)
  Values(1, '200', '40.00', ('2017/04/17'));
  INSERT INTO ORDERS(order_id, qty_sold, unit_price, last_update)
  Values(2, '50', '40.00', ('2017/04/17'));
  INSERT INTO ORDERS(order_id, qty_sold, unit_price, last_update)
  Values(3, '120', '40.00', ('2017/04/17'));
  INSERT INTO ORDERS(order_id, qty_sold, unit_price, last_update)
  Values(4, '230', '40.00', ('2017/04/17'));
  INSERT INTO ORDERS(order_id, qty_sold, unit_price, last_update)
  Values(5, '220', '40.00', ('2017/04/17'));
  INSERT INTO ORDERS(order_id, qty_sold, unit_price, last_update)
  Values(6, '245', '40.00', ('2017/04/17'));
  INSERT INTO ORDERS(order_id, qty_sold, unit_price, last_update)
  Values(7, '272', '40.00', ('2017/04/17'));
  INSERT INTO ORDERS(order_id, qty_sold, unit_price, last_update)
  Values(8, '212', '40.00', ('2017/04/17'));
  INSERT INTO ORDERS(order_id, qty_sold, unit_price, last_update)
  Values(9, '223', '40.00', ('2017/04/17'));
  INSERT INTO ORDERS(order_id, qty_sold, unit_price, last_update)
  Values(10, '243', '40.00', ('2017/04/17'));
  INSERT INTO ORDERS(order_id, qty_sold, unit_price, last_update)
  Values(1, '231', '40.00', ('2017/04/17'));
  
  -- Data Insertion Queries
  INSERT INTO INVENTORY( inventory_id, last_update)
  Values(1, ('2017/04/17'));
  INSERT INTO INVENTORY( inventory_id, last_update)
  Values(2, ('2017/04/17'));
  INSERT INTO INVENTORY( inventory_id, last_update)
  Values(3, ('2017/04/17'));
  INSERT INTO INVENTORY( inventory_id, last_update)
  Values(4, ('2017/04/17'));
  INSERT INTO INVENTORY( inventory_id, last_update)
  Values(5, ('2017/04/17'));
  INSERT INTO INVENTORY( inventory_id, last_update)
  Values(6, ('2017/04/17'));
  INSERT INTO INVENTORY( inventory_id, last_update)
  Values(7, ('2017/04/17'));
  INSERT INTO INVENTORY( inventory_id, last_update)
  Values(8, ('2017/04/17'));
  INSERT INTO INVENTORY( inventory_id, last_update)
  Values(9, ('2017/04/17'));
  INSERT INTO INVENTORY( inventory_id, last_update)
  Values(10, ('2017/04/17'));
  
  -- Data Insertion Queries
  INSERT INTO DIAMONDS( diamonds_id, cost, price, carat, cut, last_update)
  Values(1, '5000.00', '50.00', 1, 'round', ('2017/04/17'));
  INSERT INTO DIAMONDS( diamonds_id, cost, price, carat, cut, last_update)
  Values(2, '2000.00', '50.00', .25, 'heart', ('2017/04/17'));
  INSERT INTO DIAMONDS( diamonds_id, cost, price, carat, cut, last_update)
  Values(3, '2300.00', '50.00', .125, 'oval', ('2017/04/17'));
  INSERT INTO DIAMONDS( diamonds_id, cost, price, carat, cut, last_update)
  Values(4, '3000.00', '50.00', .333, 'pear', ('2017/04/17'));
  INSERT INTO DIAMONDS( diamonds_id, cost, price, carat, cut, last_update)
  Values(5, '4100.00', '50.00', .4, 'radiant', ('2017/04/17'));
  INSERT INTO DIAMONDS( diamonds_id, cost, price, carat, cut, last_update)
  Values(6, '4500.00', '50.00', .5, 'asscher', ('2017/04/17'));
  INSERT INTO DIAMONDS( diamonds_id, cost, price, carat, cut, last_update)
  Values(7, '5500.00', '50.00', 1.25, 'cushion', ('2017/04/17'));
  INSERT INTO DIAMONDS( diamonds_id, cost, price, carat, cut, last_update)
  Values(8, '5600.00', '50.00', 1.5, 'princess', ('2017/04/17'));
  INSERT INTO DIAMONDS( diamonds_id, cost, price, carat, cut, last_update)
  Values(9, '6000.00', '50.00', 2, 'emerald', ('2017/04/17'));
  INSERT INTO DIAMONDS( diamonds_id, cost, price, carat, cut, last_update)
  Values(10, '7000.00', '50.00', 2.5, 'marquise', ('2017/04/17'));
  
  -- Data Insertion Queries
  INSERT INTO CLARITY( clarity_id, inter_flaw, vvs1, vvs2, vs1, vs2, last_update)
  Values(1, 'interally flawless', 'very', 'very slightly included', 'very slightly included', 'very slightly included', ('2017/04/17'));
  INSERT INTO CLARITY( clarity_id, inter_flaw, vvs1, vvs2, vs1, vs2, last_update)
  Values(2, 'interally flawless', 'very', 'very slightly included', 'very slightly included', 'very slightly included', ('2017/04/17'));
  INSERT INTO CLARITY( clarity_id, inter_flaw, vvs1, vvs2, vs1, vs2, last_update)
  Values(3, 'interally flawless', 'very', 'very slightly included', 'very slightly included', 'very slightly included', ('2017/04/17'));
  INSERT INTO CLARITY( clarity_id, inter_flaw, vvs1, vvs2, vs1, vs2, last_update)
  Values(4, 'interally flawless', 'very', 'very slightly included', 'very slightly included', 'very slightly included', ('2017/04/17'));
  INSERT INTO CLARITY( clarity_id, inter_flaw, vvs1, vvs2, vs1, vs2, last_update)
  Values(5, 'interally flawless', 'very', 'very slightly included', 'very slightly included', 'very slightly included', ('2017/04/17'));
  INSERT INTO CLARITY( clarity_id, inter_flaw, vvs1, vvs2, vs1, vs2, last_update)
  Values(6, 'interally flawless', 'very', 'very slightly included', 'very slightly included', 'very slightly included', ('2017/04/17'));
  INSERT INTO CLARITY( clarity_id, inter_flaw, vvs1, vvs2, vs1, vs2, last_update)
  Values(7, 'interally flawless', 'very', 'very slightly included', 'very slightly included', 'very slightly included', ('2017/04/17'));
  INSERT INTO CLARITY( clarity_id, inter_flaw, vvs1, vvs2, vs1, vs2, last_update)
  Values(8, 'interally flawless', 'very', 'very slightly included', 'very slightly included', 'very slightly included', ('2017/04/17'));
  INSERT INTO CLARITY( clarity_id, inter_flaw, vvs1, vvs2, vs1, vs2, last_update)
  Values(9, 'interally flawless', 'very', 'very slightly included', 'very slightly included', 'very slightly included', ('2017/04/17'));
  INSERT INTO CLARITY( clarity_id, inter_flaw, vvs1, vvs2, vs1, vs2, last_update)
  Values(10, 'interally flawless', 'very', 'very slightly included', 'very slightly included', 'very slightly included', ('2017/04/17'));
  
  -- Data Insertion Queries
  INSERT INTO COLOR( color_id, d, e, f, g, h, i, j, k, last_update)
  Values(1, 'colorless', 'colorless', 'colorless', 'near colorless', 'near colorless', 'near colorless', 'near colorless', 'faint yellow tint', ('2017/04/17'));
  INSERT INTO COLOR( color_id, d, e, f, g, h, i, j, k, last_update)
  Values(2, 'colorless', 'colorless', 'colorless', 'near colorless', 'near colorless', 'near colorless', 'near colorless', 'faint yellow tint', ('2017/04/17'));
  INSERT INTO COLOR( color_id, d, e, f, g, h, i, j, k, last_update)
  Values(3, 'colorless', 'colorless', 'colorless', 'near colorless', 'near colorless', 'near colorless', 'near colorless', 'faint yellow tint', ('2017/04/17'));
  INSERT INTO COLOR( color_id, d, e, f, g, h, i, j, k, last_update)
  Values(4, 'colorless', 'colorless', 'colorless', 'near colorless', 'near colorless', 'near colorless', 'near colorless', 'faint yellow tint', ('2017/04/17'));
  INSERT INTO COLOR( color_id, d, e, f, g, h, i, j, k, last_update)
  Values(5, 'colorless', 'colorless', 'colorless', 'near colorless', 'near colorless', 'near colorless', 'near colorless', 'faint yellow tint', ('2017/04/17'));
  INSERT INTO COLOR( color_id, d, e, f, g, h, i, j, k, last_update)
  Values(6, 'colorless', 'colorless', 'colorless', 'near colorless', 'near colorless', 'near colorless', 'near colorless', 'faint yellow tint', ('2017/04/17'));
  INSERT INTO COLOR( color_id, d, e, f, g, h, i, j, k, last_update)
  Values(7, 'colorless', 'colorless', 'colorless', 'near colorless', 'near colorless', 'near colorless', 'near colorless', 'faint yellow tint', ('2017/04/17'));
  INSERT INTO COLOR( color_id, d, e, f, g, h, i, j, k, last_update)
  Values(8, 'colorless', 'colorless', 'colorless', 'near colorless', 'near colorless', 'near colorless', 'near colorless', 'faint yellow tint', ('2017/04/17'));
  INSERT INTO COLOR( color_id, d, e, f, g, h, i, j, k, last_update)
  Values(9, 'colorless', 'colorless', 'colorless', 'near colorless', 'near colorless', 'near colorless', 'near colorless', 'faint yellow tint', ('2017/04/17'));
  INSERT INTO COLOR( color_id, d, e, f, g, h, i, j, k, last_update)
  Values(10, 'colorless', 'colorless', 'colorless', 'near colorless', 'near colorless', 'near colorless', 'near colorless', 'faint yellow tint', ('2017/04/17'));
  
  select * from diamonds where carat > 1.0;