Question: 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
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:
- The SQL statements for all 6 tables, include the response SQL developer provides when it is created.
- 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.
- The diagram of your schema.
- 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) |
Step by Step Solution
★★★★★
3.43 Rating (166 Votes )
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help