데이터베이스 인터넷 서점 구축 프로젝트

소개글

"데이터베이스 인터넷 서점 구축 프로젝트"에 대한 내용입니다.

목차

없음

본문내용

create table sitemember
(ID varchar(45),
name varchar(40),
address varchar(45),
phone varchar(45),
tot_point numeric(4,0) check(tot_point>=0),
primary key (ID)
);
create table book
(ISBN varchar(10),
booktitle varchar(45),
page numeric(4,0) check(page>0),
p_date varchar(20),
name varchar(45) not null,
s_title varchar(45) not null,
tot_c numeric(3,2) check(tot_c>=0 and tot_c<=5),
primary key (ISBN),
foreign key(name) references company
on delete cascade,
foreign key(s_title) references subject
on delete null
);
create table subject
(s_title varchar(45),
primary key (s_title)
);
create table relate
(
s_title varchar(45),
r_title varchar(45),
primary key(s_title,r_title),
foreign key(s_title) references subject,
foreign key(r_title) references subject
)
create table author
(
ISBN varchar(10),
a_ID varchar(10),
primary key(ISBN,a_ID),
foreign key(ISBN) references book
on delete cascade,
foreign key(a_ID) references writer
on delete cascade
);

참고 자료

없음