Minutes of Meeting With Client ‐ 2 - asrithadaida/GDP_ECommerce_Project GitHub Wiki

Date: 02/23/2024

Time: 09:15 AM - 09:30 AM

Location: GS 1050

People in the meeting: Dr. Mark Chai (Client) Sravya Vannemreddy - s564547 - Team Leader Asritha Daida - s560800 - Team member Sai Teja Thatikonda - s564149 - Team Member Naresh Chityala - s562113 - Team member Kavya sree Konda - s558899 - Team member Priyanka Reddy KOdhandam - s554770 - Team member

Meeting agenda The Agenda of the meeting was to discuss the problem statement and the approach towards the project.

Specific questions asked Design of the project(Client) ER diagram in the data management plan(Client) Why there is product ID in the transaction table of ER diagram(Client) What is it about the purchase details in the transaction table of ER diagram(Client)

Specific Answers given We have both the seller and the customer, where sellers can upload the products of their brands and the customer would buy the products from different sellers.(Asritha daida) ER diagram explains about the relationship between the entities like seller, customer, products, orders and transaction(Asritha daida) Product Id is based on the purchased product by the customer where we can easily get the details of the product with the ID from the transaction table.(Asritha daida) Purchase details includes the text area where we include about product name and the type of products the customer purchased and transaction details of the product.(Sravya Vannemreddy)

Action items: Client suggested to remove the product ID from the transaction table where it is acting as the foreign key in the transaction table. We have to cross-check about the purchase details in the transaction table.

Next meeting: 03/08/2024