Client-Specific Relational Databases

Computer Architecture

Server-Specific Regional Databases

Systems Analysis

• Question 2 3 out of 3 points Answe r: wooden toys, games, and puzzles Answers: a. wooden toys, games, and puzzles b. appliances, housewares, and sporting goods c. furniture d. electronic games The same column name can appear in two different tables in a relational database. Selected Answer: Tr u e Answer s: Tr u e Fal s e Answe r: make the table more complicated Answers: a. • Question 1 3 out of 3 points TAL Distributors sells. Selected a. • Question 3 4 out of 4 points Combining the ORDER_LINE and ORDERS tables will. Selected d. • Question 6 0 out of 3 points • Question 5 3 out of 3 points An example of a relaonship between categories is the relaonship that exists in the TAL Distributors database between sales reps and customers. make the table more effective b. save space in the table c. increase space in the table d. make the table more complicated Answe r: rectangles Answers: a. diamo n ds b. circles c. rectangles d. ovals Selected Answer: Tru e Answer s: Tr u e Fal s e A field is another term for a(n) . Selecte d Answer : c. row Answers: a. entity b. tuple • Question 4 3 out of 3 points In an enty-relaonship (E-R) diagram,are used to represent an enty. Selected c. • Question 7 3 out of 3 points • Question 9 3 out of 3 points • Question 8 3 out of 3 points Each line in the TAL Distributors order form contains an item number, the number of units of the ordered item, the quoted price, and. c. row d. colu mn How many tables make up the TAL Distributors database? Selected b. Answer: 5 Answers: a. 6 b. 5 c. 4 d. 7 Selecte d Answer : c. item description Answers: a. item color b. wholesale price c. item description d. item weight Colonial Adventure Tours offers biking, hiking, and paddling trips. Selected Answer: Tr u e Answers: Tr u e Fal s e A(n) is the association between entities Answe r: relationship Answers: a. join b. relationship c. qualification d. functional dependency

CS | 140 | Server-Specific Regional Databases | assessment | • Question 2 3 out of 3 points

• Queson 2 2 out of 2 points • Queson 1 2 out of 2 points can occur when there is a column in a table that is dependent on only a portion of the primary key. relational management Selecte d Answer : b. Update anomalie s Answers: a. Determinati o n b. Update anomalie s c. Function splitting d. Qualification You can determine functional dependence by viewing sample data. Selected Answer: Fal s e Answers: Tr u e Fal s e Selecte d Answer : d. ORDER_NUM and ITEM_NUM • Queson 3 2 out of 2 points Which of the following is the primary key of the ORDER_LINE (ORDER_NUM , ITEM_NUM , NUM_ORDERED, QUOTED_PRICE) table? • Queson 4 2 out of 2 points • Queson 5 2 out of 2 points • Queson 6 2 out of 2 points Answers: a. ORDER_NUM b. ITEM_NUM c. QUOTED_PRICE d. ORDER_NUM and ITEM_NUM A field is another term for a(n) . Selecte d Answer : b. colu mn Answers: a. tuple b. colu mn c. row d. entity A relation is essentially a three-dimensional table. Selected Answer: Fal s e Answers: Tr u e Fal s e Each column in a table of a relational database should have a distinct name. Selected Answer: Tr u e Answer s: Tr u e • Queson 7 2 out of 2 points Because there is a one-to-many relationship between sales reps and customers in the TAL Distributors database, one sales rep can be associated with zero, one, or more customers. • Queson 10 2 out of 2 points Fal s e Selected Answer: Tru e Answer s: Tr u e Fal s e Selected Answer: Tru e Answer s: Tr u e Fal s e Answe r: first normal form Answers: a. second normal form b. third normal form c. Boyce-Codd normal form d. first normal form • Queson 8 2 out of 2 points If a table contained both employee numbers and Social Security numbers, both columns would be referred to as candidate keys. • Queson 9 2 out of 2 points A relation is inif it does not contain any repeating groups. Selected d. In a relational database, relationships are implemented by having common columns in two or more tables. Selected Answer: Tru Answer s: e Tr u e Fal s e

CS | 140 | Server-Specific Regional Databases | homework | • Queson 2 2 out of 2 points 

Que stion 1 On your level 0 diagram you have a process #2 and when you create a level 1 diagram for process #2, you might have processes like: a. 2.1, 2.21, 2.3 c. 2A, 2B, 2C d. 2-A, 2-B, 2-C e. 2-initial, 2-main, 2-end 1 /1 Question 2 A well-constructed use case makes developing a data ﬂow diagram fairly straightforward. False 2 /2 Question 3 Data ﬂow diagrams are: a. Usually created by users and reviewed by analysts b. Usually jointly created by analysts and users d. Usually created by the project champion and reviewed by the project team e. Usually created by business analyst and reviewed by the infrastructure analyst 1 /1 Question 4 Data (like Year-to-date totals) that come from a data store and are used in a process (like 'Calculate YTD Totals') and then the updated amounts are written back to the data store - can be drawn on a DFD model as a two-headed arrow. True b. 2-1, 2-2, 2-3 True c. Usually created by the project team and reviewed by users for correctness False 1 /1 Question 5 Context diagrams ( which represents a complete system.) show the entire system in context with the environment (like external entities). False 2 /2 Question 6 Processes in data ﬂow diagramming are represented by: b. Arrows c. Rectangles that is open on the right end d. Enclosed rectangles e. Circles 1 /1 1 /1 2 /2 Question 7 Process models are only used to document the current system (that is, the "as-is" system), since that is the system the users know and is the system that will be modiﬁed. True Question 8 Iterations are not used in good DFD design. True Question 9 Carlos has a Level 0 DFD diagram where one of the external entities is the "internal Revenue Service" - and he has a data store called "Tax Rate Table". He has drawn a data ﬂow arrow from the Internal revenue Service to the data store as the data has been loaded into the Tax Rate Table prior to the processing. What would be true? a. This is correct b. This is incorrect, 'data at rest stays at rest until moved by a process' so he needs a process (like 'load Tax Rate Table') ﬁrst in this system d. This is almost correct. The correct diagram would be a dashed line indicating that the loading of the data was implied prior to the start of this process e. This is incorrect. What should happen is an 'external process' should be called at the start of the process - like "Call IRS for data load" 1 /1 Question 10 Project teams usually use process modeling tools or CASE tools to draw process models. False 1 /1 Question 11 True a. Rounded boxes False False c. This is incorrect - he doesn't need a data ﬂow as the data was loaded into the Tax Rate Table someplace else (within the payroll system someplace, but not in this process) True

CS | 115 | Systems Analysis | homework | Que stion 1 On your level 0 di

e. Information for each step 7/20/20 18 Chapter 4 Use Case Analysis test yourself | Schoology 1 /2 Question 1 1/11 The Major Steps Performed section on a use case will give the a. Name of the user for each step b. What triggers each step c. Where the processes will run (such as manual processes, client-server processes, etc.) d. The telecommunications infrastructure requirements for that step 2 /2 Question 2 Barb is an analyst developing a use case. Which of the following will probably NOT be on her use case? a. Important level b. Short Description c. Information for steps e. Type of trigger 1 /1 Question 3 The 'primary actor' is the external user that triggers the event to which the system responds. False 2 /2 Question 4 Omar is an analyst building a use case. Which of the following project roles might be the most important in terms of getting information about building the use case? b. Programmers c. Other analysts d. Project Sponsor e. Equipment vendors 2 /2 Question 5 As a last step in building a use case for the study-abroad registration system, Brianna will: a. Ask Patrick in the study abroad oﬃce to conﬁrm the use case c. Ask Jonathan, a student who just completed a study-abroad experience, to conﬁrm the use case d. Ask Drew in the students aﬀairs oﬃce to conﬁrm the use case e. Ask Taylor, another systems analyst to conﬁrm the use case 1 /1 Question 6 Use cases sometimes are called 'business scenarios'. False d. Destination for the major inputs True a. Users b. Ask Wendy in the registrar's oﬃce to conﬁrm the use case True 7/20/20 18 Chapter 4 Use Case Analysis test yourself | Schoology 2/11 2 /2 1 /1 Question 7 Which is NOT true of use cases? a. They contain all the information needed to build one part of a process model b. Each use case has a name, a number, importance level, brief description, primary actor, trigger, major inputs and outputs, and a list of major steps c. Use cases can be identiﬁed by reviewing the functional requirements d. Use cases should be conﬁrmed by users Question 8 Each use case contains a fairly complete description of all the activities that occur in response to a trigger event. False 1 /1 2 /2 Question 9 Use cases are a type of 'data-driven modeling'. True Question10 Role-playing the use with actual users is a good way to: a. Identify the use case b. Identify the major steps within each use case c. Identify elements within steps e. Identify the primary actor e. Use cases normally contain ten to twelve major steps True False d. Conﬁrm the use case

CS | 115 | Systems Analysis | homework | e. Information for each step 7

Ques tion 1 T j has prepared a spreadsheet where the total beneﬁts are $182,000; the total cummulative costs are $120,000. the ROI would be: a. $62,000 b. About 34% d. About 65.3% e. Less than 205 2 /2 Question 2 Alice is calculating whether a system will lower costs or increase revenues. What SDLC plase is she in? b. Analysis c. Design d. Implementation e. Evaluation 2 /2 Question 3 Chang is working on "How will this system work". What SDLC phase is he in? a. Planning b. Analysis d. Implementation e. Transition 2 /2 Question 4 Another outcome of the planning phase is the: a. Feasibility Analysis document c. System speciﬁcation document d. System proposal document e. Business Process document 1 /1 Question 5 The primary goal of a system is to create value for the organization. False 2 /2 Question 6 The type of skill that is common to systems analysts to understand how IT can be applied to business situations and to ensure that the IT delivers real business value is: a. Technical c. About 51.7% a. Planning c. Design b. Project Plan True c. Analytical d. Interpersonal e. Ethical 2 /2 Question 7 Which of the following project roles would analyze the key business aspects of the system? a. Systems analyst c. Infrastructure analyst d. Change management analyst e. Project manager 1 /1 1 /1 2 /2 1 /1 2 /2 b. Business b. Business analyst

All courses in CS

Popular Documents