장바구니 담기 close

장바구니에 상품을 담았습니다.

장바구니로 계속쇼핑하기
데이터베이스와 데이터모델링 실제
미리보기

데이터베이스와 데이터모델링 실제

  • 임종태
  • |
  • 공주대학교출판부
  • |
  • 2017-02-28 출간
  • |
  • 388페이지
  • |
  • 190 X 260 mm
  • |
  • ISBN 9791186737118
판매가

22,000원

즉시할인가

19,800 원

배송비

2,300원

(제주/도서산간 배송 추가비용:3,000원)

추가상품
상품선택
독서대 7,900원 독서대 선택안함 0원
수량
+ -
총주문금액
19,800원

이 상품은 품절된 상품입니다

※ 스프링제본 상품은 반품/교환/환불이 불가능하므로 신중하게 선택하여 주시기 바랍니다.

북스크린영상으로 만나보는 한 권의 책 이야기

목차


제1부 데이터베이스 시스템
제1장 데이터베이스 시스템의 개념 ································································· 11
1.1 정보 시스템의 개념 ························································································· 11
1.2 파일 처리 시스템 ····························································································· 12
1.3 데이터베이스 정의 ··························································································· 14
1.4 데이터베이스 시스템의 구조 ··········································································· 20
1.5 데이터베이스 언어와 사용자 ··········································································· 22
제2장 데이터베이스 설계 개념 ········································································ 29
2.1 데이터베이스 설계의 개요 ·············································································· 29
2.2 개체 관계 모델 ································································································ 32
2.3 개체 관계도 ······································································································ 46
2.4 새발 표기법 ······································································································ 49
2.5 관계형 데이터 모델과 기본 개념 ··································································· 53
제3장 관계 데이터베이스 설계 ········································································ 63
3.1 무결성 제약조건 ······························································································· 63
3.2 개체관계도를 관계형 모델로 변환 ································································· 71
3.3 데이터베이스 설계 사례 ·················································································· 76
제4장 정규화 ······································································································ 89
4.1 함수적 종속성 개념 ························································································· 89
4.2 함수적 종속에서 슈퍼 키 찾기 ······································································· 92
4.3 BCNF ················································································································ 98
4.4 3NF ················································································································· 103
4.5 2NF와 잘못 설계된 데이터베이스의 문제점 ················································ 107
제5장 관계 데이터베이스 언어 ······································································ 115
5.1 관계 대수와 관계 연산자 ·············································································· 115
5.2 SQL 언어 ········································································································ 129
5.3 뷰 ···················································································································· 142
5.4 QBE(Query By Example) ············································································· 149
5.5 SQL Server의 설치 및 사용 ·········································································· 156
제6장 트랜잭션의 개념과 고장 회복 ····························································· 179
6.1 트랜잭션 개념 ································································································ 179
6.2 트랜잭션 상태 ································································································ 182
6.3 트랜잭션의 데이터 연산 ················································································ 183
6.4 로그 레코드 ···································································································· 186
6.5 그림자 페이지 대체 기법 ·············································································· 191
제7장 동시성 제어 ·························································································· 195
7.1 동시 수행의 문제점 ······················································································· 195
7.2 동시성 제어 ···································································································· 198
7.3 로킹 기법 ······································································································· 202
7.4 두 단계 로킹 규약 ························································································· 204
7.5 교착상태 ········································································································· 207
7.6 기타 동시성 제어 방법 ················································································· 208
제8장 무결성과 데이터베이스 보안 ······························································· 213
8.1 무결성 규정 ···································································································· 213
8.2 데이터베이스 보안 ························································································· 220
제2부 데이터베이스 설계의 실제
제9장 개념적 모델링 ······················································································· 231
9.1 요구사항 분석서 작성 ··················································································· 231
9.2 개념적 데이터 모델링 ··················································································· 245
제10장 개념적 데이터 모델링 예제 ······························································· 257
10.1 2007년 DA 공모대전 문제 ·········································································· 257
10.2 2012년 DA 공모대전 문제 ·········································································· 264
10.3 2013년 DA 공모대전 문제 ·········································································· 276
10.4 2014년 DA 공모대전 문제 ·········································································· 290
제11장 색인 기법 ···························································································· 299
11.1 인덱스의 원리 ······························································································ 299
11.2 인덱스 생성과 삭제 ····················································································· 300
11.3 B 트리 ·········································································································· 302
11.4 ? ? 트리 ······································································································· 306
11.5 확장성 해싱 방법 ························································································· 329
부록 A ER Win 모델링 툴 설치 ································································· 335
부록 B DA# 설치 방법 및 사용법 ····························································· 355
부록 C DA 설계 대전 문제 ········································································· 369
추천포스트

교환 및 환불안내

도서교환 및 환불
  • ㆍ배송기간은 평일 기준 1~3일 정도 소요됩니다.(스프링 분철은 1일 정도 시간이 더 소요됩니다.)
  • ㆍ상품불량 및 오배송등의 이유로 반품하실 경우, 반품배송비는 무료입니다.
  • ㆍ고객님의 변심에 의한 반품,환불,교환시 택배비는 본인 부담입니다.
  • ㆍ상담원과의 상담없이 교환 및 반품으로 반송된 물품은 책임지지 않습니다.
  • ㆍ이미 발송된 상품의 취소 및 반품, 교환요청시 배송비가 발생할 수 있습니다.
  • ㆍ반품신청시 반송된 상품의 수령후 환불처리됩니다.(카드사 사정에 따라 카드취소는 시일이 3~5일이 소요될 수 있습니다.)
  • ㆍ주문하신 상품의 반품,교환은 상품수령일로 부터 7일이내에 신청하실 수 있습니다.
  • ㆍ상품이 훼손된 경우 반품 및 교환,환불이 불가능합니다.
  • ㆍ반품/교환시 고객님 귀책사유로 인해 수거가 지연될 경우에는 반품이 제한될 수 있습니다.
  • ㆍ스프링제본 상품은 교환 및 환불이 불가능 합니다.
  • ㆍ군부대(사서함) 및 해외배송은 불가능합니다.
  • ㆍ오후 3시 이후 상담원과 통화되지 않은 취소건에 대해서는 고객 반품비용이 발생할 수 있습니다.
반품안내
  • 마이페이지 > 나의상담 > 1 : 1 문의하기 게시판 또는 고객센터 1800-7327
교환/반품주소
  • 경기도 파주시 문발로 211 1층 / (주)북채널 / 전화 : 1800-7327
  • 택배안내 : CJ대한통운(1588-1255)
  • 고객님 변심으로 인한 교환 또는 반품시 왕복 배송비 5,000원을 부담하셔야 하며, 제품 불량 또는 오 배송시에는 전액을 당사에서부담 합니다.