| Feature in Model | Technique Used in Relational Database |
| Class | add a table with a primary key |
| Attribute | add a field with an appropriate data type to the table |
| Object | add a row of data to the table |
| 1-Many Relationship | use a foreign key, i.e., a reference to a particular row (or object) in the table at the 1 end of the relationship |
| Many-Many Relationshop | add a new table and two 1-Many relationships |
| OPtionality of 1 at the 1 end of a relationship | make the value of the foreignh key required |
| Inheritence | add a table for each class, with 1-1 relationships between each child class and the parent (not an exact representation but OK) |
from Table 7-1. Techiniques to represent aspects of the data model,
pp. 115, Beginning Database Design From Novice to Professional, Clare Churcher
'Development > Database' 카테고리의 다른 글
| Docker 기반 MySQL 설치하기 (0) | 2021.02.11 |
|---|---|
| 쿼리로 테이블 이름 조회하기 - MySQL, PostgreSQL, Oracle, MS-SQL (1) | 2020.12.02 |
| DB 설치하지 않고 간편하게 온라인으로 SQL Query 실행해 보기 (0) | 2020.11.29 |
| [oracle] 사용자 조회/ 비밀번호 변경하기 (0) | 2010.09.09 |
| set names euckr (0) | 2009.09.11 |
| from Data Model to Relational Schema (0) | 2009.06.08 |
| mySQL drbd primary 설정적용 (0) | 2008.12.22 |
| 테이블 내용을 파일로 출력하기 (0) | 2008.10.14 |