Prepare and include a simple conceptual data model for Piquant showing the data entities and their relationships. Be sure to capture all data entities mentioned. (Hint: review the definition of an entity from the related lecture material).

Conceptual Data Model:

Customer (entity)

Customer ID

Customer Name

Address

E-mail

Phone Number

Birth Date

Opt-Out Status

Employee (entity)

Employee ID

Employee Name

Address

Phone Number

Job Title

Hire Date

Supply (entity)

Item Code

Description

Quantity

Reorder Quantity

Supplier Code

Cost

Creation Date

Store (entity)

Store ID

Store Name

Manager Name

Manager E-mail

Phone Number

Address

IP Address

Transaction (entity)

Transaction ID

Store ID

Date

Total Revenue