JUST DRAW ME THE Entity-Relationship Diagram (ERD) Before 7:20 PM pleaseHere is all the entities, attributes and their relationshipsEntities:CustomerItemPurchasePaymentCoffee CardAttributes for Each Entity:Customer:CustomerID (Primary Key)FirstNameLastNameEmailPhoneAddressItem:ItemID (Primary Key)ItemType (e.g., Beverage, Bakery, Coffee Card)ItemNameDescriptionPricePurchase:PurchaseID (Primary Key)CustomerID (Foreign Key)PurchaseDateTotalAmountPayment:PaymentID (Primary Key)PurchaseID (Foreign Key)PaymentMethod (e.g., Cash, Credit Card)PaymentAmountCoffee Card:CardID (Primary Key)CustomerID (Foreign Key)BalanceRelationships:Customer-Item (Many-to-Many):A customer can purchase multiple items.An item can be purchased by multiple customers.Customer-Purchase (One-to-Many):A customer can have multiple purchases.Each purchase is associated with one customer.Purchase-Item (Many-to-Many):Each purchase can include multiple items.An item can be a part of multiple purchases.Purchase-Payment (One-to-One):Each purchase has one associated payment.Each payment is related to one purchase.Customer-Coffee Card (One-to-Many):A customer can have multiple coffee cards.Each coffee card is associated with one customer.Purchase-Coffee Card (Many-to-Many):A purchase can be made using a coffee card.A coffee card can be used for multiple purchases. 1. You are being recruited as a Systems Analyst in the newly opened coffee shopcalled Urban Bean. They want to build a new Point of Sale system where thecustomers can purchase items from their shop and checkout.The shop sells the following items:1. Beverages2. Bakery goods3. Bean cards - customers can load their coffee cards with any amount and useit for the purchase.For the above system:a. Draw an ERD by identifying the entities, attributes and their relationships.

The below diagram represents the entity and attributes such as login system has many customers. The…

Answered: JUST DRAW ME THE Entity-Relationship…

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

JUST DRAW ME THE Entity-Relationship Diagram (ERD) Before 7:20 PM please
Here is all the entities, attributes and their relationships

Entities:

Customer
Item
Purchase
Payment
Coffee Card

Attributes for Each Entity:

Customer:

CustomerID (Primary Key)
FirstName
LastName
Email
Phone
Address

Item:

ItemID (Primary Key)
ItemType (e.g., Beverage, Bakery, Coffee Card)
ItemName
Description
Price

Purchase:

PurchaseID (Primary Key)
CustomerID (Foreign Key)
PurchaseDate
TotalAmount

Payment:

PaymentID (Primary Key)
PurchaseID (Foreign Key)
PaymentMethod (e.g., Cash, Credit Card)
PaymentAmount

Coffee Card:

CardID (Primary Key)
CustomerID (Foreign Key)
Balance

Relationships:

Customer-Item (Many-to-Many):

A customer can purchase multiple items.
An item can be purchased by multiple customers.

Customer-Purchase (One-to-Many):

A customer can have multiple purchases.
Each purchase is associated with one customer.

Purchase-Item (Many-to-Many):

Each purchase can include multiple items.
An item can be a part of multiple purchases.

Purchase-Payment (One-to-One):

Each purchase has one associated payment.
Each payment is related to one purchase.

Customer-Coffee Card (One-to-Many):

A customer can have multiple coffee cards.
Each coffee card is associated with one customer.

Purchase-Coffee Card (Many-to-Many):

A purchase can be made using a coffee card.
A coffee card can be used for multiple purchases.

1. You are being recruited as a Systems Analyst in the newly opened coffee shop
called Urban Bean. They want to build a new Point of Sale system where the
customers can purchase items from their shop and checkout.
The shop sells the following items:
1. Beverages
2. Bakery goods
3. Bean cards - customers can load their coffee cards with any amount and use
it for the purchase.
For the above system:
a. Draw an ERD by identifying the entities, attributes and their relationships.

Expert Solution

Step by step

Solved in 3 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