数据库实验二（ 数据查询 ）

3.1 项目信息管理数据库 DDL(Oracle SQL)
alter table Department
drop constraint FK_DEPARTME_管理_TEACHER;
alter table MyProject
drop constraint FK_MYPROJEC_PP_MYPROJEC;
alter table MyProject
drop constraint FK_MYPROJEC_PROJECTMA_TEACHER;
alter table TM
drop constraint FK_TM_TM_TEACHER;
alter table TM
drop constraint FK_TM_TM2_MYPROJEC;
alter table Teacher
drop constraint FK_TEACHER_BELONGTO_DEPARTME;
drop index 管理_FK;
drop table Department cascade constraints;
drop index PP_FK;
drop index ProjectManager_FK;
drop table MyProject cascade constraints;
drop index TM2_FK;
drop index TM_FK;
drop table TM cascade constraints;
drop index BelongTo_FK;
drop table Teacher cascade constraints;
/*==============================================================*/
/* Table: Department */
/*==============================================================*/
create table Department
(
DNO VARCHAR2(10) not null,
TNO VARCHAR2(10),
DName NVARCHAR2(20) not null,
constraint PK_DEPARTMENT primary key (DNO)
);
/*==============================================================*/
/* Index: 管理_FK */
/*==============================================================*/
create index 管理_FK on Department (
TNO ASC
);
/*==============================================================*/
/* Table: MyProject */
/*==============================================================*/
create table MyProject
(
PNO VARCHAR2(10) not null,
ParentPNO VARCHAR2(10),
TNO VARCHAR2(10) not null,
PName NVARCHAR2(30) not null,
PFund NUMBER(20,2),
PBeginDate DATE not null,
PTimeSpan INTEGER not null,
constraint PK_MYPROJECT primary key (PNO)
);
/*==============================================================