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
-
XYZ Manufacturing uses Process Costing and incurred normal spoilage of $10,000 and abnormal spoilage of $5,000.How much spoilage should be included in inventory (Finished Goods)? a) $0 b) $5,000 c)...
-
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
-
Use a graphing calculator to complete (a) and (b). 1. 2. lim f(x)? lim f(x).
-
Miller Company acquired an 80 percent interest in Taylor Company on January 1, 2016. Miller paid $664,000 in cash to the owners of Taylor to acquire these shares. In addition, the remaining 20...
-
For each of the numbered items, choose the appropriate classifications for a manufacturing company. If in doubt about whether the cost behaviour is basically variable or fixed, decide on the basis of...
-
Given the following network with activity times in weeks, determine the earliest start and finish times, latest start and finish times, and slack for each activity. Indicate the critical path and the...
-
Electronic Equipment and Much More had an inventory of computers. Using the LIFO method and the perpetual inventory system, the company recorded the initial inventory, purchases and sales. to....
-
Based on the information presented in the minicase, and the discussion in both Chapter 2 and this chapter, to what extent does Elon Musk fit the general charac- teristics of an entrepreneur and a...
-
A beam of udl as shown in figure. Find the deflection at B A m 4a (a) (c) 16Wat 3EI 16Wa EI W 2a (d) W og 8Watsonwolf (b) 3EI 4 8Wa+ EI C
-
2. The new CEO of Radco Manufacturing has asked for a variety of information about the operations of the firm from last year. The CEO is given the following information, but with some data missing:...
-
Why are some advantages and disadvantages of firms's use of long-term debt? Define and explain the concept of flotation costs. What are the benefits to investors of owning preferred stock? Why would...
-
What is the total number of scores for the distribution shown in the following table? X f 4 7 3 5 2 4 1 2 O4 O 10 O 18 39
-
What amount goes on line 1 7 , MACRS deductions for assets placed in service in tax years beginning before 2 0 2 1 , of Form 4 5 6 2 for a rental property placed in service 4 / 1 / 2 0 0 3 purchased...
-
On August 1, Year 1, Sias employer provided her with a loan of $10,000 to buy a car for employment purposes. The loan agreement required the payment of interest at 1% per annum by December 31 every...
-
Discussion Adolescent Biosocial Development & Adolescent Cognitive Development Discuss some of the social and challenges of adolescence. Feel free to speak about personal experiences or the...
-
Using a graphing utility, graph y = cot -1 x.
-
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?
-
How can a profitable business fail? a Because it can't pay its bills b Because it has more current liabilities than current assets c Because it has a bank overdraft d Because it has too much cash
-
When adjusting an operating profit to calculate the 'cash flows from operating activities', an increase in inventories over the financial period would be: a Added to operating profit b Ignored c...
-
Cash has been described as: a The lifebuoy of the business b The lifeboat of the business c The lifeline of the business d The lifeblood of the business
Study smarter with the SolutionInn App