For this assignment you will be designing and creating a database for Coastal Pu

Question

For this assignment you will be designing and creating a database for Coastal Publishing. The publisher has been using a primitive method to keep track of Authors, their Agents, Books, and their Editors, so they have hired you to help create a database to hold the appropriate information. They have already contracted the creation of the following ER diagram that will serve their needs: (AuthorName) Edits EditorFirstName AGENT AgentPhone EoEDITOR EditorName) Mentor Mentoree (AgentName) Mentors AgentFirstName

Explanation / Answer

Part 2:-

CREATE TABLE AUTHOR(

AUTHOR_ID VARCHAR2(10),

AUTHORFIRSTNAME VARCHAR2(100),

AUTHORLASTNAME VARCHAR2(100),

CONSTRAINT AUTHOR_PK PRIMARY KEY (AUTHOR_ID));

CREATE TABLE AGENT (

AGENT_ID VARCHAR2(10),

AGENTFIRSTNAME VARCHAR2(100),

AGENTLASTNAME VARCHAR2(100),

AGENTPHONE NUMBER(10),

AUTHOR_ID VARCHAR2(10),

CONSTRAINT AGENT_PK PRIMARY KEY (AGENT_ID),

CONSTRAINT AGENT_FK FOREIGN KEY (AUTHOR_ID) REFERENCES AUTHOR(AUTHOR_ID));

CREATE TABLE BOOK (

BOOK_TITLE VARCHAR2(10),

BOOKGENRE CHAR(1),

BOOKPUBLISHDATE DATE,

BOOKNUMPAGES NUMBER(10),

AUTHOR_ID VARCHAR2(10),

CONSTRAINT BOOK_PK PRIMARY KEY (BOOK_TITLE),

CONSTRAINT BOOK_FK FOREIGN KEY (AUTHOR_ID) REFERENCES AUTHOR(AUTHOR_ID));

CREATE TABLE EDITOR (

EDITOR_ID VARCHAR2(10),

EDITORFIRSTNAME VARCHAR2(100),

EDITORLASTNAME VARCHAR2(100),

MENTOR VARCHAR2(10),

BOOK_ID VARCHAR2(10),

CONSTRAINT EDITOR_PK PRIMARY KEY (EDITOR_ID),

CONSTRAINT EDITOR_FK FOREIGN KEY (BOOK_ID) REFERENCES BOOK(BOOK_ID));

PART 3:- INSERTS INTO THE DB TABLE

INSERT INTO AUTHOR VALUES ('123456','GOPAL','MALAKAR');

INSERT INTO AUTHOR VALUES ('987654','JACK','SNOW');

COMMIT;

INSERT INTO AGENT VALUES ('12345','MARRY','DSOUZA',1234567890,'123456');

INSERT INTO AGENT VALUES ('54321','MARRY','',,'987654');

COMMIT;

INSERT INTO BOOK VALUES ('TITLE1','D',TO_DATE('12-AUG-2010,'DD-MON-YYYY'), 2000, '12345');

INSERT INTO BOOK VALUES ('TITLE2','',TO_DATE('12-AUG-2010,'DD-MON-YYYY'), , '12345');

COMMIT;

INSERT INTO EDITOR VALUES ('12345','','LASTNAME','','TITLE1');

INSERT INTO EDITOR VALUES ('54321','FIRSTNAME','LASTNAME','12345','TITLE2');

COMMIT;

Please let me know in case of any clarifications required. Thanks!

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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