Create tables for the data descrbied with screen shots and proper sql querys.

a. A screen shot(s) of the SQL query you used to create the table with appropriate attributes and data types together with primary keys, foreign keys, relationships and constraints. b. A screen shot(s) of the DESCRIBE table_name; command to show the structure of the table. c. A screen shot(s) of all SQL queries you used to populate the table with valid data. Each table must contain a minimum of 3 records. d. A screen shot(s) of the SELECT * command to show the resulting table with all the valid data inserted.

Create database for this data, some data can be made up.

Entity 1: FLOWER TYPE

Attribute 1: PK FLOWER_TYPE_CODE

This will be a unique identifier giving a type of flower a code for reference to other tables.

Data Type: Text

Sample Values: (RS)for Roses, (IR) for irises, (DS) daises and (SF) sun flowers.

Attribute 2: FLOWER_TYPE_DESC

This is the name of each flower type in the database.

Data Value: TEXT

Sample Value: ROSES, IRISES, DAISES, SUN FLOWERS

Entity 2: PRODUCT

Attribute 1 PRODTUCT_ID PK

Unique identifiable numeric code for all Products in the flower shop and corresponds with other data.

DATA TYPE: Numeric

SAMPLE VALUE: 033,022,335,

Attribute 2 - PROD_PRICE

Price of each flower (product)

DATA TYPE: Numeric

SAMPLE VALUE: 2.99, 5.99,12.99, 5.00

Attribute 3 - PROD_NOH

Number of items on hand

DATA: Numeric

SAMPLE VALUE: 100, 2 ,7 ,5

Attribute 4: Color_CODE

This will be name of the color.

Data type: Numeric

Sample Values: 001, 003, 102

Attribute 5: PK FLOWER_TYPE_CODE FK

This will be a unique identifier giving a type of flower a code for reference to other tables.

Data Type: Text

Sample Values: (RS)for Roses, (IR) for irises, (DS) daises and (SF) sun flowers.

Entity 2: INVENTROY

Describing the number of flowers in our company inventory.

PROD_ID PK

Attribute 1 - FLOWER_TYPE_DESC

This is the name of each flower type in the database.

DATA TYPE: Text

SAMPLE VALUE: ROSES, DASISYS

Attribute 2 - PROD_PRICE

Price of each flower (product)

DATA TYPE: Numeric

SAMPLE VALUE: 2.99, 5.99,12.99, 5.00

Attribute 3 - PROD_NOH

Number of items on hand

DATA: Numeric

SAMPLE VALUE: 100, 2 ,7 ,5

Attribute 5 (FK) FLOWER_TYPE_CODE

This will be a unique identifier

Data Type: Text

Sample Values: (RS)for Roses, (IR) for irises, (DS) daises and (SF) sun flowers

Entity 3: PRICE

This will describe the price associated to every flower in our shop.

PROD_ID PK

Attribute 1: FLOWER_TYPE_DESC

This is the name of each flower type in the database.

Data Value: TEXT

Sample Value: ROSES IRISES DAISES SUN FLOWERS

Attribute 2: PK FLOWER_TYPE_CODE

This will be a unique identifier

Data Type: Text

Sample Values: (RS)for Roses, (IR) for irises, (DS) daises and (SF) sun flowers.

Entity 4: DESCRIPTION

This will describe the flower to help track our inventory and stay away from errors.

PROD_ID PK

Attribute 1: FK FLOWER_TYPE_CODE

This will be a unique identifier

Data Type: Text

Sample Values: (RS)for Roses, (IR) for irises, (DS) daises and (SF) sun flowers.

Attribute 2: PROD_NOH

Number of items on hand

DATA: Numeric

SAMPLE VALUE: 100, 2 ,7 ,5

Attribute 3: PROD_PRICE

Price of each flower (product)

DATA: Numeric

SAMPLE VALUE: 2.99, 5.99,12.99, 5.00

Entity 5: COLOR

This will describe the actual color of the flowers and corresponds with the description.

PROD_ID PK

Attribute 1: FLOWER_TYPE_DESC

This is the name of each flower type in the database.

Data Value: TEXT

Sample Value: ROSES IRISES DAISES SUN FLOWERS

Attribute 2: Color_CODE

This will be name of the color.

Data type: Numeric

Sample Values: 001, 003, 102