Schema Table: CREATE TABLE name_basics (nconst VARCHAR(45) NOT NULL, primaryName VARCHAR(45) NULL, birthYear YEAR(4) NULL, deathYear YEAR(4) NULL, age INT NULL, movieNum INT NULL, PRIMARY KEY (nconst)); CREATE TABLE title_episode (episodeID VARCHAR(45) NOT NULL, parentTconst VARCHAR(45) NULL, seasonNumber INT NULL, episodeNumber INT NULL, PRIMARY KEY (episodeID), CONSTRAINT parentTconst FOREIGN KEY (parentTconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION); CREATE TABLE title_principals (tconst VARCHAR(45) NOT NULL, ordering INT NULL, nconst VARCHAR(45) NULL, category VARCHAR(45) NULL, job VARCHAR(45) NULL, characters VARCHAR(45) NOT NULL, PRIMARY KEY (tconst, characters), CONSTRAINT nconst FOREIGN KEY (nconst) REFERENCES name_basics (nconst) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT tconst FOREIGN KEY (tconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION); CREATE TABLE title_ratings (tconst VARCHAR(45) NOT NULL, averageRating VARCHAR(45) NOT NULL, numVotes VARCHAR(45) NULL, PRIMARY KEY (tconst, averageRating), CONSTRAINT tconst FOREIGN KEY (tconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION); CREATE TABLE types (typeID INT NOT NULL, types VARCHAR(45) NULL, PRIMARY KEY (typeID)); CREATE TABLE types_collection (akasID INT NOT NULL, typeID INT NOT NULL, PRIMARY KEY (akasID, typeID), CONSTRAINT akasID FOREIGN KEY (akasID) REFERENCES title_akas (akasID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT typeID FOREIGN KEY (typeID) REFERENCES type (typeID) ON DELETE NO ACTION ON UPDATE NO ACTION); Prompt: Add triggers to the above schema table that automatically updated when new data in inserted

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Topic: Database

Software: SQLite

Schema Table:

CREATE TABLE name_basics (nconst VARCHAR(45) NOT NULL, primaryName VARCHAR(45) NULL, birthYear YEAR(4) NULL, deathYear YEAR(4) NULL, age INT NULL, movieNum INT NULL, PRIMARY KEY (nconst));

CREATE TABLE title_episode (episodeID VARCHAR(45) NOT NULL,
parentTconst VARCHAR(45) NULL, seasonNumber INT NULL,
episodeNumber INT NULL, PRIMARY KEY (episodeID), CONSTRAINT parentTconst FOREIGN KEY (parentTconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION);

CREATE TABLE title_principals (tconst VARCHAR(45) NOT NULL, ordering INT NULL, nconst VARCHAR(45) NULL, category VARCHAR(45) NULL,
job VARCHAR(45) NULL, characters VARCHAR(45) NOT NULL, PRIMARY KEY (tconst, characters), CONSTRAINT nconst FOREIGN KEY (nconst)
REFERENCES name_basics (nconst) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT tconst FOREIGN KEY (tconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION);

CREATE TABLE title_ratings (tconst VARCHAR(45) NOT NULL, averageRating VARCHAR(45) NOT NULL, numVotes VARCHAR(45) NULL,
PRIMARY KEY (tconst, averageRating), CONSTRAINT tconst FOREIGN KEY (tconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION
ON UPDATE NO ACTION);

CREATE TABLE types (typeID INT NOT NULL, types VARCHAR(45) NULL, PRIMARY KEY (typeID));

CREATE TABLE types_collection (akasID INT NOT NULL, typeID INT NOT NULL, PRIMARY KEY (akasID, typeID), CONSTRAINT akasID FOREIGN KEY (akasID) REFERENCES title_akas (akasID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT typeID FOREIGN KEY (typeID) REFERENCES type (typeID) ON DELETE NO ACTION ON UPDATE NO ACTION);

Prompt: Add triggers to the above schema table that automatically updated when new data in inserted.

Expert Solution