cengel (1) [Avatar] Offline
#1
ch01.lu_franchise is missing an "s".


ALTER TABLE ch01.fastfoods
ADD CONSTRAINT fk_fastfoods_franchise
FOREIGN KEY (franchise)
REFERENCES ch01.lu_franchise (franchise_code) <<<<
ON UPDATE CASCADE ON DELETE RESTRICT;

correct:
ALTER TABLE ch01.fastfoods
ADD CONSTRAINT fk_fastfoods_franchise
FOREIGN KEY (franchise)
REFERENCES ch01.lu_franchises (franchise_code)
ON UPDATE CASCADE ON DELETE RESTRICT;
regina.leo (265) [Avatar] Offline
#2
Re: typo in code listing 1.3
Thanks for the catch