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...
-
For a propylene glycol n-propyl ether (1) + water (2) system at 335 K with 80% by mole water, deter mine if the system is one stable liquid phase or two stable liquid phases at equilibrium. If the...
-
When flying at the minimum steady flight speed in level flight, if the aircraft enters a level turn without increasing its speed, the aircraft will _____ as the angle of attack is increased to...
-
Green with Envy provides environmentally friendly lawn services for homeowners. Its operating costs are as follows. Depreciation ..... $1,500 per month Advertising ....... $200 per month Insurance...
-
On January 1, 2025, Harrington Company has the following defined benefit pension plan balances. Projected benefit obligation Fair value of plan assets Other data related to the pension plan are as...
-
A lossless transmission line operating at 4.5 GHz has L = 2.4H/m and Zo = 85 . Calculate the phase constant and the phase velocity u.
-
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?...
-
Refer to Fig. 3.16. What is the viscosity and composition of the lavas which formed Hawaii?
-
Airline fares have declined in real terms since the introduction of the Douglas DC-3 throughout the regulated era. What has enabled this decline?
-
Can fuel hedging lower fuel cost? Why do some airlines hedge fuel prices?
-
Why do all large H&S carriers have several different aircraft types (particularly different capacities) in their fleets?
-
To compute the variance, of a discrete random variable you need to know the a. variables possible values. b. expected value of the variable. c. probability of each possible value of the variable. d....
-
Why are H&S systems essential for air travel to most U.S. cities that now have airline service?
-
a. Jodie earned $25,000 at the end of year 1, when the CPI was 460. If the CPI at the end of year 2 is 504, what would Jodie have to earn at the end of year 2 to maintain a constant real wage? b....
-
Uniform electric field in Figure a uniform electric field is directed out of the page within a circular region of radius R = 3.00 cm. The magnitude of the electric field is given by E = (4.50 x 10-3...
-
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...
-
Higgins Company began operations last year. You are a member of the management team investigating expansion ideas that will require borrowing funds from banks. On January 1 , the start of the current...
-
On April 1, 2021, Windsor, Inc. purchased $615,000 of 6% bonds for $639,225 plus accrued interest as an available-for-sale security. Interest is paid on July 1 and January 1 and the bonds mature on...
-
Use the graphical method for linear programming to find the optimal solution for the following problem. Minimize C=3x+15y subject to 2x + 4y 12 5x + 2y 10 and x 0, y 0.
Study smarter with the SolutionInn App