Pro_id Pro_na Pro/-S_Date Dura
P1 1XY 09/01/2005 3months
P2 2YZ 10/10/2005 4months
Supervisor Emp_ID Emp_na
Peter E5 Smith
John E6 Brown
above table using SQL statements for the follows.
1.creat table to check te project witch are start 2005.
2.change project name “1XY” in to “3jk”
3.list the project ending befor 09/05/2005
4.find te whose name starting from “B”
