Create a database for a wiki (site that allows collaborative modification of its

Question

Create a database for a wiki (site that allows collaborative modification of its content and structure directly from the web browser). We needs to keep a history of the modifications of each page by keeping each version of each page as a separate row: PageRevision(name, date, author, text) I a) Create a view called Page(name, last author, text). This view should shows only the latest version of each page. Create a trigger called EditPage on your newly created view Page. When a user tries to update (this should be understood as an insertion or update) a given page, a new revision is created instead (new line into the PageRevision Table). Explain what the next trigger is performing: CREATE TRIGGER DeletePage INSTEAD OF DELETE ON Pages FOR EACH ROW b) c) DELETE FROM PageRevisions WHERE nameOLD.name; INSERT ?NTO deletelog VALUES (old.name, NOn());

Explanation / Answer

A.Create View

C.

it just inserting the deleted values(old value) from PageRevistion into deleting table to save the deleted record by the use.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.