There is a bulleted list associated with Figure 2-21 that describes the entities and their relationships in
Question:
There is a bulleted list associated with Figure 2-21 that describes the entities and their relationships in Pine Valley Furniture. For each of the 10 points in the list, identify the subset of Figure 2-21 described by that point.
Transcribed Image Text:
SALESPERSON TERRITORY DOES BUSINESS IN PK Salesperson ID Serves PK Territory ID Salesperson Name Salesperson Telephone Salesperson Fax Territory Name CUSTOMER PRODUCT LINE PK Customer ID PK Product Line ID Customer Name Customer Address Product Line Name Customer Postal Code Submits Includes ORDER PK Order ID Order Date PRODUCT PK Product ID Product Description Product Finish Product Standard Price ORDER LINE Ordered Quantity VENDOR USES PRODUCED IN PK Vendor ID Vendor Name Goes Into Quantity Vendor Address RAW MATERIAL PK Material ID WORK CENTER SUPPLIES PK| Work Center ID Material Name Material Standard Cost Unit Of Measure Work Center Location Supply Unit Price Is Supervised By EMPLOYEE WORKS IN Supervises O PK Employee ID HAS SKILL SKILL Employee Name Employee Address PK Skill
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 55% (9 reviews)
1 Entities PRODUCT PRODUCT LINE relationship Includes 2 ...View the full answer
Answered By
Mugdha Sisodiya
My self Mugdha Sisodiya from Chhattisgarh India. I have completed my Bachelors degree in 2015 and My Master in Commerce degree in 2016. I am having expertise in Management, Cost and Finance Accounts. Further I have completed my Chartered Accountant and working as a Professional.
Since 2012 I am providing home tutions.
3.30+
2+ Reviews
10+ Question Solved
Related Book For
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
Question Posted:
Students also viewed these Computer science questions
-
There is a bulleted list associated with Figure 2-22 that describes the entities and their relationships in Pine Valley Furniture. For each of the 10 points in the list, identify the subset of Figure...
-
1. Identify the entities and their relationships. Then create an ERD for the reservations system. 2. Create 3NF table designs for the system. 3. For each of the entities identified, design tables and...
-
United Helpers is a nonprofit organization that provides aid to people after natural disasters. Based on the following brief description of operations, create the appropriate fully labeled Crows Foot...
-
In order to evaluate lim f(a+h)-f(), it is necessary to evaluate f(a + h). h xa For f(x) = x 3, f(a+h) =
-
A bus makes a trip according to the position-time graph shown in the illustration. What is the average acceleration (in km/h2) of the bus for the entire 3.5-h period shown in the graph? +20.0 +10.0...
-
At the beginning of 2016, EZ Tech Company's Accounts Receivable balance was 8140,000, and the balance in Allowance for Doubtful Accounts was $2,350 (Cr.). EZ Tech's sales in 2016 were $1,050,000, 80%...
-
Does race affect use of the Internet in various ways? Using the PewWorkPlay dataset, run two regressions using the two Internet use indexes as your dependent variables and the two race reference...
-
pass the journal entries 1) May1, 2019 Business owner opened Renovation& design company and invested $60,000 in business bank account 2) May1, 2019 Business bought supplies $1700 , paid in cash...
-
On April 1 , Jiro Nozomi created a new travel agency. Adventure Travel. The following transactions occurred during the company's first month. April 2 Nozomi invested $ 3 6 , 0 0 0 cash and compuler...
-
Consider the following analog sinusoidal signal: xa(t) = 3 sin (100t) (a) Sketch the signal xa(t) for 0 t 30 ms. (b) The signal xa(t) is sampled with a sampling rate Fs = 300 samples/s. Determine...
-
Explain the distinction between entity type and entity instance.
-
You may have been assigned a CASE or a drawing tool to develop conceptual data models. Using this tool, attempt to redraw all the E-R diagrams in this chapter. What difficulties did you encounter?...
-
Economies of scale are usually associated with the spreading of fixed costs, such as when a manufacturer builds a factory. But the spreading of fixed costs is also important for economies of scale...
-
Write out the form of the partial fraction decomposition of the function (see example). Do not determine the numerical values of the coefficients. x3 (a) x + 7x+6 9x+1 (b) (x + 1)3(x + 2) Submit...
-
You desire to make an 80% by weight vinyl acetate to 20% by weight styrene copolymer via free radical, emulsion polymerization. The r 1 and r 2 values for these monomers are 0.01 and 55,...
-
Q1)In a wheel and axle machine the diameters of the wheel and the axle are 450mm and 60mm respectively.The efficiency is 97%(0.97 per unit).When a body having a mass of 40kg is being lifted.Determine...
-
Smith & Chief Ltd. of Sydney, Australia, is a merchandising firm that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company's income statements...
-
C. In lab, you measure the x & y components of a possible incompressible flow field as u = 2cxy; and where cand a are constants. v = c(a + x - y) 5. (04 pts) Short answer, what is necessary for the...
-
Starbucks is launching their new member cards in three different designs for this coming Christmas. A branch manager would like to know whether the average sales of the three cards are the same for 5...
-
Planning: Creating an Audience Profile; Collaboration: Team Projects. Compare the Facebook pages of three companies in the same industry. Analyze the content on all available tabs. What can you...
-
If the current value of the PC is 0x00000600, can you use a single branch instruction to get to the PC address as shown in Exercise 2.39? Exercise 2.39 Write the MIPS assembly code that creates the...
-
If the current value of the PC is 0x1FFFf000, can you use a single branch instruction to get to the PC address as shown in Exercise 2.39? Exercise 2.39 Write the MIPS assembly code that creates the...
-
Using your code from Exercise 2.43 as an example, explain what happens when two processors begin to execute this critical section at the same time, assuming that each processor executes exactly one...
-
The following amounts were reported on the December 31, 2022, balance sheet: Cash $ 8,000 Land 20,000 Accounts payable 15,000 Bonds payable 120,000 Merchandise inventory 30,000 Retained earnings...
-
Sandhill Co. issued $ 600,000, 10-year, 8% bonds at 105. 1.Prepare the journal entry to record the sale of these bonds on January 1, 2017. (Credit account titles are automatically indented when the...
-
Based on the regression output (below), would you purchase this actively managed fund with a fee of 45bps ? Answer yes or no and one sentence to explain why.
Study smarter with the SolutionInn App