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: 83% (6 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.
-
Jake purchased a $225,000 crane for his construction business. He sold the crane for $170,000 after taking $115,000 of depreciation. Assume Jake is in the 33% tax rate bracket. a. On what form would...
-
The time until a chemical reaction is complete (in milliseconds) is approximated by the cumulative distribution function \[ F(x)= \begin{cases}0 & x <0 \\ 1-e^{-0.01 x} & 0 \leq x\end{cases} \]...
-
Home stake Mining Company is a 120-year-old international gold mining company with substantial gold mining operations and exploration in the United States, Canada, and Australia. At year-end, Home...
-
How can ethical theories such as utilitarianism, Kantian ethics, and virtue ethics be applied to complex moral dilemmas, such as those involving conflicting interests and competing moral values ?
-
The variable smokes is a binary variable equal to one if a person smokes, and zero otherwise. Using the data in SMOKE.RAW, we estimate a linear probability model for smokes: The variable white equals...
-
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,...
-
In the following symbolized arguments, derive the line needed to obtain the conclusion (last line), and supply the justification for both lines. 1. ~S 2. 3. SOK
-
The CIB activity of the top five Italian banking groups: similarities and strategic differences Write a paper focusing in particular on Banco BPM, following the following points: 1. The report must...
-
Inflation refers to the increase in general price levels of goods and services over a period. It reduces the purchasing power of money, which can have significant impacts on businesses. For example,...
-
A highly competent MBA 2019 graduate while participating in the CELEBRITY APPRENTICE was given the task of selling a product in the vicinity of Trump Tower in Las Vegas. The same product was given to...
-
What are the demand factors leading to higher ticket prices in the airline industry? Explain how they change the prices. What are the supply factors leading to higher ticket prices in the airline...
-
Roughly 18bn is forecast to be spent in the UK on advertising in 2017. Much of this will be spent by monopolistically competitive firms or oligopolies seeking to differentiate the products they sell...
-
Consider the following statement: For a quasi equilibrium process, the property changes during the process proceed as infinitesimal departures from thermodynamic equilibrium. Is this statement true...
-
Suppose the market is semistrong form efficient. Can you expect to earn excess returns if you make trades based on? a. Your brokers information about record earnings for a stock? b. Rumors about a...
-
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.
-
a) What is arbitrage? And what are the different types of arbitrage? B) Can arbitrage strategies be risky when price convergence is not guaranteed? Clearly describe and outline 1 real-life example to...
-
Explain each segments of Financial Services Industry which are the BANKS, INSURANCE, AND ASSET MANAGEMENT . Explain each. Explain the updates on the 3 segments of Financial Services Industry (banks,...
-
2. Currency pegging refers to the practice of locking a currency's exchange rate to another country's currency. As it has its own merits and drawbacks, express your opinion to agree or disagree on...
Study smarter with the SolutionInn App