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 |