No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
1)CREATETABLEProject( ProjectNovarchar2(5)notnull,ProjectNamevarchar2(20), StartDatedate, FinishDatedate,PRIMARYKEY(ProjectNo)); 2)CREATETABLEAssignment( StaffNonumber(3)notnull, ProgramNovarchar2(4)notnull,PRIMARYKEY(StaffNo,ProgramNo), FOREIGNKEY(StaffNo)REFERENCESStaff(StaffNo), FOREIGNKEY(ProgramNo)REFERENCESProgram(ProgramNo)); 3)CREATETABLEStaff( StaffNonumber(3)notnull, StaffNamevarchar2(10), SalGradenumber(2)CHECK(SalGradebetween1and12), YearsExpnumber(2), ProjectNovarchar2(5),PRIMARYKEY(StaffNo), FOREIGNKEY(ProjectNo)REFERENCESProject(ProjectNo)); 4)CREATETABLEProgram( ProgramNovarchar2(4)notnull, Titlevarchar2(20), Languagevarchar2(20),PRIMARYKEY(ProgramNo), CHECK(Languagein('VB','JAVA','ORACLE','C','XML'))); for the code above, what type of integrity constraints will be on them? (how many do u think?) also; i've created this code (below) but there seems to be … |
|
basically this is the first time iam using the iSQL *Plus, i am confused and i just want to no, when you create a table how can you view the actual table you have created, and how do you put data into the table?.. |