DAT 380 Advanced Database Architecture The Latest Version A+ Study Guide **********************************************
DAT 380 Entire Course Link https://www.onlinehelp123.com/dat-380 **********************************************
DAT 380 Wk 5 - Apply: Labs Complete zyLabs 5.6–5.7 in zyBooks. You have unlimited attempts in Develop mode. Toggle to Submit mode for a grade 1CREATE TABLE phone(phone_id INT WOT NULL PRIMARY KEY, 2 country code INT NOT NULL, 3phone munber INT NOT NULL, 4phone_type VARCHAR(12) CHECK (phone-type IN("Hone',' lobile',"other"))): 6 ALTER TABL.E custoner ADD COLUDN phone id INT:7ALTER TABLE cu StONer ADD FOREIGN KEY (phone_id)8 REFEREWCES phone (phone id) ON D ELETE SET NULL 10 ON UPDATE CASCADE; 12ALTER TABLE staff ADD COLURN phoneid INT: 13 ALTER TABLE staff ADD FOREIGN KEY (phone id) 14REFERENCES phone (phone_id) ON DELETE SET NULL ON UPDATE C ASCADE: 1516ALTER TABLE store ADD COLUN phone id INT; 17 ALTER TABLE store ADD FOREIGN KEY (phone id)