Consider the scenario for a book collection and answer the questions in part a) and b) below.


The following rules describe the scenario (Please note, we use the term ‘book’ to refer to a title rather than a single specific copy of a book):

• An author has a name and surname.

• An author authors one or many books.

• A book has exactly one author.

• A book has exactly one publisher.

• A book has a title and ISBN number.

• A publisher has a name.

• A publisher might exist but might not yet have published a book.

• A publisher publishes one or many books.

• A book can occur in various formats (e.g. e-book, hardback, paperback).

• A new format might be established before any books are published using it.

• A book has a price, which depends on the format.

• A category describes the type of book, e.g. children’s book, crime, thriller.

• A book can fit into one or more categories.

• A category contains one or more books.

a) Draw the entity relationship diagram for the scenario provided using a suitable notation.

Your answer must show entities with their attributes and their relationships (including cardinality and optionality).

b) Using your design from part a) design a set of tables. Clearly identify all primary and secondary keys and show a few (up to three) rows of data.

Leave an answer

Sorry, you do not have permission to answer to this question .