normalize

Tables (13)

Lecture

  • Lecture — varchar(50)
  • grade — varchar(10)
  • No — int(10) — Foreign key → Student.No — NOT NULL

Student

  • No — int(10) — Primary key — NOT NULL
  • class (campus) — varchar(50)

Student_Lecture (Student_lecture)

  • No — int(10) — Primary key — NOT NULL
  • Lecture — varchar(50) — Primary key — NOT NULL
  • class (campus) — varchar(50)
  • grade — varchar(10)

Teams (nation)

  • nation (참여국) — varchar(50)
  • coach (감독) — varchar(50)
  • year (연도) — int(10) — Foreign key → WinnerList.year — NOT NULL

Untitled (Profile)

  • Key (id) — int(10) — Primary key — NOT NULL
  • Field (name) — varchar(50)
  • Field2 (phone1) — varchar(50)
  • Field3 (phone2) — varchar(50)

Untitled (Member)

  • Key (id) — int(10) — Primary key — NOT NULL
  • Field (name) — varchar(50)

Untitled (PhoneBook)

  • Field (phone) — varchar(50)
  • Key (id) — int(10) — Foreign key → Untitled.Key — NOT NULL

WinnerList (worldcup)

  • year (연도) — int(10) — Primary key — NOT NULL
  • Nation (우승국) — varchar(50)

WolrdCup_Coach (Untitled3)

  • coach (Key) — varchar(50) — Primary key — NOT NULL

WorldCup

  • year — int(10) — Primary key — NOT NULL
  • winner — varchar(50)
  • coach — varchar(50)

WorldCup_Winner (Untitled2)

  • Winner (Key) — varchar(50) — Primary key — NOT NULL

WorldCup_Year (Untitled)

  • year (Key) — int(10) — Primary key — NOT NULL

Worldcup (Untitled4)

  • year (Key) — int(10) — Foreign key → WorldCup_Year.year — NOT NULL
  • Winner (Key2) — varchar(50) — Foreign key → WorldCup_Winner.Winner — NOT NULL
  • coach (Key3) — varchar(50) — Foreign key → WolrdCup_Coach.coach — NOT NULL