Question

Draw a Schema Diagram using the information.

Signum Libri (SL) is a publishing company.

SL Operations Database will keep track of the following:

• • For each book SL publishes: a book name, genre, date of publication, and number of pages;
• • For each writer: a unique writer identifier as well as the writer’s name;
• • For each agent: a unique agent identifier as well as the agent’s name;
• • For each editor: a unique editor identifier as well as the editor’s name;
• • Each SL book is written by one writer, and each writer can write many SL books. SL will not keep track of writers who did not write a book for SL. All books written by the same writer have a different book name. However, two writers can write two different books with the same book name.
• • Each writer is represented by one agent. Each agent represents at least one writer, but can represent many.
• • Each book has one editor. Each editor edits at least one book, but can edit many books.
• • Each editor can mentor one or more other editors, but does not have to mentor any. Each editor can have at most one mentor editor, but does not have to have any

Answer 1

SOLUTION:

CONSIDERING THE CONDITIONS AND PARAMETERS EITH THE REQUIREMENTS FROM THE QUESTION.

HERE

ER Diagram For Signum libri Publishing company

Step -1 : Identifying the entries english involved in the system.

1. BOOK
2. Editor
3. Agent
4. writer

Step 2: Identifying the Relationships

1. Each book is wnten by one writer and each writer can write many books. So 1:N Relation.
2. Each writer represent by angent. Each agent represents at least one writer 1:N Relation.
3. Each editor can edit many books. so there is 1:N Relation.
4. Each editor can mentor one or more other not have editors, but does to mentor any. Each editor can have at most one mentor editor , but does not have to have any.

Step 3: 1 identifying Attributes

1. Book: BookName, Genre, Daleof Publication, No Of Pages
2. Writer :Writer ID, Writer name
3. Editor: Editor ID, Editor Name
4. Agent: Agent, Agent Name

Schema Diagram:

NOTE: PLEASE UPVOTE ITS VERY MUCH NECESSARY FOR ME A LOT. PLZZZZ....