Information Systems Design
Solved Exam Questions
Course Introduction
Information Systems Design explores the principles, methodologies, and tools used to analyze, design, and implement effective information systems within organizations. The course covers topics such as system development life cycles, requirements analysis, data modeling, interface design, and system architecture. Students learn to translate business needs into structured solutions by applying industry-standard techniques and technologies, emphasizing both technical and organizational aspects of system implementation. Through case studies and practical projects, the course equips students with the skills necessary to design scalable, efficient, and user-centered information systems that align with organizational goals.
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) The phrase ____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.
A) database management system
B) database management
C) management system
D) database system
Answer: D
Q2) Information implies familiarity, awareness, and understanding knowledge as it applies to an environment.
A)True
B)False
Answer: False
Q3) ____________________ databases focus primarily on storing data used to generate information required to make tactical or strategic decisions.
Answer: Analytical
Q4) Data ____________________ is a discipline that focuses on proper generation, storage and retrieval of data.
Answer: management
To view all questions and flashcards with answers, click on the resource link above.
Page 3
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) What are the classical approaches to database design?
Answer: There are two classical approaches to database design: Top-down design starts by identifying the data sets and then defines the data elements for each of those sets. This process involves the identification of different entity types and the definition of each entity's attributes. Bottom-up design first identifies the data elements (items) and then groups them together in data sets. In other words, it first defines attributes, and then groups them to form entities.
Q2) The result of analysis should be a better understanding of the system's functional areas, actual and potential problems, and opportunities. A)True B)False
Answer: True
Q3) The traditional SDLC phases are ____________________, analysis, detailed systems design, implementation, and maintenance. Answer: planning
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 object-oriented data model was developed in the ____.
A) 1960s
B) 1970s
C) 1980s
D) 1990s
Answer: C
Q2) Each column in a relation represents a(n) ____________________.
Answer: attribute
Q3) Oracle 11g is an example of a(n) ____.
A) hierarchical model
B) file system data model
C) relational data model
D) XML/Hybrid data model
Answer: D
Q4) End-user interfaces require the end user to manually generate SQL code.
A)True
B)False
Answer: False
Q5) Each row in a relation is called a(n) ____________________.
Answer: Trueuple
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) Character data can contain any character or symbol intended for mathematical manipulation.
A)True
B)False
Q2) A ____ key can be described as a superkey without unnecessary attributes, that is, a minimal superkey.
A) secondary
B) candidate
C) primary
D) foreign
Q3) Controlled ____ makes a relational database work.
A) relations
B) logic
C) chaos
D) redundancy
Q4) ____________________ joins are especially useful when you are trying to determine what value(s) in related tables cause(s) referential integrity problems.
Q5) ____________________ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.
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) The SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____.
A) COUNT
B) MIN
C) MAX
D) SUM
Q2) The SQL command that lets you select attributes from rows in one or more tables is ____.
A) INSERT
B) SELECT
C) COMMIT
D) UPDATE
Q3) With the exception of the database ____________________ process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.
Q4) The ____________________ command, coupled with appropriate search conditions, is an incredibly powerful tool that enables you to transform data into information.
Q5) What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?
To view all questions and flashcards with answers, click on the resource link above. Page 7
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) The statement SELECT * FROM T1, T2 produces a(n) ____ join.
A) cross
B) natural
C) equi-
D) full
Q2) In subquery terminology, the first query in the SQL statement is known as the ____ query.
A) outer
B) left
C) inner
D) base
Q3) The Oracle ____ function returns the current date.
A) DATE
B) SYSDATE
C) CURRENT_DATE
D) TO_DATE
Q4) Every PL/SQL block must be given a name.
A)True
B)False
Q5) The IN subquery uses a(n) ____________________ operator.
To view all questions and flashcards with answers, click on the resource link above. Page 8
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 person's social security number would be an example of a(n) ____________________ attribute.
Q2) A composite identifier is a primary key composed of more than one attribute. A)True
B)False
Q3) A derived attribute ____.
A) must be stored physically within the database
B) need not be physically stored within the database
C) has many values
D) must be based on the value of three or more attributes
Q4) ____________________ not only helps you stay on track during the design process, it also enables you and your coworkers to pick up the design thread when the time comes to modify the design.
Q5) A(n) ____________________ attribute need not be physically stored within the database.
Q6) In Chen notation, there is no way to represent cardinality. A)True
B)False
Page 9
Q7) The Crow's Foot model is more ____________________-oriented than the Chen model.
Q8) The ____________________ refers to a specific table row as an entity instance.
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) The ____________________ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype.
Q2) A ____ key is a real-world, generally accepted identifier used to uniquely identify real-world objects.
A) primary
B) natural
C) foreign
D) surrogate
Q3) A(n) ____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.
A) subtype discriminator
B) inheritance discriminator
C) specialization hierarchy
D) entity supertype
Q4) An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.
A)True
B)False
Q5) Disjoint subtypes are also known as ____________________ subtypes.
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) The combination of ____________________ and ER modeling yields a useful ERD, whose entities may now be translated into appropriate table structures.
Q2) A table that is in 2NF and contains no transitive dependencies is said to be in ____.
A) 1NF
B) 2NF
C) 3NF
D) 4NF
Q3) Dependencies can be identified with the help of a dependency ____________________.
Q4) Data redundancy produces ____.
A) slower lookups
B) robust design
C) efficient storage use
D) data integrity problems
Q5) If database tables are treated as though they were files in a file system, the ____________________ never has a chance to demonstrate its superior data-handling capabilities.
Q6) What steps are involved in the conversion to third normal form?
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) ____ transparency allows the integration of several different local DBMSs under a common, or global, schema.
A) Transaction
B) Performance
C) Distribution
D) Heterogeneity
Q2) One of the advantages of a DDBMS is ____________________ operating cost.
Q3) ____ transparency ensures that the system will continue to operate in the event of a node failure.
A) Transaction
B) Distribution
C) Failure
D) Performance
Q4) The ____ processor is the software component found in each computer that requests data. It receives and processes the application's data requests.
A) database
B) transaction
C) data
D) network
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) The Web browser's job is to ____ the HTML code that it receives from the Web server.
A) analyze
B) interpret
C) transform
D) save
Q2) 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.
Q3) What is JavaScript?
Q4) What is a feature of a Web application server?
A) It is Microsoft's implementation of a superset of the SQL Access Group CLI standard for database access.
B) It is automatically invoked by the browser when needed.
C) It runs on the client machine, freeing server resources.
D) It provides an integrated development environment with session management and support for persistent application variables.
Q5) ____________________ are objects (applications or processes) that request and use data.
To view all questions and flashcards with answers, click on the resource link above.
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) The ____ administrator is responsible for strategic planning.
A) system
B) data
C) database
D) program
Q2) The DBMS must provide tools that give each level of management a different view of the data and support the required level of decision-making.
A)True
B)False
Q3) 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
Q4) In today's Internet environment, the DBA must also work with ____________________ and network administrators to implement efficient and secure Web-to-database connectivity.
Q5) Concurrent backups take place while the user is working on the database. A)True
B)False
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) What is transaction isolation and why it is important?
Q2) A ____ lock locks the entire table preventing access to any row by a transaction while another transaction is using the table.
A) database-level
B) table-level
C) page-level
D) row-level
Q3) To determine the appropriate order of the operations, the scheduler bases its actions on concurrency control algorithms, such as ____________________ or time stamping methods.
Q4) The ____ approach to scheduling concurrent transactions assigns a global unique stamp to each transaction.
A) scheduled
B) table-locking
C) unique
D) timestamping
Q5) The DBMS keeps several copies of ____________________ to ensure that a disk physical failure will not impair the DBMS's ability to recover data.
Q6) What are the three basic techniques to control deadlocks?
Page 16
To view all questions and flashcards with answers, click on the resource link above.
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) To generate database object statistics manually, you could use the following syntax:
A) ANALYZE <TABLE/INDEX> object_name;
B) CREATE <TABLE/INDEX> object_name;
C) ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS;
D) CREATE <TABLE/INDEX> object_name COMPUTE STATISTICS;
Q2) To work with the data, the DBMS must retrieve the data from the ____ and place it in the ____.
A) data files, procedure cache
B) data files, data cache
C) temporary files, RAM
D) temporary files, procedure cache
Q3) Good database performance starts with good database design.
A)True
B)False
Q4) All factors must be checked to ensure that each system component operates at its optimum level and has sufficient resources to minimize the occurrence of bottlenecks.
A)True
B)False
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) Had ____ been as pivotal to business operations a few years back, crises precipitated by the likes of Enron, WorldCom, and Arthur Andersen might have been avoided.
A) OLAP
B) data mining
C) governance
D) networking
Q2) MOLAP is a logical choice for companies that already use relational databases for their operational data.
A)True
B)False
Q3) Fact and dimension tables are related by ____ keys.
A) shared
B) primary
C) foreign
D) linked
Q4) Multidimensional data analysis techniques include advanced computational functions.
A)True
B)False
Page 18
To view all questions and flashcards with answers, click on the resource link above.