1. What is the process that establishes the need for an information system and its extent?
Systems analysis
2. Which of the following is NOT a factor of the performance of an information system?
Database management functions and features
3. What is the primary objective in creating database design?
Create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models.
4. What are the System Development Life Cycle phases?
Planning, Analysis, Design, Implementation, and Maintenance
5. The feasibility study must address all of the following except _____.
the technical aspects of hardware and software cost
6. The database can be loaded using which methods and devices?
Customized user programs, database interface programs, and conversion programs that import the data from a different file structure
7. Which of the following is NOT true about the classical approaches to database design?
Top-down and bottom-up design methodologies are mutually exclusive.
8. Identify the three steps of a physical design.
Storage, Security, Performance
9. Which of the following is NOT a common factor for database management system selection?
Software requirements
10.Which of the following is NOT a benefit of business rules when designing a new system?
Business rules eliminate the company’s management problems.
Chapter 09 Use It
1Q) 1. The existing system does a good job on gathering, storing and displaying data.
Do not modify or replace the system.
2. The existing system has deficiencies in the flow of information.
Modify the deficiencies
3. There are numerous serious flaws in the current system.
Create a new system:
4. A feasibility study determines we don’t have the technical expertise to implement a new system. We have money to assist with this dilemma. We also feel we may need a new system.
A new system makes good business sense. Hire consultants to assist with the technical aspects.
5. Can we afford a new system? We found the solution would cost more than the return on investment.
Modify the existing system in-house so we can still keep up with the competition.
6. The company doesn’t have the human, technical and financial resources to keep a new system operational.
Budget money to train/hire employees on a new system. This would be done so it is operational feasible.
2Q) You are looking at the planning phase of the Systems Development Life Cycle (SDLC). The questions are posed to determine what should be done in various situations.
1. Choose the correct answer from the dropdown to select what happens in the analysis phase.
Gather requirements by asking the users what they need. Breakdown deliverables into detailed business requirements.
2. Choose the correct answer from the dropdown to select what happens in the system design phase.
Evaluate numerous solutions and determine the best solution. Define a logical solution.
3. Choose the correct answer from the dropdown to select what happens in the implementation phase.
Move from implementation status to production status. Deploy software to all offices globally. Conversion programs import the data to the correct tables. Test all code and validate all results.
4. Choose the correct answer from the dropdown to select what happens in the maintenance phase
Fix system errors, change the system in response to the business environment, enhance the system due to user requests.
5. Choose the correct answer from the dropdown to select what happens in the testing phase of the code.
Find and correct as many errors as possible. Track errors to determine the cause and what other modules they may affect. Test all modules to ensure the data flows correctly when integrated.
3Q) The questions are posed to determine what should be done in various situations.
Analyze the situation and determine the correct answer.
1. Choose the correct answer from the dropdown to select what would be the appropriate backup schedule for a company with data changing once a week.
Differential backup
2. Choose the correct answer from the dropdown to select the appropriate backup schedule when the database needs to be recovered and the committed portion is usable.
Transaction log backup
3. Choose the correct answer from the dropdown to select a common database failure caused by software.
File corruption, file system damage, operating system, DBMS software
4. Choose the correct answer from the dropdown to select a common database failure caused by hardware.
Disk head crash, bad disk sectors, memory chip errors
5. Choose the correct answer from the dropdown to select exploitation opportunities.
SQL injection attacks, hole in the websieve user interface allows remote attackers to inject arbitrary code in the web user interface, malicious code inserted, improperly tested code that can be
4Q) 1. Each customer must have a first and last name entered.
Valid
2. We need to increase production.
Not valid
3. Every invoice must reference a customer record.
Valid
4. Start date can’t be before the end date.
Valid
5. The average production should be increased in November.
Not Valid
6. We only ship plants to Nevada, Oregon and Washington.
Valid
7. Quarterly earnings must increase.
Not valid
8. Each vendor must supply at least one product.
Valid
9. An order is only associated with one customer.
Valid
10. All order items in an order are delivered at the same time.
Valid
11. Length of calls at a call center must decrease.
Not valid
5Q) 1. Map the conceptual model to the logical design
Logical design
2. Describes data for a project.
Physical Design
3. Establish entities.
Conceptual design
4. Contains relationships between tables which includes cardinality.
Physical design
5. Describes constraints.
Conceptual design
6. Normalize the tables.
Logical design
7. Identify all indexes.
physical design
8. Is software and hardware independent.
Conceptual design
9. Datatypes with precision and length are defined for all attributes.
Logical design
10. Organization wide coverage of business concepts.
Conceptual design
11. Define security and user groups.
Physical design
Other Links:
See other websites for quiz:
Check on QUIZLET