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...
-
Carbon-14 has been used to study the mechanisms of reactions that involve organic compounds. The half-life of carbon-14 is 5.73 103 y. What is the decay constant (in /s)?
-
The historical cost basis results in: a. initially recording assets at cost and adjusting when the current value changes. b. keeping activities of an entity separate and distinct from its owner. c....
-
A gasoline engine consumes 8 litres of fuel per hr. having specific gravity of 0.75 while it develops \(25 \mathrm{~kW}\) power. If the C.V. of fuel used is \(44200 \mathrm{~kJ} / \mathrm{kg}\),...
-
Skulas, Inc., manufactures and sells snowboards. Skulas manufactures a single model, the Pipex. In late 2017, Skulas's management accountant gathered the following data to prepare budgets for January...
-
1. Identify and describe 3 benefits of working in groups 2. Identify and describe 3 potential problems of working in groups. 3. Describe how you would manage the group so all voices are heard,...
-
Population growth in imaginary districts is described by the following table. Use the least square polynomial of degree 2 to predict populations for the year 2000. Solutions step by step please...
-
4. Write a program in java to implement the single source shortest Path Algorithm(Dijktra's Algorithm ). S A ( 3 B D 2 1 E
-
Write a note on types of hash functions?
-
Explain the time complexity of the BFS algorithm.
-
Explain the algorithm for selection sort and give a suitable example.
-
What are the different types of hashing techniques explain with a suitable example?
-
Explain the analysis of searching techniques with best, average and worst case.
-
17. What policies and procedures in your service impact on the environments and experiences you plan and implement?
-
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)
-
Consider the flow of a perfect gas along a Fanno line. Show that the pressure at the * reference state is given by the relation 1/2 m 2RT, P Ayge(y+1)
-
Air flows in an 8-cm-inside diameter pipe that is \(4 \mathrm{~m}\) long. The air enters with a Mach number of 0.45 and a temperature of \(300 \mathrm{~K}\). (a) What friction factor would cause...
-
Air enters a duct with a mass flow rate of \(35 \mathrm{lbm} / \mathrm{sec}\) at \(T_{1}=520^{\circ} \mathrm{R}\) and \(p_{1}=20 \mathrm{psia}\). The duct is square and has an area of \(0.64...
Study smarter with the SolutionInn App