시스템분석론예제

테이블 (36)

ACTOR (Untitled30)

  • ID (Key) — 기본 키 — NOT NULL
  • name (Field)

BIOGRAPHY (Untitled32)

  • ID (Key3) — 외래 키 → MOVIE.ID — NOT NULL
  • ID (Key) — 외래 키 → ACTOR.ID — NOT NULL
  • play (Field)
  • ID (Key2) — 외래 키 → DIRECTOR.ID — NOT NULL
  • production (Field2)

BORROWRECORD (Untitled28)

  • ID (Key2) — 외래 키 → CUSTOMER.ID — NOT NULL
  • code (Key) — 외래 키 → DVD.code — NOT NULL
  • date (Field)
  • hour (Field2)

BRIDGE (Untitled6)

  • departmentID (Key) — char(10) — 외래 키 → DEPARTMENT.departmentID — NOT NULL
  • Key (Key2) — 외래 키 → LOCATION.Key — NOT NULL

BUYandSELL (Untitled35)

  • ID (Key2) — 외래 키 → CUSTOMER.ID — NOT NULL
  • code (Key) — 외래 키 → SHOES.code — NOT NULL
  • date (Field)
  • quantity (Field2)
  • ID (Key3) — 외래 키 → STAFF.ID — NOT NULL
  • CommissionFee (Field3)
  • goal (Field4)

CLASS (Untitled14)

  • classID (Key) — 기본 키 — NOT NULL
  • code (Key2) — 기본 키 — NOT NULL
  • timetable (Field)
  • limit (Field2)
  • current (Field3)
  • code (Key3) — 외래 키 → SPORT.code — NOT NULL

CLASS DIFFICULTY (Untitled17)

  • level (Key) — 외래 키 → DIFFICULTY.level — NOT NULL
  • classID (Key2) — 외래 키 → CLASS.classID — NOT NULL
  • code (Key22) — 외래 키 → CLASS.code — NOT NULL

CLIENT (Untitled19)

  • ResidentNumber (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)
  • phonenumber (Field3)

COPY (Untitled27)

  • code (Key) — 기본 키 — NOT NULL
  • PurchasedDate (Field)
  • RentalCount (Field2)
  • code (Key2) — 외래 키 → DVD.code — NOT NULL

CUSTOMER (Untitled34)

  • ID (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)
  • PhoneNumber (Field3)
  • PurchaseType (Field4)

CUSTOMER (Untitled24)

  • ID (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)

DEPARTMENT (Untitled)

  • departmentID (Key) — char(10) — 기본 키 — NOT NULL
  • departmentName (Field) — char(20)
  • departmentManager (Field2) — int(10)
  • manageStartDate (Field3) — date
  • ssn (Key2) — char(10) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • projectID (Key3) — char(10) — 외래 키 → PROJECT.projectID — NOT NULL

DEPENDENT (Untitled20)

  • ResidentNumber (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)
  • phonenumber (Field3)
  • ResidentNumber (Key2) — 외래 키 → CLIENT.ResidentNumber — NOT NULL

DIFFICULTY (Untitled16)

  • level (Key) — 기본 키 — NOT NULL

DIRECTOR (Untitled31)

  • ID (Key) — 기본 키 — NOT NULL
  • name (Field)

DVD (Untitled26)

  • code (Key) — 기본 키 — NOT NULL
  • PurchasedDate (Field)
  • RentalCount (Field2)
  • ID (Key2) — 외래 키 → MOVIE.ID — NOT NULL

EMPLOYEE (Untitled2)

  • ssn (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • ResidentNumber (Field4)
  • address (Field3) — char(50)
  • Field6
  • birthday (Field5)
  • Field7
  • phone (Field2) — char(13)
  • departmentID (Key2) — char(10) — 외래 키 → DEPARTMENT.departmentID — NOT NULL

FAMILY (Untitled7)

  • name (Field)
  • gender (Field2)
  • relation (Field3)
  • ssn (Key) — char(10) — 외래 키 → EMPLOYEE.ssn — NOT NULL

LOCATION (Untitled5)

  • Key — 기본 키 — NOT NULL

MEMBER (Untitled15)

  • personalID (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)
  • age (Field3)

MEMBER LEVEL (Untitled18)

  • personalID (Key) — 외래 키 → MEMBER.personalID — NOT NULL
  • level (Key2) — 외래 키 → DIFFICULTY.level — NOT NULL

MOVIE (Untitled29)

  • ID (Key) — 기본 키 — NOT NULL
  • title (Field)
  • CreatedDate (Field2)

PARTS (Untitled9)

  • partsID (Key) — 기본 키 — NOT NULL
  • explanation (Field)

PRODUCER (Untitled10)

  • producerID (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)
  • phonenumber (Field3)

PRODUCT (Untitled8)

  • productID (Key) — 기본 키 — NOT NULL
  • explanation (Field)
  • price (Field2)

PROJECT (Untitled3)

  • projectID (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • description (Field2) — text

PROVIDER (Untitled22)

  • providerID (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)
  • phonenumber (Field3)
  • code (Key2) — 외래 키 → SERVICE.code — NOT NULL

SERVICE (Untitled21)

  • code (Key) — 기본 키 — NOT NULL
  • explanation (Field)

SHOES (Untitled25)

  • code (Key) — 기본 키 — NOT NULL
  • style (Field)
  • size (Field2)
  • color (Field3)
  • stock (Field4)
  • ID (Key2) — 외래 키 → SUPPLIER.ID — NOT NULL

SPORT (Untitled13)

  • code (Key) — 기본 키 — NOT NULL
  • explanation (Field)

STAFF (Untitled36)

  • ID (Key) — 기본 키 — NOT NULL

SUPPLIER (Untitled33)

  • ID (Key) — 기본 키 — NOT NULL

WORKS ON (Untitled4)

  • ssn (Key) — char(10) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • projectID (Key2) — char(10) — 외래 키 → PROJECT.projectID — NOT NULL
  • hours (Field) — float
  • superior (Field2)

bridge (Untitled12)

  • producerID (Key) — 외래 키 → PRODUCER.producerID — NOT NULL
  • partsID (Key2) — 외래 키 → PARTS.partsID — NOT NULL

mingled (Untitled11)

  • partsID (Key) — 외래 키 → PARTS.partsID — NOT NULL
  • productID (Key2) — 외래 키 → PRODUCT.productID — NOT NULL
  • quantity (Field)

service provided (Untitled23)

  • providerID (Key) — 외래 키 → PROVIDER.providerID — NOT NULL
  • ResidentNumber (Key2) — 외래 키 → CLIENT.ResidentNumber — NOT NULL
  • date provided (Field)