A furniture sales company wishes to develop a database for the web-based sales database application With...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A furniture sales company wishes to develop a database for the web-based sales database application With the use of this application, a customer can make one or more orders for purchasing furniture products. A product can be included in many different orders. Each furniture product is supplied from one supplier, but a supplier can supply one or more products. Task: follow the four stages approach described in Chapter 5, for designing relational databases to support the sales application. Submit through the Black Board. Deadline: 11 November 2020. Bonus Grade 5%. 1. Identify Entities 2. Identify Relationships 3. Identify all attributes 4. Resolve relationships Identify Entities 1. CUSTOMER 2. 3. Identify Relationships Customer-Order Customer can make one or more (many) orders • An order is made up by one customer Relationship Order-Product Relationship Supplier-Order Relationship 201-CIT111-Introduction to IS Week 10, Date: 31-10-2020 CUSTOMER Identify all attributes (Fields) Table: CUSTOMER Customer-First- Customer-First- Customer-email- Customer-Number Customer-Phone Name Name address Table: Table: 2 A furniture sales company wishes to develop a database for the web-based sales database application With the use of this application, a customer can make one or more orders for purchasing furniture products. A product can be included in many different orders. Each furniture product is supplied from one supplier, but a supplier can supply one or more products. Task: follow the four stages approach described in Chapter 5, for designing relational databases to support the sales application. Submit through the Black Board. Deadline: 11 November 2020. Bonus Grade 5%. 1. Identify Entities 2. Identify Relationships 3. Identify all attributes 4. Resolve relationships Identify Entities 1. CUSTOMER 2. 3. Identify Relationships Customer-Order Customer can make one or more (many) orders • An order is made up by one customer Relationship Order-Product Relationship Supplier-Order Relationship 201-CIT111-Introduction to IS Week 10, Date: 31-10-2020 CUSTOMER Identify all attributes (Fields) Table: CUSTOMER Customer-First- Customer-First- Customer-email- Customer-Number Customer-Phone Name Name address Table: Table: 2
Expert Answer:
Answer rating: 100% (QA)
1 Entities customer product order supplier 2Relationship CustomerOrder Relationship Customer can mak... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
Big win for government in wage bill battle The Constitutional Court has dismissed an appeal brought by public sector unions after the government reneged on aspects of its collective wage agreement...
-
Its useful to develop a feeling for the amounts of energy that correspond to different parts of the electromagnetic spectrum. Calculate the energies of each of the following kinds of radiation (a) A...
-
Many companies are building customer databases through loyalty programs. One example is the Optimum program of Shoppers Drug Mart Corporation. Customers collect Optimum points when they spend money...
-
#CCSEngage de-8/volume-of-spheres IXL Search topics and skills Learning Diagnostic Recommendations DIXLI Volume of spheres | 8th gra X aaaaas Eighth grade > T.14 Volume of spheres QX7 Submit 9 mm...
-
List the fundamental steps involved in planning a static survey.
-
Jim Hetzel manufactures and sells homemade wine, and he wants to develop a standard cost per gallon. The following are required for production of a 50-gallon batch. 3,000 ounces of grape concentrate...
-
Use the following steps to show that \(r\) is bounded by -1 and 1 (These steps are due to Koch, 1990). a. Let \(a\) and \(c\) be generic constants. Verify \[\begin{aligned}0 & \leq \frac{1}{n-1}...
-
Johson Corporation issued bonds twice during 2010. The transactions were as follows: 2010 Jan 1Issued $1,000,000 of 7.5 percent, 10-year bonds dated January 1, 2010, with interest payable on June 30...
-
3. Assume the one switch input (SW1) and the two LEDs (LED1, LED2). Both LEDs should be initially off. After each press and release of SW1, change the LED state (LED1/LED2) in the sequence: ON/ON,...
-
Collars A and B are pin-connected to bar ABD and can slide along fixed rods. Knowing that at the instant shown the velocity of A is 0.9 m/s to the right, determine (a) The angular velocity of ABD,...
-
b. The same loop invariant can be used to prove the correctness of both SortA and SortB. State, but do not prove, this invariant. Loop Invariant: After the t th iteration of the outer loop... c....
-
What is the purpose for SEC regulation of mutual funds? Why might some observers believe that mutual funds are SIFIs and should be regulated as such?
-
How do forward-looking financial markets shorten the time between departures of the economy from the intended path and the effects of policy actions in returning it to that path?
-
If the Fed seeks to stimulate growth in aggregate demand, what should it do with its policy rate? Communications?
-
What is meant by anchored inflation expectations? Do these aid a central bank in stabilizing output and inflation? If so, how?
-
Explain how a major disturbance affecting financial markets in Europe and the European economy can have a big impact on share prices in the United States.
-
Using the decision-making biases listed (anchoring, framing, recency). Discuss the types of decisions where you are likely to be most rational.
-
On January 1, 2018, Khalid Ltd., which follows IAS 17, entered into an eight-year lease agreement for three dryers. Annual lease payments for the equipment are $28,500 at the beginning of each lease...
-
Sketch the graph of a function F that has the following properties: a. F is everywhere continuous; b. F has period ; c. 0 F(x) 2, F(0) = 0, F(/2) = 2; d. F'(x) > 0 for 0 < x < (/2), F'(x) < 0 for...
-
Do Problem 3 if 8(x) = 1 + x3. In problem 3 A straight wire 7 units long has density (x) = x at a point x units from one end. Find the distance from this end to the center of mass.
-
Given that Dx|x| = |x|/x, x 0, find a formula for (a) Dx(|x|2) (b) D2x|x| (c) D3x|x| (d) D2x(|x|2)
-
Find the relationship of the eight SU(3) operators \(T_{ \pm}, V_{ \pm}, U_{ \pm}, T_{3}\), and \(Y\) defined in Eqs. (8.2) and (8.7)-(8.8), and the nine oscillator operators \(\left(A_{i}^{j}...
-
Verify that the set of matrices (5.14) is closed under ordinary matrix multiplication. Data from Eq. 5.14 T(oc)= = 629 > - (+19) TOO) = (721) TO) = ( ). T(oa)= T(b) TO) -(11) T(4-(11) TO=(9) T(C3)= =
-
(a) Show that the most general \(2 \times 2\) unitary matrix with unit determinant can be parameterized as in Eqs. (6.76) and (6.77). (b) Take the group identity element \(U(1,0,0,0)\) to correspond...
Study smarter with the SolutionInn App