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