2023사서교육원_준사서C반_김종우_연습문제1

테이블 (4)

Company (Untitled4)

  • Field (companySsn) — 기본 키

Component (Untitled3)

  • Key (componentSsn) — 기본 키 — NOT NULL
  • Field (componentExplanation) — text — 기본 키
  • Key (producerSsn) — 외래 키 → Producer.Key — NOT NULL
  • Field (companySsn) — 외래 키 → Company.Field
  • Key (productSsn) — 외래 키 → Product.Key — NOT NULL

Producer (Untitled2)

  • Key (producerSsn) — 기본 키 — NOT NULL
  • Field (producerName)
  • Field (producerAddress) — address
  • Field (porducerPhoneNumber) — number

Product (Untitled)

  • Key (productSsn) — 기본 키 — NOT NULL
  • Field (productExplanation) — text
  • Field (productPrice) — money
  • Field (companySsn) — 외래 키 → Company.Field
  • Key (componentSsn) — 외래 키 → Component.Key — NOT NULL
  • Field (componentExplanation) — text — 외래 키 → Component.Field