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.
-
Consider the information from Problem 7. Determine how the number of kanbans and the inventory level will be affected if the time required for Robert to receive the material increases to 30 minutes.
-
Robin Alper, a manager of the credit collections department for ACME Building Supplies, is extremely unhappy with a new system that was installed three months ago. Her complaint is that the dataflows...
-
Regis Clothiers can borrow from its bank at 17 percent to take a cash discount. The terms of the cash discount are 3/19, net 45. Should the firm borrow the funds?
-
5. Two independent samples are drawn from normal populations with sample variances 12.46 and 16.48 respectively. To test if the two population variances are different, what is the test statistic (as...
-
From the tenth floor of her office building, Katherine Rally watches the swarms of New Yorkers fight their way through the streets infested with yellow cabs and the sidewalks littered with hot dog...
-
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,...
-
The column is built up by gluing the two boards together. Determine the maximum normal stress on the cross section when the eccentric force of P = 50 kN is applied. 150 mm 250 mm 75 mm 150 mm 50 mm...
-
Give References in APA method and my speech topic is New technology that will change our dailylives. can you make basic speech outline of this topic as following outline. Basic Speech Outline General...
-
A 0.150-m wire oriented north between the poles of an electromagnet carries a direct current of 12.5 A. The angle between the direction of the current and that of the magnetic field is 25.0. If the...
-
Write out the power as the product of three factors of (x + y). Multiply the first two factors. (x+y)(x+y)(x + y) = ( (x+y) (Simplify your answer.)
-
During its first year of operations, Sheffield Corp. had these transactions pertaining to its common stock. Jan. 10 Issued 40,000 shares for cash at $6 per share. July 1 Issued 69,000 shares for cash...
-
Networking has the potential to open doors and create possibilities for jobs and partnerships. Networking establishes connections between individuals and access to information that one might not...
-
Davina bought goods on credit from Sharon for $600 less trade discount of $120. Which entries record this transaction in Davina's books? Account to be debited A Purchases $480 B Purchases $480 C D...
-
The Heese Restaurant Group manufactures the bags of frozen French fries used at its franchised restaurants. Last week, Heeses purchased and used 101,000 pounds of potatoes at a price of $ 0.70 per...
-
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.
-
week Demand for the Table (i) 12 80 70 77 13 14 15 16 17 90 120 100 85 40 30 bikes Demand 50 of Front Rim The 70 60 demand of Rear Rim Table (ii) 80 125 Part/Compone Lead Stock on Hand Batch Size...
-
On March 1, 2024, Gold Examiner receives $157,000 from a local bank and promises to deliver 106 units of certified 1-ounce gold bars on a future date. The contract states that ownership passes to the...
-
Un activo fijo con un coste de 41.000 dlares y una depreciacin acumulada de 36.500 dlares se intercambia por un activo similar con un precio de 60.000 dlares. Suponiendo una indemnizacin por canje de...
Study smarter with the SolutionInn App