Program language: SQLite Table syntax: CREATE TABLE Author( aid INTEGER PRIMARY KEY, name TEXT NOT NULL, certifications TEXT NOT NULL, bio TEXT NOT NULL); CREATE TABLE Course( number TEXT PRIMARY KEY, title TEXT NOT NULL, length INTEGER NOT NULL); CREATE TABLE CourseTopic( number TEXT, tid INTEGER PRIMARY KEY, FOREIGN KEY(number) REFERENCES Course(number), FOREIGN KEY(tid) REFERENCES Topic(tid)); CREATE TABLE Topic( tid INTEGER PRIMARY KEY, name TEXT NOT NULL, length INTEGER NOT NULL, subjectArea TEXT NOT NULL, aid INTEGER NOT NULL , FOREIGN KEY(aid) REFERENCES Author(aid)); Task: Construct at least one trigger to either manage a constraint, a derived attribute, or create an audit trail. Update the database if necessary. Which trigger you create and on which table is your choice, but in your submission explain why you built that trigger and what its intended purpose is.
Program language: SQLite
Table syntax:
CREATE TABLE Author( aid INTEGER PRIMARY KEY, name TEXT NOT NULL, certifications TEXT NOT NULL, bio TEXT NOT NULL);
CREATE TABLE Course( number TEXT PRIMARY KEY, title TEXT NOT NULL, length INTEGER NOT NULL);
CREATE TABLE CourseTopic( number TEXT, tid INTEGER PRIMARY KEY, FOREIGN KEY(number) REFERENCES Course(number), FOREIGN KEY(tid) REFERENCES Topic(tid));
CREATE TABLE Topic( tid INTEGER PRIMARY KEY, name TEXT NOT NULL, length INTEGER NOT NULL, subjectArea TEXT NOT NULL, aid INTEGER NOT NULL , FOREIGN KEY(aid) REFERENCES Author(aid));
Task:
Construct at least one trigger to either manage a constraint, a derived attribute, or create an audit trail. Update the
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
