Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q 3: Produce an ER diagram to represent the following scenario: [7+7+4+2 = 20 Marks] Enabling small businesses is crucial for any country to have
Q 3: Produce an ER diagram to represent the following scenario: [7+7+4+2 = 20 Marks] Enabling small businesses is crucial for any country to have sustainable and inclusive economic growth. Especially for a developing country like Pakistan, where small businesses account for a substantial contribution to the GDP. Innovative platforms that aim to increase business growth are imperative. Consider that you are assigned to Page 1 of 2 develop database for a company which promotes entrepreneurs and small businesses. The platform provides a diverse directory of categorized small businesses. There exist two types of user, one is customer and the other one is business owner. Business owner needs to login into the system by having a unique email and password. Business owner can add, delete and update their products. Each product has a unique id, name, amount and quantity. A product belongs to a certain category, where each category has a unique name and description. A product can belong to only one category. Customer can login into the system through their Gmail account. Customer is described by their unique email, name, address and phone number. A customer can search and order for many products. When a customer orders a product, he/she should provide a payment method. Payment contains id, amount, and order date. Customers can provide their reviews on the product. Review contains description of their experience. Based upon customer reviews, a product would be ranked. . ER diagram should represent the data requirements as following: Identify the main entity types. [7] Identify the main relationship types between the entity types. [7] Identify attributes and associate them with entity or relationship types. [4] Determine candidate and primary key attributes for each entity type. [2] State any assumptions necessary to support your design
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started