목차
테이블 구성을 위한 sql 파일
보고서
보고서
본문내용
DROP TABLE BANK;
DROP TABLE BRANCH;
DROP TABLE EMPLOYEE;
DROP TABLE CLIENT;
DROP TABLE SAVE_ACCOUNT;
DROP TABLE LOAN_ACCOUNT;
CREATE TABLE BANK
( NAME VARCHAR(20),
CONSTRAINT BANKPK
PRIMARY KEY(NAME));
CREATE TABLE BRANCH
(CODE VARCHAR(20) NOT NULL,
NAME VARCHAR(20) NOT NULL,
ADDRESS VARCHAR(50) NOT NULL,
CONSTRAINT BRANCHPK
PRIMARY KEY(CODE));
CREATE TABLE CLIENT
( CLIENT_NAME VARCHAR(20),
CLIENT_NUMBER VARCHAR(20),
CLIENT_ID VARCHAR(20),
ADDRESS VARCHAR(50),
PHONE VARCHAR(20),
CONSTRAINT CLIENTPK
PRIMARY KEY(CLIENT_NUMBER));
해당자료는 한글2002나 워디안 자료로 한글97에서는 확인하실 수 없으십니다.
DROP TABLE BRANCH;
DROP TABLE EMPLOYEE;
DROP TABLE CLIENT;
DROP TABLE SAVE_ACCOUNT;
DROP TABLE LOAN_ACCOUNT;
CREATE TABLE BANK
( NAME VARCHAR(20),
CONSTRAINT BANKPK
PRIMARY KEY(NAME));
CREATE TABLE BRANCH
(CODE VARCHAR(20) NOT NULL,
NAME VARCHAR(20) NOT NULL,
ADDRESS VARCHAR(50) NOT NULL,
CONSTRAINT BRANCHPK
PRIMARY KEY(CODE));
CREATE TABLE CLIENT
( CLIENT_NAME VARCHAR(20),
CLIENT_NUMBER VARCHAR(20),
CLIENT_ID VARCHAR(20),
ADDRESS VARCHAR(50),
PHONE VARCHAR(20),
CONSTRAINT CLIENTPK
PRIMARY KEY(CLIENT_NUMBER));
해당자료는 한글2002나 워디안 자료로 한글97에서는 확인하실 수 없으십니다.