DB 1

[์ƒํ™œ์ฝ”๋”ฉ] ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ ๋ชจ๋ธ๋ง

1. ์—…๋ฌดํŒŒ์•… : UI ๊ทธ๋ ค๋ณด๊ธฐ, ๊ธฐํš 2. ๊ฐœ๋…์  ๋ฐ์ดํ„ฐ ๋ชจ๋ธ๋ง : ๊ฐœ๋…๋“ค์„ ์ฐพ๊ณ  ๊ด€๊ณ„ ์ฐพ๊ธฐ, ERD ์ •๋ณด-๊ทธ๋ฃน-๊ด€๊ณ„ ex) ์ด๋ฆ„, ํ•™๋ฒˆ - ์ €์ž, ๊ธ€ - ์ž‘์„ฑ, ์ฐธ์„ ๐Ÿฅž ERD (๊ฐœ์ฒด-๊ด€๊ณ„ ๋ชจ๋ธ) RDB๋Š” ๋‚ดํฌ ๊ด€๊ณ„ ํ—ˆ์šฉ x ๊ฑฐ๋Œ€ ๋‹จ์ผ ํ…Œ์ด๋ธ” → ์ค‘๋ณต ๋ฐœ์ƒ → ์ฃผ์ œ์— ๋”ฐ๋ผ ํ‘œ ์ชผ๊ฐœ๊ธฐ, JOIN ์‚ฌ์šฉ Entity → table: ๋Œ“๊ธ€, ๊ธ€, ์ €์ž Attribute → column: ์ด๋ฆ„, ํ•™๋ฒˆ Relation → PK, FK, JOIN: ์ž‘์„ฑ, ์†Œ์† (1) Entity, Attribute ์ฐพ๊ธฐ (2) Identifier ์‹๋ณ„์ž ์ง€์ •(์ค‘๋ณต x) → PK(๊ธฐ๋ณธํ‚ค) : ์‹๋ณ„์ž๋Š” ์ค‘๋ณต ์—†์ด ์‚ฌ์šฉ์ž๋ฅผ ๊ตฌ๋ถ„ํ•  ์ˆ˜ ์žˆ์–ด์•ผ ํ•œ๋‹ค ๊ทธ๋Ÿฌํ•œ ๊ฒƒ์„ ๊ธฐ๋ณธํ‚ค(primary key)๋ผ๊ณ  ํ•œ๋‹ค candidate key = prim..