Dear Sir
First i have to know the schema of the tables in project 1 to write the SQL DDL statements to create them
I have experience 5 years in creating tables using SQL Statments and creating relations between them
I was a member of a team that created a healthcare systems using Oracle, so i know how to write SQL and PL/SQL statements
Here is a simple example of creating 2 tables and creating relations between them
Table 1
CREATE TABLE PROJECTS
(
PROJ_ID VARCHAR2(40 BYTE),
PROJ_NAME VARCHAR2(150 BYTE),
PROJ_START_DATE DATE,
PROJ_REV NUMBER(3)
);
ALTER TABLE PROJECTS ADD ( CONSTRAINT PROJ_PRIM_KEY PRIMARY KEY (PROJ_ID) );
ALTER TABLE PROJECTS ADD ( CONSTRAINT PROJ_NAM_UNQ UNIQUE (PROJ_NAME) );
Tabel 2
CREATE TABLE ITEMS
(
ITM_PROJ_ID VARCHAR2(50 BYTE),
ITEM_ID VARCHAR2(5 BYTE),
ITEM_TITLE VARCHAR2(150 BYTE),
ITEM_DESC LONG,
ITEM_REQ_TIME NUMBER(3),
ITEM_REV_REQ VARCHAR2(2 BYTE),
ITEM_NO_TYPE_INIT VARCHAR2(2 BYTE),
ITEM_NO_TYPE_FINAL VARCHAR2(6 BYTE),
ITEM_APROX_DOC VARCHAR2(4 BYTE),
ITEM_SUP_START NUMBER(3),
ITEM_SUP_COMPL NUMBER(3),
ITEM_COMPL NUMBER(1) DEFAULT 0
)
;
COMMENT ON COLUMN ITEMS.ITEM_COMPL IS '0 not completed - 1 completed';
ALTER TABLE ITEMS ADD ( CONSTRAINT ITMS_PRM_KEY PRIMARY KEY (ITEM_ID) );
ALTER TABLE ITEMS ADD ( CONSTRAINT ITMS_FRN_KEY FOREIGN KEY (ITM_PROJ_ID)
REFERENCES PROJECTS (PROJ_ID));