Reference no: EM131165878
THE USER'S ROLE IN DATA MODELING
I have two very different stories regarding data models. First, when I worked with First American Corporation, the head of Marketing kept a data model for the marketing systems hanging on a wall in her office. I thought this was a little unusual for a high level executive, but she explained to me that data was critical for most of the initiatives that she puts in place. Before she can approve a marketing campaign or new strategy, she likes to confirm that the data exists in the systems and that it's accessible to her analysts. She has become very good at understanding ERDs over the years because they had been such an important communications tool for her to use with her own people and with IT. On a very different note, here is a story I received from a friend of mine who heads up an IT department: "We were working on a business critical, time dependent development effort, and VERY senior management decided that the way to ensure success was to have the various teams do technical design walkthroughs to senior management on a weekly basis. My team was responsible for the data architecture and database design. How could senior management, none of whom probably had ever designed an Oracle architecture, evaluate the soundness of our work? So, I had my staff prepare the following for the one (and only) design walkthrough our group was asked to do. First, we merged several existing data models and then duplicated each one . . . that is, every entity and relationship printed twice (imitating, if asked, the redundant architecture). Then we intricately color coded the model and printed the model out on a plotter and printed one copy of every inch of model documentation we had. On the day of the review, I simply wheeled in the documentation and stretched the plotted model across the executive boardroom table. ‘Any questions,' I asked? ‘Very impressive,' they replied. That was it! My designs were never questioned again."
QUESTIONS:
1. From these two stories, what do you think is the user's role in data modeling?
2. When is it appropriate to involve users in the ERD creation process?
3. How can users help analysts create better ERDs?
|
What transpired afterwards be described as inappropriate
: Stacey has worked for lawyer Larry for the last five years in his home office. Stacey does everything for Larry - receptionist, bookkeeper, secretary, paralegal, coffee girl, sometimes even taking his laundry to the cleaners. Stacey is smart and v..
|
|
Draw the four entities that belong on this data model
: Draw the four entities that belong on this data model. Provide some basic attributes for each entity, and select an identifier, if possible. Draw the appropriate relationships between the entities and label them.
|
|
Determining the company stock
: Schiller Corporation will pay a $2.70 per share dividend next year. The company pledges to increase its dividend by 5.5 percent per year, indefinitely. If you require a return of 12 percent on your investment, how much will you pay for the company..
|
|
What is the expected score on a true-false test graded
: What must you do to the number of questions to be able to be a certain percent sure that someone who knows 80% gets a grade within 5 points of the expected percentage score?
|
|
When it appropriate to involve users in erd creation process
: From these two stories, what do you think is the user's role in data modeling? When is it appropriate to involve users in the ERD creation process? How can users help analysts create better ERDs?
|
|
Calculate carmen net income
: Carmen bought the property in March of 1992, and her basis for depreciation on the house is $110,000. She uses straight-line depreciation with a 27 ½ -year life, so the depreciation on the house is $4,000. Calculate Carmen's net income or loss fro..
|
|
Explain law of large numbers from chebyshev''s law
: Explain why this means that we can make the probability that X(x) is between np-sn and np + sn as close to 1 as we want by making n large.
|
|
What entities would you include on a data model
: What entities would you include on a data model? What attributes would you list for each entity? Select an identifier for each entity, if possible.
|
|
Is the hirer liable to pay all the installments due by time
: A hirer, at any time, has a right to terminate the agreement by giving notice in writing to the owner or to his agent. Is the hirer liable to pay all the installments due by the time of the termination of the agreement? What happens if the owner ..
|