Lab$3$A $-$ Task Details

Create a conceptual ERD using the online application ERDPlus

Create an ERD based on the following scenario:

A bookstore sells various books, with customers being able to browse the collection,

add books to their shopping carts, and make purchases. The bookstore also keeps

track of its authors and their published works.

Entities

Customer $-$ Represents the customers of the online bookstore.

Attributes: "CustomerID" $($primary key$),$ "Name", "Email", "Address",

"Phone"

Book $-$ Represents books available in the online bookstore.

Attributes: "BookID" $($primary key$),$ "Title", "Genre", "Price",

"PublicationYear"

Author $-$ Represents authors of books sold in the online bookstore.

Attributes: "AuthorID" $($primary key$),$ "Name", "Email", "Biography"

Purchases $-$ Represents the relationship between customers and the books

they purchase.

Attributes: "PurchaseID" $($primary key$),$ "PurchaseDate", "Quantity"

Foreign Keys: "CustomerID" $($references Customer$),$ "BookID"

$($references Book$)$

AuthoredBy $-$ Represents the relationship between authors and the books they

have written.

Attributes: "AuthorshipID" $($primary key$),$ "YearPublished",

"RoyaltyPercentage"

Foreign Keys: "AuthorID" $($references Author$),$ "BookID"

$($references Book$)$

Note

Each customer can make multiple purchases, but each purchase can be linked

to only one customer.

Each book can be purchased multiple times, but each purchase is associated

with one book.

Each book can have multiple authors, and each author can have written

multiple books.