This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Create a table called Department with all necessary details Create a Table Employee with all necessary details it should also have a column called DeptNo and this column should refer to DeptNo column in department table ( Create a REFERENTIAL Integrity Constraint )
insert two rows with departmentNo 10 & 20 in department table insert a row with departmentNo 30 in emp table [ November 28, 2006: Message edited by: Srinivasa Raghavan ]