Greetings

I'm a 4th-year Ph.D. candidate in Computer Science at the University of Toronto, working under the supervision of Prof. Khai Truong.

My research centers human-AI interaction, with an emphasis on accessibility and creativity support, particularly in enhancing "music accessibility" for d/Deaf and hard-of-hearing individuals. One of my main projects involves song signing to support culturally responsive content creation and encourage collaboration between d/Deaf and non-d/Deaf artists. Another aspect of my work focuses on enhancing people's well-being. I am engaged in projects that support individuals with dementia in their out-of-home experiences and encourage mindful eating behaviours among children.

I completed my B.Sci in Computer Science and Engineering at Ewha Womans University, where I was advised by Prof. Uran Oh (Human-Computer Interaction Lab) and Prof. Hyokyung Bahn (Distributed Computing and Operating System Lab). Additionally, I worked as a research intern at the Samsung AI Centre Toronto under the guidance of Dr. Iqbal Mohomed, and at NAVER AI (HCI group) with Dr. Young-Ho Kim.

2장 관계 DB모델과 제약조건

 <관계 데이터 모델>

- Relation: 2d table

- Record: row == Tuple

- Attribute: col

- Domain: 애트리뷰트 값들의 집합

- Degree: # of attributes = 세로 수

- Cardinallity: # of tuples(records) = 가로 수

- Schema: Relation name + attribute

- Instance: set of tuples

- Relation: set of tuples 하나의 튜플 - 키


<KEY>

: 튜플 식별

1) Super KEY: 고유 식별

2) Candidate KEY: 고유 식별 최소한의 모임

3) 기본 KEY: 후보키 중 하나 선정

4) 대체 KEY: 기본키가 아닌 후보키

5) Reference KEY: 기본키 참조 - 관계


<데이터 무결성>

1) 도메인 제약조건

각 애트리뷰트는 원자값

2) 키 제약조건

키 애트리뷰는 원자값

2) 엔티티 무결성 제약조건

기본키는 널값가질 수 없음

3) 참조 무결성 제약조건

두 릴레이션의 연관된 튜플 사이의 ㅣㅇㄹ관성 유지


<갱신 연산>

삽입/ 삭제/ 수정

* 옵션: Restricted(거절)/ Cascade(함께 삭제)

Comments