design an entity relationship diagram that describes the content of a typical online sales database each...
Fantastic news! We've Found the answer you've been seeking!
Question:
![design an entity relationship diagram that describes the content of a typical online sales database each](https://dsd5zvtm8ll6.cloudfront.net/questions/2023/10/6538eedca8a38_1698229977487.jpg)
Transcribed Image Text:
design an entity relationship diagram that describes the content of a typical online sales database each transaction is made by a registered customer each transaction has a transaction id and the date of purchase under each transaction there is a list of items purchased and the quantity of each in that transaction. each unique type of item appears only once in a transaction. The actual price of each item in that transaction should be included as well, which may be different from the current price. each transaction has a shipping address and the payment information, one of the credit cards of the customer. each type of item has a unique identifier, as description, the quantity available in the warehouse, its original price, and its current price, again: the purchase price of an item in a transaction can be different from the current price which may change from day to day. each customer assumes the database contain his/her id and name, shipping address, billing address, credit card, information, and phone number. Note: A customer may have more than one shipping billing address and credit card provide the entity er diagram as follows: for each entity set E: E(key)other entity set attribute indicate if it is a weak ES. For each relationship R: R(multiplicity of R from X to Y where X and Y are entity sets e.g. R(1-m from X to Y) also indicate whether R is supporting relationship and whether R carries any attributes of its own. You are not expected to use any ISA hierchey for this question, please give correct diagram I don't want texual representation diagram design an entity relationship diagram that describes the content of a typical online sales database each transaction is made by a registered customer each transaction has a transaction id and the date of purchase under each transaction there is a list of items purchased and the quantity of each in that transaction. each unique type of item appears only once in a transaction. The actual price of each item in that transaction should be included as well, which may be different from the current price. each transaction has a shipping address and the payment information, one of the credit cards of the customer. each type of item has a unique identifier, as description, the quantity available in the warehouse, its original price, and its current price, again: the purchase price of an item in a transaction can be different from the current price which may change from day to day. each customer assumes the database contain his/her id and name, shipping address, billing address, credit card, information, and phone number. Note: A customer may have more than one shipping billing address and credit card provide the entity er diagram as follows: for each entity set E: E(key)other entity set attribute indicate if it is a weak ES. For each relationship R: R(multiplicity of R from X to Y where X and Y are entity sets e.g. R(1-m from X to Y) also indicate whether R is supporting relationship and whether R carries any attributes of its own. You are not expected to use any ISA hierchey for this question, please give correct diagram I don't want texual representation diagram
Expert Answer:
Answer rating: 100% (QA)
In Customer entity the attributes are EmailidCusstomaridPassword customer can login using id and pas... View the full answer
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these computer network questions
-
What are the implications of ecological sustainability, social responsibility, and ethical governance for change intervention strategies, and how do advanced change agents integrate principles of...
-
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...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Social welfare is maximized when O Total social benefits have been maximized O total social costs have been minimized O total social costs equal total social benefits O marginal social costs equal...
-
How does gene cloning produce many copies of a gene?
-
At the beginning of 2015, you have $100 invested in a stock. Each year there is a 60 percent chance that the stock increases 50 percent, a 20 percent chance the stock goes up 10 percent, and a 20...
-
A material is not truly considered recycled until it has proceeded through several distinct steps and is ultimately purchased by the consumer. True or false? Justify your answer. List and discuss the...
-
Identify how changes in the external environment affect the OM strategy for a company. For instance, discuss what impact the following external factors might have on OM strategy. (a) Major increases...
-
1. Designer and synthetic drugs are often mislabeled to mask the purpose of those drugs (Le. plant food, jewelry cleaner, etc.) How would you go about regulating a substance that is identified for...
-
Consider the following income tax footnote information for Oracle for the fiscal year ended May 31, 2019 (fiscal year 2019). The following is a geographical breakdown of income before the provision...
-
ample, if i=3.4567%, write your answer as 0.0346 Question 4 2 pts Tony has a 200,000 home loan for 30 years paid monthly at a nominal annual rate of 3.5% convertible monthly. Find the amount of...
-
A company's planned activity level for next year is expected to be 100,000 machine hours. At this level of activity, the company budgeted the following manufacturing overhead costs: Variable Fixed...
-
The Erskine Incorporated Metals Division manufactures an industrial compound used in metal working at the division's only plant. The production process uses two materials. The first is a lubricant...
-
Yang Su is considering the following information on two stocks: Catherine Lam Inc.(A) 1) State of Economy: Recession Probability: 0.3 Rate of return:0.8 2) State of Economy: Normal Probability:0.5...
-
1. El Presidente supermarket attempted to estimate the average amount all households in Tampa spend on groceries each month. Households were separated by zip code, and 25 houses from each of the 56...
-
In Exercises 5-8, identify the class width, class midpoints, and class boundaries for the given frequency distribution. Also identify the number of individuals included in the summary. The frequency...
-
The total revenue (in hundreds of dollars) from the sale of x spas and y solar heaters is approximate by R(x,y) = 10+ 190x + 188y -5x2-7y- 3xy. Find the number of each that should be sold to produce...
-
Chicago Company sold merchandise to a customer for $1,500 cash in a state with a 6% sales tax rate. The total amount of cash collected from the customer was $558. $600. $642. $636. Nevada Company...
-
For the E-R diagram provided in Figure 8.24, draw in the relationship cardinalities and describe them. Describe any assumptions you must make about relevant business rules. Are there any changes or...
-
Interview businesspeople who participate in the purchase of off-the-shelf software in their organizations. Review with them the criteria for selecting off-the-shelf software presented in this...
-
The appendix features two BPMN examples that showed symbols but lacked content. Think of actual processes that can be described with the empty process diagrams in the chapter. These processes will...
-
Is diversity management an ethical issue? jkl5
-
As social media continues to influence health care and promotion across populations, how may nurse leaders be proactive in shaping this landscape?
-
Have antidiscrimination laws helped or hurt the fair treatment of workers? ko5
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App