计算机学院 《数据库系统概论》课程设计报告
六 数据库建立
（1） 创建数据库 USE master Go
CREATE DATABASE manage ON
(NAME=manage,
FILENAME=’d:\\manage.mdf, SIZE=10, MAXSIZE=50, FILEGROWTH=5) LOG ON
(NAME=’management’,
FILENAME=’e:\\manage.ldf’, SIZE=5MB, MAXSIZE=25MB, FILEGROWTH=5MB) (2) 用户表建立 Create table Users (
Uidnumber varchar2 (18) primary key, Urealname varchar2 (15) ,
20 1
计算机学院 《数据库系统概论》课程设计报告
Ucode varchar2 (12) not null, Uuseraccount varchar2 (15) not null, Utelephone varchar2 (11), Uaddress varchar2 (25), Usex varchar2(2) , Ubirthoftime date );
联系人表建立
Create table Personcontact (
Prealname varchar2 (15) primary key, Psex varchar2(2) , Ptelephone varchar2 (11), Pfax varchar2 (20), Pbirthoftime date,
Paddress varchar2 (25) not null, Pqq number,
Pemail varchar2 (20),
Cclassname varchar2 (15) not null, Uidnumber varchar2(18) not null,
Foreign key (Cclassname) references 21 1
Contactclass (3) (Cclassname),
计算机学院 《数据库系统概论》课程设计报告
Foreign key (uidnumber) references users (uidnumber) )
(4) 银行表建立 Create table Bank
(
Bdepartmentnumber varchar2 (15) primary key, Bdepartmentname varchar2 (20) not null, Baddress varchar2 (20), Brate number,
Fnumber varchar2 (15) not null,
Foreign key (fnumber) references finance (fnumber), )
(5) 文章管理表建立
Create table Articlemanagement (
Ainformationname varchar2 (15), Ainformationtype varchar2 (15), Aarticlename varchar2 (15) not null, Abuildtime date not null,
Ainformationnumber varchar2 (10) primary key, Uidnumber varchar2 (18) not null,
Foreign key (uidnumber) references users (uidnumber),
22 1
计算机学院 《数据库系统概论》课程设计报告
)
(6) 财务表建立 Create table Finance (
Fnumber varchar2 (10) primary key, Foutput number, Finput number, Fbalance number,
Uidnumber varchar2 (18) not null,
Foreign key (uidnumber) references users (uidnumber),
)
(7) 联系人类别表建立 Create table Contactclass (
Cclassname varchar2 (15) primary key
)
(8) 信息类别表建立
Create table Informationclass (
Iclassname varchar2 (15) primary key
)
23 1
