Systems Analysis and Design Test Preparation
Course Introduction
This course introduces students to the principles, methodologies, and tools used in the analysis and design of information systems. Emphasizing both technical and managerial aspects, the course covers requirements gathering, process modeling, system development life cycles, and documentation techniques. Students will learn how to identify business problems, assess user needs, and propose effective technological solutions by applying structured and object-oriented approaches. Through case studies, group projects, and hands-on software, the course aims to develop practical skills essential for designing efficient, effective, and scalable information systems in real-world organizational settings.
Recommended Textbook
Database Principles Fundamentals of Design Implementation and Management international 10th
Available Study Resources on Quizplus
15 Chapters
1320 Verified Questions
1320 Flashcards
Source URL: https://quizplus.com/study-set/1336 Page 2
Chapter 1: The Database Approach
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26651
Sample Questions
Q1) We are now said to be entering the "knowledge age."
A)True
B)False
Answer: True
Q2) The term _________________________ refers to scattered locations storing the same basic data.
Answer: islands of information
Q3) ____________________ exists when different and conflicting versions of the same data appear in different places.
Answer: Data inconsistency
Q4) ____ data are the result of formatting to facilitate storage, use and generation of information.
A) Structured
B) Semistructured
C) Unstructured
D) Historical
Answer: A
Q5) Raw data must be properly ____________________ for storage, processing and presentation.
Answer: Falseormatted
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Database Development Process
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26652
Sample Questions
Q1) ____________________ security allows the assignment of access rights to specific authorized users.
Answer: Password
Q2) A(n) ____________________ rule is a brief and precise narrative of a policy, procedure, or principle within a specific organization's environment.
Answer: business
Q3) ____________________ design could become a very technical job that affects not only the accessibility of the data in the storage device(s) but also the performance of the system.
Answer: Physical
Q4) The conceptual design step that defines the DBMS and data model to use is ____.
A) database analysis and requirements
B) ER modeling and normalization
C) data-model verification
D) distributed database design
Answer: D
Q5) From a database point of view, the collection of data becomes meaningful only when the business ____________________ are defined.
Answer: rules
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Data Models
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26653
Sample Questions
Q1) The terms data model and database model are often used interchangeably.
A)True
B)False
Answer: True
Q2) Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.
A)True
B)False
Answer: False
Q3) VMS/VSAM is an example of a(n) ____.
A) hierarchical model
B) file system data model
C) relational data model
D) XML data model
Answer: B
Q4) In ____________________, relationships are represented by a diamond connected to the related entities through a relationship line.
Answer: Chen notation
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Relational Model Characteristics
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26654
Sample Questions
Q1) RDBMSs enforce integrity rules automatically.
A)True
B)False
Q2) In a database context, the word ____ indicates the use of the same attribute name to label different attributes.
A) redundancy
B) homonym
C) duplicate
D) synonym
Q3) The proper use of ____________________ keys is crucial to controlling data redundancy.
Q4) A foreign key must exist in both tables that have a relationship.
A)True B)False
Q5) Numeric data are data on which you can perform meaningful arithmetic procedures.
A)True B)False
Q6) The index key can have multiple attributes, this is called a(n) ____________________ index.
Q7) What are the characteristics of a relational table?
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Beginning Structured Query Language Sql
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26655
Sample Questions
Q1) Date procedures are often more software-specific than other SQL procedures.
A)True
B)False
Q2) A(n) ____ is an alternate name given to a column or table in any SQL statement.
A) alias
B) data type
C) stored function
D) trigger
Q3) String comparisons are made from left to right.
A)True
B)False
Q4) In an INSERT command, you can indicate just the attributes that have required values by listing the ____________________ inside parentheses after the table name.
Q5) If you add a new column to a table that already has rows, the existing rows will default to a value of ____________________ for the new column.
Q6) Rows can be grouped into smaller collections quickly and easily using the SQL ____________________ clause.
Q7) To delete an index, use the ____________________ command.
7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Procedural Language Sql and Advanced Sql
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26656
Sample Questions
Q1) Assume you are using the UNION operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION operator?
A) 7
B) 10
C) 15
D) 17
Q2) If you wish to create an inner join, but the two tables do not have a commonly named attribute, you can use a(n) ____ clause.
A) OF
B) USING C) HAS D) JOIN ON
Q3) One of the disadvantages of stored procedures is that they increase network traffic. A)True B)False
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Data Modeling With Entity Relationship
Diagrams
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26657
Sample Questions
Q1) A ____ should be a derived attribute.
A) person's name
B) person's age
C) person's social security number
D) person's phone number
Q2) The ER diagram represents the conceptual database as viewed by the end user.
A)True
B)False
Q3) A(n) ____________________ attribute is an attribute that must have a value.
Q4) Storing ____________________ attributes requires constant maintenance.
Q5) A ____ relationship exists when an association is maintained within a single entity.
A) unary
B) ternary
C) binary
D) weak
Q6) A composite identifier is a primary key composed of more than one attribute.
A)True
B)False
Q7) A weak entity must be ____________________-dependent.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Data Modeling Advanced Concepts
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26658
Sample Questions
Q1) An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.
A)True
B)False
Q2) Specialization is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype.
A)True
B)False
Q3) When selecting a foreign key placement for a 1:1 relationship, place the PK of the entity on the mandatory side in the entity on the optional side as a FK, and make the FK mandatory when ____.
A) one side is mandatory and the other side is optional
B) one side participates in another relationship
C) both sides are optional
D) both sides are mandatory
Q4) The completeness constraint can be partial or total.
A)True
B)False
Q5) In what two cases are composite primary keys particularly useful?
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Normalizing Database Designs
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26659
Sample Questions
Q1) A table that displays data redundancies yields ____.
A) consistencies
B) anomalies
C) fewer attributes
D) more entities
Q2) Dependencies based on only a part of a composite primary key are called ____ dependencies.
A) primary
B) partial
C) incomplete
D) composite
Q3) Describe a dependency diagram and explain its purpose.
Q4) A good relational DBMS excels at managing denormalized relations.
A)True
B)False
Q5) ____________________ refers to the level of detail represented by the values stored in a table's row.
Q6) Normalization produces a lower normal form.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Distributed Databases
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26660
Sample Questions
Q1) The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.
A) multiple-site processing, single-site data
B) single-site processing, multiple-site data
C) single-site processing, single-site data
D) multiple-site processing, multiple-site data
Q2) The TP is the software component found in each computer that requests data.
A)True
B)False
Q3) ____ transparency allows a distributed database to be treated as a single logical database.
A) Distribution
B) Transaction
C) Failure
D) Performance
Q4) In a DDBMS, query ____________________ is used to find the best access strategy.
Q5) The World Wide Web (the Web) is the repository for distributed data.
A)True
B)False
Page 12
Q6) A transaction processor is also known as the ____________________ processor.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 11: Interacting With Databases Through the Web
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26661
Sample Questions
Q1) What are some of the features provided by Web application servers?
Q2) Another name for a database server-side extension is ____.
A) a Web server
B) a Web application server
C) Web-to-database middleware
D) a database application server
Q3) The CGI is a newer Web-server interface standard that is much more efficient and faster than a dynamic link library (DLL).
A)True
B)False
Q4) APIs are faster than _________________________ scripts because the code is resident in memory and there is no need to run an external program for each request.
Q5) APIs are implemented as dynamic-link libraries that are dynamically invoked when needed.
A)True
B)False
Q6) A Web ____________________ server is a middleware application that expands the functionality of Web servers by linking them to a wide range of services.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26662
Sample Questions
Q1) Testing procedures and standards must already be in place before any application program can be approved for use in the company.
A)True
B)False
Q2) In large organizations, the DSO's activities are often classified as ____________________ management.
Q3) The DBA or security officer must secure an insurance policy to provide financial protection in the event of a database failure.
A)True
B)False
Q4) Several DBMS packages contain features that allow the creation of a(n) ____, which automatically records a brief description of the database operations performed by all users.
A) change tracker
B) digital footprint
C) paper trail
D) audit log
Q5) The general coordinator of all DBAs is sometimes known as the ____________________ administrator.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: Managing Transactions and Concurrency
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26663
Sample Questions
Q1) The DBMS guarantees that the semantic meaning of a transaction truly represents the real-world event.
A)True
B)False
Q2) A ____ lock locks the entire diskpage.
A) transaction-level
B) table-level
C) page-level
D) row-level
Q3) One of the three most common data integrity and consistency problems is ____.
A) lost updates
B) disk failures
C) user errors
D) deadlocks
Q4) How does a shared/exclusive lock schema increase the lock manager's overhead?
Q5) Lock ____ indicates the level of lock use.
A) granularity
B) shrinking
C) growing
D) serializability
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 14: Managing Database and Sql Performance
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26664
Sample Questions
Q1) The ____________________ cache is a shared, reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures, including triggers and functions.
Q2) The ____________________ table space is the most frequently accessed table space and should be stored in its own volume.
Q3) One of the main functions of a database system is to provide timely answers to end users.
A)True
B)False
Q4) End users and the DBMS interact through the use of ____________________ to generate information.
Q5) The SQL cache stores the end-user written SQL. A)True
B)False
Q6) ____________________ are special instructions for the optimizer that are embedded inside the SQL command text.
Q7) DBMS query processing has ____________________ phases.
Q8) ____________________ are ordered sets of values that are crucial in speeding up data access.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 15: Databases for Decision Support
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26665
Sample Questions
Q1) In practice, _________________________ provides a well-orchestrated framework for the management of data that works across all levels of the organization.
Q2) The ____________________ hierarchy provides the capability to perform drill-down and roll-up searches in a data warehouse.
Q3) Decision support data are a snapshot of the operational data at a given point in time.
A)True
B)False
Q4) To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end-user workstations.
A)True B)False
Q5) The star schema is designed to optimize data query operations rather than data update operations.
A)True
B)False
Q6) ____________________ is a method or process of government.
Q7) OLAP systems share three main characteristics. What are they?
Page 18
To view all questions and flashcards with answers, click on the resource link above.