Question

name AUTHOR N URL written_by M BOOK title Date_published year month price ISBN M contains 1 SHOPPING BASKET BasketID M published_by 1 PUBLISHER Phone# name

          name
AUTHOR
N
URL
written_by
M
BOOK
title
Date_published
year
month
price
ISBN
M
contains
1
SHOPPING BASKET
BasketID
M
published_by
1
PUBLISHER
Phone#
name

Added by Tricia M.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Akash M

09/13/2023

Step 1

The entities in the E-R diagram are: - AUTHOR - PUBLISHER - BOOK - SHOPPING BASKET The attributes in the E-R diagram are: - AUTHOR: name, Phone# - PUBLISHER: name, URL - BOOK: title, Date_published, year, price, ISBN - SHOPPING BASKET: BasketID, month The keys Show more…

Show all steps

Thanks for your feedback!

Given the E-R diagram on the following page, list the names of the entities, attributes, keys, and relationships being used. 2. For each entity, give a formal written description, including all of its attributes and its key. 3. For each relationship, give a formal written description of both directions of the relationship, including its cardinality.