bird
3/22/2005 4:57:00 PM
ÅÓÔØ ÔÁËÉÅ ÔÁÂÌÉÃÙ:
CREATE TABLE lesson(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
idF INT UNSIGNED NOT NULL REFERENCES faculty(idF),
idG INT UNSIGNED NOT NULL REFERENCES gr(idG),
idDW INT UNSIGNED NOT NULL REFERENCES dayWeek(idDW),
idTi INT UNSIGNED NOT NULL REFERENCES timet(idTi),
idS INT UNSIGNED NOT NULL REFERENCES subject(idS),
idT INT UNSIGNED NOT NULL REFERENCES teacher(idT),
idC INT UNSIGNED NOT NULL REFERENCES corps(idC),
auditory CHAR(50),
PRIMARY KEY (id)
);
CREATE TABLE faculty (
idF INT UNSIGNED NOT NULL AUTO_INCREMENT,
facName CHAR(80) NOT NULL,
PRIMARY KEY (idF),
UNIQUE (facName)
);
CREATE TABLE gr (
idG INT UNSIGNED NOT NULL AUTO_INCREMENT,
idF INT UNSIGNED NOT NULL REFERENCES faculty(idF),
grName CHAR(50) NOT NULL,
PRIMARY KEY (idG)
);
.....
ËÁË ÓÄÅÌÁÔØ ×ÙÂÏÒËÕ ÉÚ ÎÁÂÌÉÃÙ lesson ÞÔÏÂÙ ÐÏÌÕÞÉÔØ ÒÅÚÕÌØÔ ÔÁÂÌÉÃÕ ×
ËÏÔÏÒÏÊ ×ÍÅÓÔÏ idF, idG, idDW,...,idC ÂÙÌÉ ÂÙ Ó×ÑÚÁÎÙÅ ÔÅËÓÔÏ×ÙÅ ÐÏÌÑ:
facName, grName,...,corpsName?