데이터베이스 예제
Create table professor ( pID char(5) primary key, name varchar(20) not null, deptName varchar(20), salarynumeric(10,2) /* 외래키는 미리 선언이 안된다 (Oracle) , foreign key (deptName) references department */ ); Create table department ( deptNamevarchar(20) primary key, chairmanchar(5), buildingvarchar(30), budgetnumeric(10,0), foreign key (chairman) references professor); Create table student ( sID char(5)..
2023. 10. 10.