ERWIN Steps

------------------------------------------ ERWIN STEPS --------------------------------------
"______" SOLID LINE IS THE IDENTIFICATION OF IDENTIFYING RELATION.
"------" DOTTED LINE IS THE IDENTIFICATION OF UN-IDENTIFYING RELATION.
THE ENVIORNMENT OF ERwin IS LOGICAL(BY DEFAULT).
AT THE TIME OF CREATION OF TABLE IN ERwin DONOT INCLUDE THOSE COLUMNS
WHICH ARE REFRENCED FROM OTHER TABLES.THEY WILL BE AUTO GENERATED(FK).
PRESS ALT+N TO CREATE NEW FORM/ATTRIBUTE.

----------------------------FOR CREATING SELF-JOIN COLUMNS-------------
1- MUST BE IN LOGICAL MODE
2- SELECT THE RELATION AND DOUBLE CLICK IT. ITS ACTIVE THE RELATIONSHIP EDITOR.
3- CHOOSE ROLE NAME RI ACTION TAB.
4- DEFINE COLUMN NAME IN ROLE NAME FIELD, PRESS OK NOW FOREIGN KEY IS CREATED.



---------------------------FOR CREATING THE UNIQUE KEY COLUMN----------
1- MUST BE IN LOGICAL MODE.
2- SELECT THE TABLE AND DOUBLE CLICK ON IT CHOOSE THE KEY GROUP TAB.
3- PRESS KEY GROUP MEMBERSHIR BUTTON KEY GROUP ACTIVE.
4- NOW PRESS THE NEW BUTTON, NEW GROUP KEY EDITOR ACTIVE.
5- APPLY THE KEY GROUP NAME AND PRESS OK.
6- MOVE THE COLUMN NAME IN THE KEY GROUP MEMBERSHIP COLUMN PRESS OK TO COMPLETE THE TASK.


------------------------FOR APPLYING THE DEFAULT VALUES---------------
1- MUST BE IN PHYSICAL MODE.
2- PRESS DEFAULT BUTTON IN COLUMN EDITOR, DEFAULT EDITOR ACTIVE.
3- PRESS NEW BUTTON AND APPLY THE NAME AND PRESS OK.
4- APPLY THE DEFAULT VALUE/EXPRESSION IN SERVER VALUE TEXT FIELD.
5- AFTER APPLY PRESS OK TO END THE TASK AGAIN PRESS OK BUTTON TO COMPLETE THE TASK.


----------------------FOR APPLYING CHECK VALUES------------------------
1- MUST BE IN PHYSICAL MODE.
2- PRESS VALID BUTTON ON COLUMN EDITOR SCREEN.
3- PRESS NEW BUTTON ON VALID ROLE EDITOR SCREEN.
5- APPLY THE NAME AND PRESS OK KEY.
6- DEFINE VALUE ON ORACLE CHECK CONDITION FIELD THEN PRESS OK.
7- PRESS OK TO COMPLETE THE TASK.


-----------------------FOR CREATING FORWARD ENGINERRING----------------
AFTER DESIGN THE ENTITES AND RELATION FOLLOW THE FOLLOWING STEP
1- CHOOSE PHYSICAL MODE.
2- CLICK ON MENU OPTION TASK-->FORWARD ENGINERRING.
3- SELECT REQUIRED OPTION FROM 'ORACLE SCHEMA GENERATION' SECTION AS SHOWN IN THE HANDOUT NO# 7-14.

-------------------------------YOUR SELECTION-------------------------

SCHEMA ---> NONE
VIEW ---> NONE
TABLE ---> CREATE TABLE,DROP TABLE,TABLE CHECK
COLUMN ---> CHECK CONSTRAINT
PHYSICAL ORDER
DEFAULT VALUE
INDEX ---> NONE
REFRENTIAL INTEGRITY ---> PRIMARY KEY
CREATE/PK
FOREIGN KEY
CREATE/FK
ON DELETE(UNSELECT IT)
CREATE/UK
TRIGGER ---> NONE
OTHER OPTIONS ---> CONSTRAINT NAME