Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

C++ Database Development

Authors: Al Stevens

1st Edition

1558283579, 978-1558283572

Students also viewed these Databases questions