Download IS 300 - Exam 2: Database Design and Systems Analysis and more Exercises Financial Management in PDF only on Docsity!
IS 300 - Aut 96 Name _________________________________________ Page 1 Exam 2
- (10) Each of the following table definitions contains one or more problems. Find the problem and rewrite the definition in a way that eliminates the problem. You do not need to draw arrows between tables. Assume that each field that ends in “ID” would have unique values if listed in a table by itself.
a. Student = {StID + StName + MajorID + MajorDesc + AdvisorID + AdvisorName }
b. Trans = { StID + CourseID + StName + CourseDesc + Quarter + Grade }
c. Order = { OrderID + CustID + CustName + Prod1ID + Prod1Desc + Prod2ID + Prod2Desc + Prod3ID + Prod3Desc } (assume that none of the Prod#IDs can ever be equal)
- (6) For each of the following, identify the type of feasibility being evaluated (no justification is necessary). a. A manufacturing firm is considering placing desktop PCs on their manufacturing floor to allow machine operators to enter data via a keyboard. The firm is concerned that the oil and acids used in its manufacturing process might damage the PC and keyboard.
b. A law firm is considering replacing its PCs with network computers (NCs). A NC is connected to an Intranet and does not have any local storage (it uses the Intranet for all storage). The firm knows that this technology is new and untested and they are concerned about this.
c. The law firm described in (b) above is motivated by the potential cost differences between standard PCs and NCs. The estimated cost of a NC is $750 and the cost of a PC is $2,500. The firm is evaluating the functionality of NCs versus PCs and the relative cost differences.
- (9) For each of the following systems, indicate whether the traditional SDLC methodology or the prototyping methodology is most appropriate. You do not need to justify your answer. a. A DSS to be used by marketing managers to help them react to the actions of their competition.
b. An Internet-based order entry system used by a software developer to sell software.
c. A system to be developed for a private utility to help justify rates. Rates must be approved by a state utilities commission. Rate requests vary from year to year and depend on a number of factors including political considerations, the cost of purchasing power, etc.
IS 300 - Aut 96 Page 2 Exam 2
- (11) Convert the following ERD into a RSD. Use terms like “AKey” and “BKey” to specify key fields. Clearly show key fields by underlining them. Show required other fields with the term “other fields”.
Entity A Entity B
Entity D
Entity C
Entity E
- (6) For the following situations, define the most appropriate conversion approach. If you choose pilot or phased, indicate whether parallel or direct should be used within the pilot or phased approach. You do not have to justify your choice. Write your answers in the left margin.
a. A chain of restaurants is replacing their current cash register system with a new system that uses touch screen technology. They are concerned about the conversion because if the new system fails, the restaurant cannot conduct business (they have determined that there is not enough space in a restaurant for both the old and new registers).
b. A private utility is converting its financial systems to a new software package. This financial package includes A/P, A/R, general ledger, and financial planning modules. The utility is very concerned that the new package operates correctly or else the financial integrity of the utility could be in jeopardy.
They have determined there is sufficient capacity on their current computer to support both systems. They have also determined that the new general ledger module can be implemented independent of the other modules.
- (9) Explain why the systems analysis process separates functional requirements into physical and logical models.
IS 300 - Aut 96 Page 4 Exam 2
a subcontractor, it often asks the subcontractor to work on additional projects. When a contract is written for a subcontractor to work on a project, the completion date and fee needs to be stored.
- (9) Each of the following situations describes a DSS analytical modeling approach. For each, identify the specific modeling approach (you need not justify your answer). Write your answer in the left margin.
a. A financial model calculates yearly cask flows based on a number of assumptions. One assumption is the estimated future tax rate.
In his State Of The Union Address, the President indicates that he will be asking Congress for a tax rate reduction. The firm using this financial model wants to assess the impact of the tax rate reduction on future cash flows. b. A firm has a pro forma income statement model (projects income statements into the future). They use this model for pricing decisions (among other things). They have set a profit target of $1 million for next year and they want to know what they should set their price at to achieve this profit figure. c. While designing a financial planning spreadsheet, the financial analysts indicate that values for several of the parameters should be modeled by indicating the mean (average) value and the standard deviation. For example, the estimated future revenues parameter should be modeled using an average of $450,000 and a standard deviation of $100,000.
- (9) Two problems associated with the traditional file-oriented approach to storing data include the data inconsistency problem and the data integration problem. Explain how a relational database helps reduce these problems.
IS 300 - Aut 96 Name _________________________________________ Page 5 Exam 2
- a. Contains transitive dependencies.
{ StID + StName + MajorID + AdvisorID } { MajorID + MajorDesc } { AdvisorID + AdvisorName }
b. Contains partial dependencies. { StID + CourseID + Quarter + Grade } { StID + StName } { CourseID + CourseDesc } c. Contains repeating fields and transitive dependencies.
{ OrderID + CustID } { CustID + CustName } { OrderID + ProdID } { ProdID + ProdDesc }
- a. Operational b. Technical c. Economic
- a. Prototyping b. Traditional SDLC c. Prototyping
- RSD: E = { EKey + other fields }
{ EKey + AKey }
B = { BKey + other fileds + AKey }
D = { BKey + CKey + other fields }
C = { CKey + other fields }
A = { AKey + other fields }
- a. Pilot/Direct b. Phased/Parallel
- An important goal of systems analysis is that the functionality of the system must be accurately defined regardless of the technology chosen to implement the system. Separating the physical model (with technology) from the logical model (requirements without concern for technology) helps meet this goal.
