Using Table 7-1 as a guide, develop a script of at least ten questions you would ask
Question:
Using Table 7-1 as a guide, develop a script of at least ten questions you would ask during an interview of the customer-order processing department manager at Pine Valley Furniture. Assume the focus is on analyzing the requirements for a new order-entry system. The purpose of the interview is to develop a preliminary E-R diagram for this system.
Transcribed Image Text:
TABLE 7-1: Questions to Ask to Develop Accurate and Complete Data Models Category of Questions Questions to Ask System Users and Business Managers 1. Data entities and their descriptions What are the subjects/objects of the business? What types of people, places, things, and materials are used or interact in this business about which data must be maintained? How many instances of each object might exist? 2. Candidate key 3. Attributes and secondary keys 4. Security controls and understanding who really knows the meaning of data 5. Cardinality and time dimensions of data 6. Relationships and their cardinality and degrees 7. Integrity rules, minimum and maximum cardinality, time dimensions of data What unique characteristics distinguish each object from other objects of the same type? Could any such distinguishing feature change over time or is it permanent? Could this characteristic of an object be missing even though we know the object exists? What characteristic describes each object? On what basis are objects referenced, selected, qualified, sorted, and categorized? What must we know about each object in order to run the business? How do you use these data? That is, are you the source of the data for the organization, do you refer to the data, do you modify them, and do you destroy them? Who is not permitted to use these data? Who is responsible for establishing legitimate values for these data? Over what period of time are you interested in these data? Do you need historical trends, current "snapshot" values, and/or estimates or projections? If a characteristic of an object changes over time, must you know the obsolete values? What events occur that imply associations between various objects? What natural activities or transactions of the business involve handling data about several objects of the same or different type? Is each activity or event always handled the same way, or are there special circumstances? Can an event occur with only some of the associated objects, or must all objects be involved? Can the associations between objects change over time (e.g., employees change departments)? Are values for data characteristics limited in any way?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (2 reviews)
Students should identify numerous questions to ask Pine Valley Furnitures manager Students shoul...View the full answer
Answered By
Ishrat Khan
Previously, I have worked as an accounting scholar at acemyhomework, and have been tutoring busines students in various subjects, mostly accounting. More specifically I'm very knowledgeable in accounting subjects for college and university level. I have done master in commerce specialising in accounting and finance as well as other business subjects.
5.00+
134+ Reviews
426+ Question Solved
Related Book For
Essentials Of Systems Analysis And Design
ISBN: 9780133469530
5th Edition
Authors: Joseph Valacich, Joey F George
Question Posted:
Students also viewed these Computer science questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
SeneTech Inc. is a retail and wholesale business focusing on IT hardware. Its head office is located in Bangkok, Thailand. SeneTech has 20 branches located all over Bangkok. The centralized data...
-
The Company Lalo Company, headquartered in Vaduz, is a company listed in Amsterdam, Paris and Zurich. It is the third largest small home appliance manufacturer in Europe. The company was founded in...
-
Clara Hughes, who is pushing 5 0 , has medaled both in speedskating and road cycling ( and showing no signs of slowing down ) completed a training event where she biked 5 0 km east, stopped and rode...
-
Marjorie is an accountant and Alana is an attorney. They have been business acquaintances for about 10 years. They meet every Friday at 6 P.M. at a local tavern to socialize. As always happens with...
-
Baron wrote a check for $ 250 payable to Tydings Automotive for car repairs. The check was written early in the day and processed by her bank and charged to Barons account that same day because Baron...
-
A capacitor has a plate area of \(0.0045 \mathrm{~m}^{2}\) and a charge of magnitude \(q\) on each plate. The space between plates has been filled with a dielectric that has a bound surface charge of...
-
The income statement for M2 Pizza Pie Company for the current year ended June 30 and balances of selected accounts at the beginning and the end of the year are as follows: Prepare the Cash Flows from...
-
16. A signal containing multiple frequencies is shown in figure A. It is passed through 2 different filters and then outputs are shown in figure B & C. M (A) S (B) sha (C) (a) B corresponds to low...
-
Match each of the key terms with the definition that best fits it. ___________ A single occurrence of an entity type. Here are the key terms from the chapter. The page where each term is first...
-
Ask the right kinds of questions to determine data requirements for an information system.
-
A Phillips Curve postulates a negative relationship between inflation and economic slack. However, the relationship between wage inflation and lagged unemployment appeared more negative in the 1960s...
-
The ColorFrame in Section 20.5 uses a grid layout manager. Explain a drawback of the grid that is apparent from Figure 15. What could you do to overcome this drawback? Figure 15 box Rectangle x = 5 y...
-
Write a document builder that turns an invoice object, as defined in Chapter 12, into an XML file of the format described in How To 25.2. Data from how to 25.2 M cars C HOW TO 25.2 Writing an XML...
-
Look up the relativize method in the Path API and explain in which sense it is the opposite of resolve. Give two examples when it is useful; one for files and one for directories.
-
Find an example of a generic class in the standard library that is not a collection class.
-
Provide suitable hashCode and equals methods for the Pair class of Section 18.2 and implement a HashMap class, using a HashSet .
-
What questions should managers answer when setting regular prices?
-
You continue to work in the corporate office for a nationwide convenience store franchise that operates nearly 10,000 stores. The per- store daily customer count (i.e., the mean number of customers...
-
Describe the major phases in the SDLC.
-
Suppose you are an analyst for the Roanoke Software Consulting Company (RSCC), a large consulting firm with offices around the world. The company wants to build a new knowledge management system that...
-
Consumer electronics is a very competitive business. What might be the success story of the year one year is a forgotten item two years later. Rapid product commoditization makes the consumer...
-
Accounting Staff Company uses the periodic inventory method and recorded the following purchases and sales of inventory during the month of September. Sales Purchases Units Unit Cost Units Unit Price...
-
Using the expenditures as the base, determine the allocation of the costs for the Deputy Court Manager, HR and IT for the four departments listed. Enter your responses in the shaded areas in the...
-
If f(x) = -2x 19-x' what is the value of f (8), to the nearest ten- thousandth (if necessary)?
Study smarter with the SolutionInn App