CREATE DATABASE SigLib; CREATE TABLE Agent ( AgentID CHAR(4) NOT NULL, AgentName VARCHAR(25) NOT NULL, PRIMARY KEY (AgentID));

CREATE TABLE Writer ( WriterID CHAR(4) NOT NULL, WriterName VARCHAR(25) NOT NULL, AgentID CHAR(4) NOT NULL, PRIMARY KEY (WriterID), FOREIGN KEY (AgentID) REFERENCES Agent(AgentID));

CREATE TABLE Editor ( EditorID CHAR(4) NOT NULL, EditorName VARCHAR(25) NOT NULL, Mentors_EditorID CHAR(4) NULL, PRIMARY KEY (EditorID), FOREIGN KEY (Mentors_EditorID) REFERENCES EDITOR (EditorID));

CREATE TABLE Book ( BookName VARCHAR(25) NOT NULL, WriterID CHAR(4) NOT NULL, Genre VARCHAR(25) NOT NULL, DateOfPublication DATE NOT NULL, NoOfPages CHAR(4) NOT NULL, EditorID CHAR(4) NOT NULL, PRIMARY KEY (BookName), FOREIGN KEY (WriterID) REFERENCES Writer(WriterID), FOREIGN KEY (EditorID) REFERENCES Editor(EditorID));

# Inserting data into the database tables INSERT INTO Agent VALUES ('1','Jeff'); INSERT INTO Agent VALUES ('2','Lucy');

INSERT INTO Writer VALUES ('10','Anne','1'); INSERT INTO Writer VALUES ('11','Jack','2'); INSERT INTO Writer VALUES ('12','Clive','2'); INSERT INTO Writer VALUES ('13','Isaac','2');

INSERT INTO Editor VALUES ('20','Melanie',NULL); INSERT INTO Editor VALUES ('21','Elisha',NULL); INSERT INTO Editor VALUES ('22','George','21'); INSERT INTO Editor VALUES ('23','Marina','23'); INSERT INTO Editor VALUES ('24','Tracy',NULL);

INSERT INTO Book VALUES ('Valley of Heroes','10','Fiction','2010-01-12','874','20'); INSERT INTO Book VALUES ('The Rulers Return','11','Fantasy','2012-03-14','765','22'); INSERT INTO Book VALUES ('An Uncles Letters','12','Fiction','2012-06-12','258','20'); INSERT INTO Book VALUES ('A Tale of Lions','12','Fantasy','2012-08-17','301','21'); INSERT INTO Book VALUES ('eRobot','13','Sci Fi','2012-04-10','465','23'); INSERT INTO Book VALUES ('Return to Mars','13','Sci Fi','2012-04-10','345','23'); INSERT INTO Book VALUES ('Starwars','13','Sci Fi','2013-11-04','405','23'); INSERT INTO Book VALUES ('Robot wars','13','Sci Fi','2014-09-04','285','23'); INSERT INTO Book VALUES ('Fly me to the moon','13','Sci Fi','2015-10-04','555','23');

Create a new user with the name; Carl Sagan at your local host and identify the user with the password cosmos. Grant this user the privilege to SELECT and UPDATE the Book table in the database, which you have built. As the third and the final step, show that all privileges are properly granted.