Draw the schema using SQL Developer after you have created it so you can visualize what you have created. From the drawing indicate the type of schema that you have drawn. 

All tables except TRANSACTIONS are to have primary keys.  That will be 5 primary key definitions and 5 foreign key definitions.  All constraints are to be properly named with user named constraints; I do not want to see any SYS_C constraint names. 

Submission:

1. The SQL statements for all 6 tables, include the response SQL developer provides when it is created.
2. The constraints for each table.  This can be done at the time you created the table, or after the tables is created.  I need to see the SQL for each constraint, make sure you use user defined names as stated above.
3. The diagram of your schema.
4. Identify the type of schema you have created.

ENJOY !!!!!

 

COLUMN NAME	DATA TYPE and SIZE
STOCK_ID	NUMBER(4)
STOCK_SYMBOL	VARCHAR2(8)
STOCK_DESCRIPTION	VARCHAR2(30)
INDUSTRY_ID	NUMBER(4)

 

COLUMN NAME	DATA TYPE and SIZE
TIME_ID	DATE
DAY	VARCHAR2(9)
MONTH	VARCHAR2(10)
QUARTER	NUMBER(1)
YEAR	NUMBER(4)
SEASON	VARCHAR2(10)

 

 

COLUMN NAME	DATA TYPE and SIZE
BROKERAGE_ID	NUMBER(4)
OFFICE_NAME	VARCHAR2(25)
CITY_ID	NUMBER(4)

 

 

COLUMN NAME	DATA TYPE and SIZE
STOCK_ID	NUMBER(4)
TIME_ID	DATE
BROKERAGE_ID	NUMBER(4)
BUY_SELL_INDICATOR	VARCHAR2(1)
NUMBER_OF_SHARES	NUMBER(6)
PRICE	NUMBER(6,2)

 

 

COLUMN NAME	DATA TYPE and SIZE
CITY_ID	NUMBER(4)
CITY	VARCHAR2(10)
STATE_PROVINCE	VARCHAR2(10)
REGION	VARCHAR2(15)
POSTAL_CODE	VARCHAR2(6)

 

You need to create a table called INDUSTRIES based on the following definition.

COLUMN NAME	DATA TYPE and SIZE
INDUSTRY_ID	NUMBER(4)
INDUSTRY	VARCHAR2(20)
NATION	VARCHAR2(10)