Sesame, an e-commerce platform, bridges the gap between consumers and sellers. To manage its daily operations...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sesame, an e-commerce platform, bridges the gap between consumers and sellers. To manage its daily operations effectively and keep track of pertinent information about sellers, buyers, products, orders, package deliveries, and after-sales reviews, Sesame requires an efficient database. Specifically, 1. 2. Every user who registers on Sesame receives a unique user ID, and their profile also includes details such as their name, phone number, and address. 3. 4. 5. Each seller on Sesame is assigned a unique seller ID. The seller's profile includes their store name, store rating, and contact information. Sellers offer a range of products in their stores. Sesame's policy does not permit stores that have no products for sale. The database also records product information, including a unique product ID, product name, price, and description. 7. Sesame has implemented a category system for product management. Each category has a unique ID, name, and description. A product may be assigned to multiple categories. For instance, an iPhone could fall under both "mobile" and "electronic devices. Categories can exist without having any products to maintain the integrity and stability of the classification system. The category system follows a hierarchical structure, meaning a category can contain sub-categories or belong to a broader category, and these relationships should also be reflected in the database. Users can purchase products on Sesame. Each transaction is recorded as an order, identified by a unique number. The database records basic information such as transaction date, order amount, and payment method. An order may consist of multiple lines, each relating to a specific product and the quantity purchased. 6. Following the completion of payment for an order, the package delivery process begins. As an order may include multiple products supplied by different sellers, it can be split into multiple deliveries. Each delivery is sent by one courier and received by one user. For each delivery, Sesame needs to track the associated order, the courier's ID and name, and the recipient user (we assume every recipient is the user of Sesame). Users have the option to review the products they've purchased. Sesame records such information to provide purchase references to potential buyers. Each review includes the date, content, rating, and associated product. A user can submit multiple reviews for a product, but each review corresponds to a specific product. Based on the above description, please draft an ER diagram for the Sesame platform. Sesame, an e-commerce platform, bridges the gap between consumers and sellers. To manage its daily operations effectively and keep track of pertinent information about sellers, buyers, products, orders, package deliveries, and after-sales reviews, Sesame requires an efficient database. Specifically, 1. 2. Every user who registers on Sesame receives a unique user ID, and their profile also includes details such as their name, phone number, and address. 3. 4. 5. Each seller on Sesame is assigned a unique seller ID. The seller's profile includes their store name, store rating, and contact information. Sellers offer a range of products in their stores. Sesame's policy does not permit stores that have no products for sale. The database also records product information, including a unique product ID, product name, price, and description. 7. Sesame has implemented a category system for product management. Each category has a unique ID, name, and description. A product may be assigned to multiple categories. For instance, an iPhone could fall under both "mobile" and "electronic devices. Categories can exist without having any products to maintain the integrity and stability of the classification system. The category system follows a hierarchical structure, meaning a category can contain sub-categories or belong to a broader category, and these relationships should also be reflected in the database. Users can purchase products on Sesame. Each transaction is recorded as an order, identified by a unique number. The database records basic information such as transaction date, order amount, and payment method. An order may consist of multiple lines, each relating to a specific product and the quantity purchased. 6. Following the completion of payment for an order, the package delivery process begins. As an order may include multiple products supplied by different sellers, it can be split into multiple deliveries. Each delivery is sent by one courier and received by one user. For each delivery, Sesame needs to track the associated order, the courier's ID and name, and the recipient user (we assume every recipient is the user of Sesame). Users have the option to review the products they've purchased. Sesame records such information to provide purchase references to potential buyers. Each review includes the date, content, rating, and associated product. A user can submit multiple reviews for a product, but each review corresponds to a specific product. Based on the above description, please draft an ER diagram for the Sesame platform.
Expert Answer:
Answer rating: 100% (QA)
Solutions Step 1 Based on your requirement first check the database entities and their relationships The Entities will beSellerUserProductProductOrderOrder Detail and Review Explanation Seller Seller ... View the full answer
Related Book For
Operations Management Processes And Supply Chains
ISBN: 9781292409863
13th Global Edition
Authors: Lee Krajewski, Naresh Malhotra, Larry Ritzman
Posted Date:
Students also viewed these programming questions
-
In 2022 Green, Inc., had gross receipts from sales of $500,000, dividends of $100,000 from a domestic corporation in which Green, Inc., owned 50% of the stock, and operating expenses of $800,000....
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
Custom Truck Builders frequently uses long-term lease contracts to finance the sale of its trucks. On November 1, 2015, Custom Truck Builders leased to Interstate Van Lines a truck carried in the...
-
A muon formed high in the Earths atmosphere travels at speed v = 0.990c for a distance of 4.60 km before it decays into an electron, a neutrino, and an antineutrino ( e + v + v). (a) How long does...
-
The Ka of a certain indicator is 2.0 3 1026. The color of HIn is green and that of In2 is red. A few drops of the indicator are added to a HCl solution, which is then titrated against a NaOH...
-
Comment on the following statement: "On October 19, 1987, the U.S. stock market crashed. As the globe turned the following day, the devastation spread from New York to Tokyo, Hong Kong, Sydney, and...
-
Stillwater Designs rebuilds defective units of its S12L7 Kicker speaker model. During the year, Stillwater rebuilt 5,000 units. Materials and labor standards for performing the repairs are as...
-
What effect did the propaganda following the Boston Massacre have on the colonists?
-
Find a current computer ad in a magazine or newspaper or online. Identify each of the featured items in the ad, show its position in the system block diagram of Figure 11.1, explain how it operates,...
-
Melanies Matcha Iced Tea (Matcha Inc.) has prepared the following standard cost information per bottle of iced tea: Standard Quantity (or Hours) Standard Price (or Rate) Standard Cost Direct...
-
1. Provide a brief description of your implicit theory of leadership, i.e., your beliefs about the characteristics and behaviors of effective leaders. Does this description seem to agree with or be...
-
Suppose you read in The Wall Street Journal that a $1,000 par value, 8 year, 6%, semi-annual bond is trading at $984. If your required rate of return is 6%, what would be the bond's current yield?...
-
John Kotter describes "What leaders really do." Peter Drucker describes "What makes an Effective Executive." What are the similarities, if any, between the two theories? What are the differences, if...
-
Calculate the centripetal force on the end of a 96-m (radius) wind turbine blade that is rotating at 0.5 rev/s. Assume the mass is 3 kg. Fe=|| N Enter an integer or decimal number [more..]
-
BUSY Co. plans to sell a 180 day commercial paper amounting to Php 100,000,000 which it expects to pay a discounted interest of 12% per annum. BUSY expects to incur Php 100,000 in dealer placement...
-
31 3 points Advantages of the corporate form of business include which of the following? 1. Double taxation II. Ability to raise capital III. Ability to transfer ownership IV. More paperwork V....
-
Explain why it is not wise to accept a null hypothesis.
-
An automobile service is having difficulty providing oil changes in the 29 minutes or less mentioned in its advertising. You are to analyze the process of changing automobile engine oil. The subject...
-
You are in charge of a project at the local community center. The center needs to remodel one of the rooms in time for the start of a new program. Delays in the project mean that the center must rent...
-
Figure 13.17 shows a partially completed inventory record for the real wheel subassembly. Gross requirements, scheduled receipts, lead time, and current on-hand inventory are shown. a. Complete the...
-
In a vapour compression refrigeration system, the condition of refrigerant before entering the compressor is (a) saturated liquid (b) wet vapour (c) dry saturated liquid (d) superheated vapour
-
During a refrigeration cycle, heat is rejected by the refrigerant in (a) compressor (b) condenser (c) evaporator (d) expansion valve
-
The highest temperature during the cycle in vapour compression refrigeration system occurs after (a) compression (b) condensation (c) expansion (d) evaporation
Study smarter with the SolutionInn App