SQL 쿼리 작성 과제

소개글

고객 테이블을 중심으로 문제를 푸는 형식의 SQL작성 과제

목차

테이블
Table Creation
ER Diagram
데이터베이스과제

본문내용

테이블
employee(employee_name, street, city, manager_name)
works(employee_name, company_name, salary)
company(company_name, city)

Table Creation
create table employee
        (employee_name       char(10),
         street                   char(20),
         city                    char(10),
         manager_name          char(10),
        primary key(employee_name),
        foreign key(manager_name) references employee)
create table company
        (company_name        char(30),
         city                    char(10),
        primary key(company_name))
create table works
        (employee_name       char(10),
         company_name        char(30),
         salary                  number(8),
        primary key(employee_name, company_name),
        foreign key(employee_name) references employee,
        foreign key(company_name) references company)

참고 자료

없음

압축파일 내 파일목록

a.bmp
b.bmp
c.bmp
d.bmp
DB_Table_내용.hwp
e.bmp
ex.bmp
ex2.bmp
f.bmp
g.bmp
i.bmp
j.bmp
k.bmp
l.bmp
sq.txt
SQL.txt
SQL_Report_2_첨부자료.ppt
Thumbs.db
데이터베이스과제2.hwp
데이터베이스과제2제출용.hwp

전체 목록 보기