Copyright 2016 Ramez Elmasri and Shamkant B Navathe
Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe
CHAPTER 4 관계 데이터 모델과 관계 데이터베이스 제약조건 Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 1 - 2
Chapter Outline n n n Relational Model Concepts Relational Model Constraints and Relational Database Schemas Update Operations and Dealing with Constraint Violations Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 5 - 3
관계 모델의 개념 n n 릴레이션 집합의 아이디어에 기초한 수학적 개념 이 모델은 1970 년 IBM Research의 E. F. Codd 박 사가 다음 논문에서 처음 제안했음 : n n "A Relational Model for Large Shared Data Banks, " Communications of the ACM, June 1970 위의 논문은 데이터베이스 관리 분야에서 큰 혁명 을 일으켰으며 영광스러운 ACM Turing Award를 수상했음 Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 5 - 5
릴레이션의 예 4. 1 Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 5 - 7
예제 – STUDENT 릴레이션 4. 1 Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 5 - 16
이전 그림과 동일한 상태 (튜플의 순 서는 서로 다름) 4. 2 Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 5 - 18
두개의 후보키를 가진 CAR 테이블 – License. Number를 기본키로 선택 Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 5 - 27
COMPANY 데이터베이스 스키마 Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 5 - 29
COMPANY를 위한 채워진 데이터베이 스 상태 Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 5 - 32
COMPANY 데이터베이스를 위한 참조 무결 성 제약조건 Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 5 - 38
요약 n Presented Relational Model Concepts n n n Discussed Relational Model Constraints and Relational Database Schemas n n n Definitions Characteristics of relations Domain constraints Key constraints Entity integrity Referential integrity Described the Relational Update Operations and Dealing with Constraint Violations Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 5 - 45
연습문제 (Taken from Exercise 4. 16) Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course: STUDENT(SSN, Name, Major, Bdate) COURSE(Course#, Cname, Dept) ENROLL(SSN, Course#, Quarter, Grade) BOOK_ADOPTION(Course#, Quarter, Book_ISBN) TEXT(Book_ISBN, Book_Title, Publisher, Author) Draw a relational schema diagram specifying the foreign keys for this schema. Copyright © 2016 Ramez Elmasri and Shamkant B. Navathe Slide 5 - 46
- Slides: 46