Dear experts,

Help in creating tables based on erd diagram using sqlplus following sample

Paste in your sql commands

(Oracle 11g)

Thank you

789 CONSULTANT SKILL I IC_ID 789 SKILL_ID CERTIFICATION A A 189 CONSULTANT CID IC LAST C FIRST Oc_mi OC ADD Oc CITY IC STATE OC_ZIP OC_PHONE OC EMAIL A A A A A A A A A A SKILL SKILL_ID SKILL_DESCRIPTION A 789 789 PROJECT SKILL OP_ID SKILL_ID 789 789 789 5 PROJECT CONSULTANT T PID C_ID ROLL_ON_DATE ROLL_OFF_DATE ELAPSED_TIME 789 789 EVALUATION LEID E_DATE P_ID EVALUATOR_ID EVALUATEE_ID SCORE COMMENTS 789 789 789 789 A A PROJECT DP_ID PROJECT_NAME CLIENT_ID MGRID PARENT_P_ID C 789 789 789 789 CLIENT T 1 CLIENT_ID CLIENT NAME A CONTACT_LAST A A CONTACT_FIRST A A CONTACT_PHONE A Figure 1-19 Visual representation of the Software Experts database CONSULTANT C_ID C_LAST C_FIRST Number String String 100 Myers Mark 101 Hernandez Sheila 102 Zhang Brian 103 Carison Sarah 104 Courtlandt Paul 105 Park Janet CMI String F R C ADD C CITY C STATE String String String 1383 Alexander Ave. Eau Claire WI 3227 Brian Street Eau Claire WI 2227 Calumet Place Altoona WI 1334 Water Street Eau Claire WI 1911 Pine Drive Eau Claire WI 2333 157th St Chippewa Falls Wi C ZIP String 54703 54702 54720 54703 54701 54712 C_PHONE String 7155559652 7155550282 7155558383 7155558008 7155555225 7155554944 C EMAIL String mmyers@swexpert.com shernandez@earthware.con zhang@swexpert.com carlsons@swexpert.com courtipr@yamail.com park@swexpert.com R S SKILL SKILL_ID Number 1 2 3 4 5 6 7 SKILL_DESCRIPTION String VB .NET Programming COBOL Programming Java Programming Project Management Web Applications Programming Oracle Developer Programming Oracle Database Administration Windows NT/2000 Network Administration Windows XP Network Administration 9 101 CONSULTANT_SKILL CID SKILL_ID CERTIFICATION Number Number String 100 1 Y 100 3 N 100 6 Y 101 4 N 5 N 102 7 Y 103 1 Y 103 6 Y 8 Y 103 9 Y 8 N 104 9 Y 105 2 N 105 3 N 105 4 Y 103 104 CLIENT CLIENT ID Number 1 2 3 4 5 6 CLIENT_NAME CONTACT_LAST String String Crisco Systems Martin Supreme Data Corporation Martinez Lucid Technologies Brown Morningstar Bank Wright Maverick Petroleum Miller Birchwood Mall Brenner CONTACT_FIRST String Andrew Michelle Jack Linda Tom Nicole CONTACT PHONE String 5215557220 5205559821 7155552311 9215553320 4085559822 7155550828 CLIENT_ID Number 2 MGR_ID Number 105 PARENT_P_ID Number 103 1 PROJECT P_ID PROJECT_NAME Number String 1 Hardware Support Intranet 2. Hardware Support Interface 3 Hardware Support Database 4 Teller Support System 5 Internet Advertising 6 Network Design 7 Exploration Database 0 ANN lo | 102 105 105 104 5 102 PROJECT_SKILL P_ID SKILL_ID Number Number 1 8 8 1 Om 2 6 4 valul Aww 5 NNNN 7 PROJECT_CONSULTANT P_ID C_ID ROLL_ON_DATE Number Number Date 1 101 06/15/2006 1 104 01/05/2006 1 103 01/05/2006 1 105 01/05/2006 2 105 07/17/2006 2 100 07/17/2006 3 103 09/15/2006 3 104 10/15/2006 4 105 06/05/2006 4 104 06/15/2006 4 102 07/15/2006 5 105 09/19/2006 5 103 09/19/2006 6 103 09/19/2006 6 104 09/19/2006 7 102 05/20/2006 7 100 05/25/2006 ROLL_OFF_DATE Date 12/15/2006 12/15/2006 06/05/2006 12/15/2006 09/17/2006 09/17/2006 03/15/2007 12/15/2006 06/05/2007 12/15/2006 12/15/2006 03/19/2007 03/19/2007 03/19/2007 03/19/2007 12/20/2006 12/20/2006 ELAPSED_TIME Interval 92 DAYS 126 DAYS 5 DAYS 45 DAYS 25 DAYS O DAYS 125 DAYS 50 DAYS 25 DAYS 53 DAYS 30 DAYS 15 DAYS 15 DAYS 5 DAYS 10 DAYS 55 DAYS 100 DAYS P_ID Number EVALUATEE_ID Number 101 COMMENTS String EVALUATION E_ID E DATE Number Date 100 01/07/2007 101 01/07/2007 102 01/08/2007 103 12/20/2006 104 12/29/2006 105 01/15/2007 1 EVALUATOR_ID Number 105 105 105 103 SCORE Number 90 85 1 104 1 90 103 105 1 100 104 1 1 104 105 75 90 101