Entity relationship Diagram for Online buy and Sale Project
Download as PPTX, PDF
5 likes23,268 views
This document summarizes an online buy and sell project for a computer science course. It outlines four entity sets - Product, User, Area, and Type. Product has attributes like name, serial number, date, description, image, price, email, phone number, type name, and area name. User has attributes like name, username, password, email, and phone number. Area has attributes like area name and number of items. Type has attributes like type name and number of items. The document presents the relationships between these entity sets and their attributes.
Entity relationship Diagram for Online buy and Sale Project
- 1. Project name: ONLINE BUY AND SELL Course No. : CSE304 Department of Computer Science and Engineering Bangladesh University of Engineering and Technology Presented by Naimul Arif(0905004) Babar Md. Khalid Akbar(0905016) Md. Shafiqul Islam(0905026)
- 2. ENTITY SETS: 1. Product 2. User 3. Area 4. Type
- 3. PRODUCT: Attributes : 1. Name (varchar2) 2. Serial no (number) 3. Date (date) 4. Description (varchar2) 5. Image 6. Price (number) 7. E-mail (varchar2) 8. Phone No. (varchar2) 9. Type_name (varchar2) 10.Area_name (varchar2)
- 4. USER: Attributes: 1. Name (varchar2) 2. Username (varchar2) 3. Password (varchar2) 4. E-mail (varchar2) 5. Phone No. (varchar2)
- 5. Area: Attributes: 1. Area_name (varchar2) 2. No. of Items (number)
- 6. Type: Attributes: 1. Type_name (varchar2) 2. No. of Items (number)
- 7. ProductBelongs toUser Area Type Is in has name Username Phone Password E-mail No of items Area_ name No of items Type_ name Date Price Image Description Name E-mailPhone Area_ name Type_ name Serial no