Given these business rules, create the Entity Relationship Diagram, include relationships and cardinalities. A bookstore is modeling its data.On one part, we have the READERS. Readers have a registration ID, name composed by first name and last name, mailing address and list of topics of interest (cooking, fiction, etc).The books available for readers will be stored with title, year of publication, isbn code and a list of topics that the book is tagged for.Authors are also to be stored with an authorID, name composed by first name, middle name and last name, mailing address and date of birth.One book can have multiple authors, but must have at least one.One author can write multiple books, one book or even be registered as an author without authoring any books.A customer can own multiple books and only starts being a costumer after buying her/his first book. I need help understanding how this works and how I put it together

Entity-Relationship (ER) diagram:Entity-Relationship (ER) diagram is used to explain the logical…

Answered: Given these business rules, create the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

Given these business rules, create the Entity Relationship Diagram, include relationships and cardinalities.

A bookstore is modeling its data.

On one part, we have the READERS. Readers have a registration ID, name composed by first name and last name, mailing address and list of topics of interest (cooking, fiction, etc).
The books available for readers will be stored with title, year of publication, isbn code and a list of topics that the book is tagged for.
Authors are also to be stored with an authorID, name composed by first name, middle name and last name, mailing address and date of birth.
One book can have multiple authors, but must have at least one.
One author can write multiple books, one book or even be registered as an author without authoring any books.
A customer can own multiple books and only starts being a costumer after buying her/his first book.

I need help understanding how this works and how I put it together

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions