학사관리 시스템 데이터베이스 쿼리

소개글

학사관리 시스템 데이터베이스 쿼리에 대한 보고서 자료입니다.

본문내용

create database db_hell;
use db_hell;
#학부 테이블 생성
create table dept
(
deptcode VARCHAR(10),
deptname VARCHAR(20),
depttel VARCHAR(15),
primary key(deptcode)
);
#교수 테이블 생성
create table professor
(
professorcode VARCHAR(10),
pname VARCHAR(20),
ssn VARCHAR(14),
majorcode VARCHAR(10),
pwd VARCHAR(10),
address VARCHAR(60),
lab VARCHAR(20),
salary INTEGER(10),
deptcode VARCHAR(10),
sex VARCHAR(2),
age INTEGER(3),
primary key(professorcode),
foreign key(deptcode) references dept(deptcode)
);
#학생 테이블 생성
create table stu
(
stunumber INTEGER(8) NOT NULL,
pname VARCHAR(20),
pwd VARCHAR(10),
address VARCHAR(60),
professorcode VARCHAR(10),
deptcode VARCHAR(10),
sex VARCHAR(2),
age INTEGER(3),
ssn VARCHAR(14),
primary key(stunumber),
foreign key(professorcode) references professor(professorcode),
foreign key(deptcode) references dept(deptcode)
);
# 과목 등록
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("SC1099", 2008, "임베디드H/W실험", "전필", 3 , 1, 2,1);
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("SC1023", 2008, "운영체제", "전필", 3 , 1, 3,3);
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("BA0028", 2008, "이산수학", "기필" , 2, 1, 3,3);
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("SC1094", 2008, "데이터베이스 및 설계", "전선", 3 , 1, 3,3);
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("SC1049", 2008, "마이크로프로세서", "전선", 3 , 1, 3,3);
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("SC1048", 2008, "전자시스템", "전선", 2 , 1, 3,3);
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("SC1047", 2008, "자바프로그래밍 응용", "전선", 3 , 1, 3,3);
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("SC1038", 2008, "멀티미디엉응용", "전선", 3 , 1, 3,3);
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("LA0257", 2008, "경영학원론", "교필" ,3, 1, 2,2);
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("SC1046", 2008, "웹시스템응용", "전선", 2 , 1, 3,3);
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("SC1045", 2008, "커널프로그래밍", "전선", 3 , 1, 3,3);
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("SC1050", 2008, "컴파일러", "전선", 4 , 1, 3,3);
INSERT INTO openingsubject(subjectcode,openingyear,subjectname,classification,academicyear,semaster,lecturetimenum,credit)
VALUES("SC1051", 2008, "데이터구조 및 알고리즘", "전필", 2 , 1, 3,3);

키워드

데이터베이스,   Mysql 쿼리,   학사관리 시스템