Problem Description You will be designing a functioning online shopping system for an online business. This...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem Description You will be designing a functioning online shopping system for an online business. This particular business doesn't have a physical store and functions entirely online. For this reason it is very important for them to have a well-designed web page. The online shopping system should have the following functions. Note that some functions are different from the shopping system introduced in the lecture. 1) The shopping system has two roles of users: customers and managers. 2) Customers can view all products. 3) Customers can register and sign up the website. 4) After signing up, customers can add interested products to the cart. Customers can view the cart and process the order or empty the cart. Managers can do all what customers do. 5) 6) In addition, after signing up, managers can add or delete products, view the customer list and the order list (having all orders by customers). Task 3: Designing a database for your website Designing a database consists of 4 basic steps. Problem Description Entity Relationship Diagram 2) Identify the attributes in the problem description. Table Design Task 3.1: Complete the following questions according to the problem description 1) Identify the possible entities in the problem description. 3) Identify how the entities relate to each other (the relationships) 4) Identify what attributes could be used as primary keys for each entity. Task 3.2: Create an ER diagram Database Implementation Task 3.3: Convert the ER Diagram into a Table This is a step by step process: 1) Create one table per entity. 2) Each attribute of the entity is represented as a column in the table. 3) Define the primary key columns (underline them) 4) Add the foreign keys. Problem Description You will be designing a functioning online shopping system for an online business. This particular business doesn't have a physical store and functions entirely online. For this reason it is very important for them to have a well-designed web page. The online shopping system should have the following functions. Note that some functions are different from the shopping system introduced in the lecture. 1) The shopping system has two roles of users: customers and managers. 2) Customers can view all products. 3) Customers can register and sign up the website. 4) After signing up, customers can add interested products to the cart. Customers can view the cart and process the order or empty the cart. Managers can do all what customers do. 5) 6) In addition, after signing up, managers can add or delete products, view the customer list and the order list (having all orders by customers). Task 3: Designing a database for your website Designing a database consists of 4 basic steps. Problem Description Entity Relationship Diagram 2) Identify the attributes in the problem description. Table Design Task 3.1: Complete the following questions according to the problem description 1) Identify the possible entities in the problem description. 3) Identify how the entities relate to each other (the relationships) 4) Identify what attributes could be used as primary keys for each entity. Task 3.2: Create an ER diagram Database Implementation Task 3.3: Convert the ER Diagram into a Table This is a step by step process: 1) Create one table per entity. 2) Each attribute of the entity is represented as a column in the table. 3) Define the primary key columns (underline them) 4) Add the foreign keys.
Expert Answer:
Related Book For
Auditing A Practical Approach with Data Analytics
ISBN: 978-1119401742
1st edition
Authors: Raymond N. Johnson, Laura Davis Wiley, Robyn Moroney, Fiona Campbell, Jane Hamilton
Posted Date:
Students also viewed these computer network questions
-
Read the whitepaper below and summarize what the paper about and discuss the incident response steps the paper mentions and the recovery strategy and phases. Your summary is with 2-3 references and...
-
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...
-
Assess the following statement: Although many investors may be irrational, it is unlikely that over time they will behave irrationally in exactly the same way such as always buying stocks the day...
-
(a) Suppose the supply function for a product is p = 0.1q2 + 1 and the demand function is p = 85 - 0.2q - 0.1q2. Sketch the first-quadrant portion of the graph of each function. Use the same set of...
-
The personnel department of a certain industrial firm used 12 subjects in a study to determine the relationship between job performance rating (y) and scores of four tests. The data are as follows:...
-
Describe the responsibilities of patients as reviewed in this chapter.
-
Plymouth Company issues 300,000 shares of common stock (par value $0.05) for $27 per share on June 30, 2011. Required: Prepare the journal entry to record this transaction.
-
On January 1 , 2 0 2 3 , Fisher Corporation purchased 4 0 percent ( 7 2 , 0 0 0 shares ) of the common stock of Bowden, Incorporated, for $ 9 9 2 , 0 0 0 in cash and began to use the equity method...
-
When a capacitor is completely discharged, the capacitance of the capacitor. a. becomes zero. b. remains the same. c. doubles. d. becomes half. e. None of these.
-
0 0 Find the reduced row eschelon form of the augmented matrix [A b] for A = 3 rref ([A b]) S= Xp = -1 1/3 0 X = = From the reduced row eschelon form, what is the special solution to As = 0? 0 0 3 3...
-
Let = {, 0, 3, } and B = {B, B, B3, B} be two bases of M2x2(F 4). with - = ['a i] = [0 ] b a a a a a 1 1 1 a b a b 00 a Find the vectors a, a2, a3 and as of a Furthermore, let C = = Check a a a]...
-
Let W= = (b) 3 { [ [29] 3 3w+ 2x + 2y + 4z = 5w+ 4x + 2y + 4z EW E W W = span True True 5w+4x + 2y + 4z 2w + 3x + 5y + 3z. False (c) Show that W is a subspace of M2x2(F7). by writing W as the span of...
-
Given R, express its limits as as a definite integral, identifying the correct interval. n 7 Ra - Z 2 (+2) Rn n n i = 1 b dx
-
Solve the following initial and boundary problem. Check your answer by substituting and explain all the steps: Uryz (y, 2) = + xy 2 u (1, y, z) sin y+, u, (1, 0, 2) = 2 3 Uzz (x, 0, 2) = 22 + cos2,...
-
?Which of the following statement is true The largest order among the orders of all the cyclic subgroups of Z, x Z, is 48. Direct product of groups is abelian Z,xZ, is cyclic. O Z10 x Zz x Z, Zs *...
-
The population of Detroit, Michigan, decreased from 1,027,974 in 1990 to 688,701 in 2013 (Source: U.S. Census Bureau). Find the average rate of change in the population of Detroit, Michigan, over the...
-
All Tunes Satellite Radio (ATS) provides a subscription service to satellite radio channels. Customers can pay for a subscription on monthly basis, or pay for a year in advance and receive a 15%...
-
Brad Scarlett is reviewing the results of the subsequent events audit procedures. Brad is writing a report for the audit partner based on these results and will be attending a meeting tomorrow with...
-
Explain the advantages and disadvantages of using probability-proportionate-to-size sampling when testing the existence of accounts receivable.
-
Sketch and explain a simple diagram to match your exhibit.
-
a. Write out and explain the equation for volume breakeven. b. What is the difference between accounting breakeven and economic breakeven?
-
a. What is profit analysis, also known as cost-volume-profit (CVP) analysis? b. Why is profit analysis so useful to healthcare managers? c. What is a profit and loss (P&L) statement?
Study smarter with the SolutionInn App