Imagine that you are designing an online shopping system, including basic functions such as item searching...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Imagine that you are designing an online shopping system, including basic functions such as item searching and item collection. To design the system efficiently, you are required to determine the entities in a function and the relationships between functions. For each User of the system, we have his/her customerID, name, username, contact no., and password. When the user search an Item, the system should display the related items and also the item attributes, such as the itemID, name, photo, price. Each item also indicates a CurrentState, which includes (available, wait for several days, or wait for months) as attributes. Moreover, each item belongs to multiple Category, indexed by categoryID. Items can be inserted into users' unique Collection. The collection should list all the items (whose attributes can be ignored here) and the dates when collected. Draw an ER Diagram based on the above description. Imagine that you are designing an online shopping system, including basic functions such as item searching and item collection. To design the system efficiently, you are required to determine the entities in a function and the relationships between functions. For each User of the system, we have his/her customerID, name, username, contact no., and password. When the user search an Item, the system should display the related items and also the item attributes, such as the itemID, name, photo, price. Each item also indicates a CurrentState, which includes (available, wait for several days, or wait for months) as attributes. Moreover, each item belongs to multiple Category, indexed by categoryID. Items can be inserted into users' unique Collection. The collection should list all the items (whose attributes can be ignored here) and the dates when collected. Draw an ER Diagram based on the above description.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these programming questions
-
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...
-
Imagine that you are on the board of directors of a company and you receive a letter from the chairman of the board that starts, "With deep regret and tremendous burden that I am carrying on my...
-
At what points are the function. y = x tan x 2 x + 1
-
Complete (a) and (b). (a) Use analytic methods to evaluate each limit. (b) What does the result from part (a) tell you about horizontal asymptotes? You can verify your conclusions by graphing the...
-
The pivot for the seat of a desk chair consists of the steel plate A, which supports the seat, the solid steel shaft B which is welded to A and which turns freely in the tubular member C, and the...
-
Consider the following two models where $E(\boldsymbol{\varepsilon})=\mathbf{0}$ and $\operatorname{Var}(\boldsymbol{\varepsilon})=\sigma^{2} \mathbf{I}$ : Model A: $\mathbf{y}=\mathbf{X}_{1}...
-
Lance Armstrong won the Tour de France seven consecutive years (1999-2005). The following table gives the winning times, distances, speeds, and margin of victory. (a) Determine the mean and median of...
-
Gold Inc invests $10,000 today in a mutual fund. Gold anticipates leaving this fund alone for 12 years. $ The fund is increased each year-end by specified compound interest rates as follows: years 1...
-
McLennon Company had an Accounts Receivable balance of $320,000 and a credit balance in Allowance for Uncollectible Accounts of $16,700 at January 1, 2014. During the year, the company recorded the...
-
A case of 600 past negligence cases showed 80% of the plantiffs were awarded damages. Of that 80%, the plantiffs recieived only 50% of their requested amount. The plantiff requested $5,800, but would...
-
Prove that the eigenvalues of a matrix are preserved under a similarity transformation; that is, if \(\mathbf{S}^{-1} \mathbf{A S}=\mathbf{B}\), then the eigenvalues of \(\mathbf{A}\) and...
-
Assuming general initial conditions, express the system model in a. Configuration form. b. Standard, second-order matrix form. \(\left\{\begin{array}{l}\frac{1}{3}...
-
Assuming general initial conditions, express the system model in a. Configuration form. b. Standard, second-order matrix form. \(\left\{\begin{array}{l}\frac{1}{2}...
-
Prove that if \(k=\) const and matrix \(\mathbf{A}\) has eigenvalues \(\lambda_{1}, \ldots, \lambda_{n}\), with corresponding eigenvectors \(\mathbf{v}_{1}, \ldots, \mathbf{v}_{n}\), then the...
-
Following data of a centrifugal pump are given as: Diameter at inlet \(=0.4 \mathrm{~m}\); Diameter at outlet \(=1.0 \mathrm{~m} ;\) Speed \(=400 \mathrm{rpm}\); Flow rate \(=2000\) liters \(/...
-
For the given truss below, take P = 20 kN, L= 2.5 m, and H= 4 m to solve the followings: A B H- O 00
-
Find the volume of the described solid S. A frustum of a right circular cone with height h, lower base radius R, and top radius r -r- --R
-
Your manager, the CFO, is adamant-she wishes to put an end to the "Tower of Babel" as she calls the plethora of collaboration tools employed across the company. She wants to ensure there is improved...
-
You are the new operations manager of a large call center for a multinational retailer. The call center has been in operation for several years, but has failed to meet both the customers' and senior...
-
In what way do the rules and regulations shown in Table 5-1 impact you in your role at work or as a student? Which is the most significant? Why?
-
Distinguish between a heat engine, a heat pump, and a refrigerator.
-
Sketch and explain split air conditioner?
-
With a neat sketch of a room air-conditioner, explain its working principle.
Study smarter with the SolutionInn App