Consider the project data model shown in Figure 1-15. a. Create a textual description of the diagrammatic
Question:
Consider the project data model shown in Figure 1-15.
a. Create a textual description of the diagrammatic representation shown in the figure. Ensure that the description captures the rules/constraints conveyed by the model.
b. In arriving at the requirements document, what aspect of the diagram did you find was the most difficult to describe? Which parts of the requirements do you still consider to be a little ambiguous? In your opinion, what is the underlying reason for this ambiguity?
Transcribed Image Text:
PRODUCT LINE CUSTOMER Customer ID Product Line Name PL Prior Years Sales Goal Customer Name Customer Type Customer Zip Code PL Current Years Sales Goal Customer Years Includes Places ORDER LINE ORDER PRODUCT Order Number Product ID Order Quantity |Contains Has Product ID Product Description Order Number Order Placement Date Order Fulfillment Date Product Finish Order Number of Shipments Product Standard Price Product Cost Is billed on PR Prior Years Sales Goal PR Current Year Sales Goal INVOICE PAYMENT Is paid on Invoice Number Payment Date Payment Amount Invoice Number Order Number Invoice Date
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 85% (7 reviews)
Questions about Project Data Model in Figure 115 a A Customer places many orders yet an Order is placed by one Customer Each Order is billed on a sing...View the full answer
Answered By
Charles mwangi
I am a postgraduate in chemistry (Industrial chemistry with management),with writing experience for more than 3 years.I have specialized in content development,questions,term papers and assignments.Majoring in chemistry,information science,management,human resource management,accounting,business law,marketing,psychology,excl expert ,education and engineering.I have tutored in other different platforms where my DNA includes three key aspects i.e,quality papers,timely and free from any academic malpractices.I frequently engage clients in each and every step to ensure quality service delivery.This is to ensure sustainability of the tutoring aspects as well as the credibility of the platform.
4.30+
2+ Reviews
10+ Question Solved
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Question Posted:
Students also viewed these Computer Sciences questions
-
The data model for Heather Sweeney Designs is shown in Figure 4-20(c). In Microsoft Visio 2013, create a new Database Model Diagram drawing named HSD-Data-Model. Recreate the data model shown in...
-
Based on the ER model shown in Figure P11.7 and on the query shown after the figure. Figure P11.7: Should you create an index? Why or why not? INVOICE CUSTOMER LINE PK Cus CODE PK INV_NUMBER PK,FK1...
-
Create two tables based on the E-R model shown in Figure 4-41 and the business rules in the following list for a work order tracking database. Include all the constraints in the CREATE TABLE...
-
Refer to the Journal of Experimental Psychology-Applied (June 2000) name-retrieval study, presented in Exercise. The data for the study are saved in the NAMEGAME2 file. a. Find a 99% confidence...
-
Briefly describe standard deviation as a measure of risk or variability.
-
What is the role of the organizational leader as strategist and articulator of global goals?
-
LIFE CY CLE O F FIN AN CIAL PLAN S. Explain the life cycle of financial plans and their role in achieving your financial goals. L01
-
You are considering investing in three stocks with the following expected returns: Stock A......... 7% Stock B......... 12 Stock C.......... 20 What is the expected return on the portfolio if an...
-
Question 5 Flounder Electric sold 3,546,000, 10%, 10-year bonds on January 1, 2017. The bonds were dated January 1 and pay interest annually on January 1. Flounder Bectric uses the straight-line...
-
Prepare a one-page statement explaining how the Hard to Explain, Easy to Experience campaign will actually help TRACE sales among Multicultural Millennials.
-
Consider Figure 1-14. Explain the meaning of the line that connects CUSTOMER to ORDER and the line that connects ORDER to INVOICE. What does this say about how Pine Valley Furniture Company does...
-
Answer the following questions concerning Figures 1-17 and 1-18: Figures 1-17 Figures 1-18 a. What will be the field size for the ProductLineName field in the Product table? Why? b. In Figure 1-18,...
-
Calculate the capacitance-to-neutral in F / m F / m and the admittance-to-neutral in S / k m S / k m for the line in Problem 4.20. Also calculate the total reactive power in Mvar / k m / k m supplied...
-
Machine-hours required to support estimated production Fixed manufacturing overhead cost Variable manufacturing overhead cost per machine-hour Required: 1. Compute the plantwide predetermined...
-
Assume now that a new firm (firm N) discovers and patents a more efficient technology, summarized by thetotal cost function C = 10q. The new technology can be used only by the new firm, which enters...
-
1. How has Dell used virtual integration to become an industry leader? Dell has used virtual integration to become an industry leader by leveraging its global suppliers to reduce costs and provide...
-
3) Consider the asset pricing model with uncertainty in the slide. We derived the asset prices as Pb = Ps = - [nu' (y+Yn + e) + (1 )u' (y + y + e)] u'(e1) [nu' (y +n + ) + (1 )u' (y + y + e2)] u'(e1)...
-
Amazon is considered a leader in managing its supply chain. Describe in detail two parts of Amazon's Supply Chain Management that you see as critical to their success. Please provide your reasoning...
-
A labor union organizes fast-food workers and gets a law passed that raises the minimum age and lowers the maximum age at which a person can work in the fast-food industry. In Greenville, where...
-
Eleni Cabinet Company sold 2,200 cabinets during 2011 at $160 per cabinet. Its beginning inventory on January 1 was 130 cabinets at $56. Purchases made during the year were as follows: February . 225...
-
Distinguishing between cost and expenses Below are descriptions of various resource ac- quisitions by the Doltone Products Company during the year. The company uses straight-line depreciation for all...
-
Identify some interactive applications around you that require access to a database to fetch content or information. Look for the middleware used in these applications. You may need to interview a...
-
Search the Internet for some examples of dynamic Web sites other than e-commerce sites. What are the possible limitations of a dynamic Web site compared to a static Web site?
-
Modify P&E 6-46 to include only those product lines the average price of which is higher than $200.
-
Practice Problem 1 The stockholders equity accounts of Bramble Corp. on January 1, 2017, were as follows. Preferred Stock (6%, $100 par noncumulative, 4,400 shares authorized) $264,000 Common Stock...
-
JVCU Which of the following is considered cash for financial reporting purposes? 1 JVCU Which of the following is considered cash for financial reporting purposes? 1
-
Required information The Foundational 15 [LO8-2, LO8-3, LO8-4, LO8-5, LO8-7, LO8-9, L08-10) (The following information applies to the questions displayed below.) Morganton Company makes one product...
Study smarter with the SolutionInn App