Business Database Systems
Study Guide Questions
Course Introduction
Business Database Systems introduces students to the fundamental concepts and practical applications of database technologies within a business context. The course covers topics such as data modeling, database design, and implementation using relational database management systems (RDBMS). Students learn to create, query, and manage databases using Structured Query Language (SQL) and explore advanced concepts like normalization, indexing, and transaction management. Emphasis is placed on how databases support business operations, decision-making, and data integrity, as well as emerging trends such as cloud databases and big data. Through hands-on projects and real-world case studies, students develop the skills necessary to design, implement, and maintain robust, efficient databases for various business scenarios.
Recommended Textbook
Modern Database Management 12th Edition by Jeffrey A. Hoffer
Available Study Resources on Quizplus
14 Chapters
1469 Verified Questions
1469 Flashcards
Source URL: https://quizplus.com/study-set/1058 Page 2
Chapter 1: The Database Environment and Development Process
Available Study Resources on Quizplus for this Chatper
116 Verified Questions
116 Flashcards
Source URL: https://quizplus.com/quiz/20934
Sample Questions
Q1) Enterprise modeling sets the range and general contents of organizational databases.
A)True
B)False
Answer: True
Q2) In two-tier database architectures, little functionality needs to be programmed into the client application.
A)True
B)False
Answer: False
Q3) E. F. Codd developed the relational data model during the 1970s.
A)True
B)False
Answer: True
Q4) An enterprise resource planning system integrates all functions of the enterprise.
A)True
B)False
Answer: True
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Modeling Data in the Organization
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20935
Sample Questions
Q1) It is desirable that no two attributes across all entity types have the same name.
A)True
B)False
Answer: True
Q2) An entity that associates the instances of one or more entity types and contains attributes specific to the relationships is called a(n):
A) associative entity.
B) build entity.
C) gateway entity.
D) smush entity.
Answer: A
Q3) An attribute that can be broken down into smaller parts is called a(n) ________ attribute.
A) associative
B) simple
C) composite
D) complex
Answer: C
To view all questions and flashcards with answers, click on the resource link above.
4
Chapter 3: The Enhanced E-R Model
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20936
Sample Questions
Q1) The third step in the data modeling process with a packaged data model is:
A) rename identified data elements.
B) rename relationships.
C) map data to be used from package to data in current databases.
D) interview users.
Answer: C
Q2) Given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, Transmission
SUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, Transmission Truck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload
A) Define one vehicle entity type to hold all entities.
B) Define a separate entity type for each entity.
C) Define a supertype called vehicle and make each of the entities subtypes.
D) Keep only the Truck entity type.
Answer: A
Q3) A subtype can become a supertype if the subtype has other subtypes beneath it.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Logical Database Design and the Relational Model
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20937
Sample Questions
Q1) There can be multivalued attributes in a relation.
A)True
B)False
Q2) An attribute (or attributes) that uniquely identifies each row in a relation is called a:
A) column.
B) foreign field.
C) primary key.
D) duplicate key.
Q3) A primary key whose value is unique across all relations is called a(n):
A) global primary key.
B) inter-table primary key.
C) enterprise key.
D) foreign global key.
Q4) Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence.
A)True
B)False
Q5) Discuss the two major occasions when you benefit from using normalization.
Q6) Explain how subtype/supertype relationships are converted to relations.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Physical Database Design and Performance
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20938
Sample Questions
Q1) When would you use horizontal partitioning, and when would you use vertical partitioning?
Q2) An appropriate datatype for adding a sound clip would be:
A) VarChar.
B) Char.
C) Blob.
D) Date.
Q3) Denormalization almost always leads to more storage space for raw data.
A)True
B)False
Q4) A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers and join tables to prepare query results is the:
A) explain plan.
B) show optimization.
C) explain query.
D) analyze query.
Q5) Security is one advantage of partitioning.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Introduction to SQL
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20939
Sample Questions
Q1) A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.
A)True
B)False
Q2) The ORDER BY clause is the first statement processed in an SQL command.
A)True
B)False
Q3) What does the following SQL statement do? Delete from Customer_T Where state = 'HI';
A) Deletes all records from customer_t where the state is equal to HI
B) Removes the Customer_T table from the database
C) Deletes all records from the Customer_T table
D) Doesn't delete anything because of a syntax error
Q4) A database table is defined using the data definition language (DDL).
A)True B)False
Q5) The ALTER TABLE command is used to change a table definition.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Advanced SQL
Available Study Resources on Quizplus for this Chatper
107 Verified Questions
107 Flashcards
Source URL: https://quizplus.com/quiz/20940
Sample Questions
Q1) Dynamic SQL:
A) is used to generate appropriate SQL code on the fly as an application is processing.
B) is quite volatile.
C) is not used widely on the Internet.
D) creates a less flexible application.
Q2) Subqueries can only be used in the WHERE clause.
A)True
B)False
Q3) An interactive command that can be used to dynamically control a user session for appropriate integrity measures is:
A) rollback.
B) rollforward.
C) set autocommit.
D) expunge.
Q4) The advantages of SQL-invoked routines are flexibility, efficiency, shareability and applicability.
A)True
B)False
Q5) What can be done with Persistent Stored Modules?
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Database Application Development
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20941
Sample Questions
Q1) Java programs similar to applets that execute on the server are called hamlets.
A)True
B)False
Q2) ODBC is an application programming interface that provides a common language for application programs to access and process an SQL database independent of the particular RDBMS that is accessed.
A)True
B)False
Q3) Web services allow for communication between programs over the Internet.
A)True
B)False
Q4) The process of assigning parts of an application to a client or server is called application partitioning.
A)True
B)False
Q5) An XML Schema is a language used to define HTML.
A)True
B)False
Q6) Explain what stored procedures are and how they are used.
Q7) What are the components of a Web application?
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Data Warehousing
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20942
Sample Questions
Q1) When a dimension participates in a hierarchy, the database designer can normalize the dimension into a nested set of tables with 1:M relationships between them.
A)True
B)False
Q2) What are some approaches to handling slowly changing dimensions?
Q3) Logical data marts are physically separate databases from the enterprise data warehouse.
A)True
B)False
Q4) Organizations adopt data mart architectures because it is easier to have separate, small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.
A)True
B)False
Q5) Explain the four basic steps to build an independent data mart.
Q6) When would it be appropriate to use factless fact tables?
Q7) Scalable technology is critical to a data mart.
A)True
B)False
11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Data Quality and Integration
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20943
Sample Questions
Q1) Completeness means that all data that are needed are present.
A)True
B)False
Q2) What are the record-level data transformation functions?
Q3) Update mode is used to create a data warehouse.
A)True
B)False
Q4) In the ________ approach, one consolidated record is maintained, and all applications draw on that one actual "golden" record.
A) persistent
B) identity registry
C) federated
D) integration hub
Q5) One simple task of a data quality audit is to:
A) interview all users.
B) statistically profile all files.
C) load all data into a data warehouse.
D) establish quality metrics.
Q6) What are some of the errors and inconsistencies in data that the cleansing process is looking to rectify?
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Big Data and Analytics
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20944
Sample Questions
Q1) It is true that in an HDFS cluster the NameNode is the:
A) large number of slaves.
B) single master server.
C) language library.
D) business intelligence.
Q2) The oldest form of analytics is:
A) predictive analytics.
B) descriptive analytics.
C) prescriptive analytics.
D) comparative analytics.
Q3) ________ are not used for querying and analyzing data stored in data warehouses.
A) Word processing programs
B) OLAP tools
C) MOLAP tools
D) Dashboard tools
Q4) Descriptive, predictive, and ________ are the three main types of analytics.
A) adaptive
B) comparative
C) prescriptive
D) decisive
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Data and Database Administration
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/20945
Sample Questions
Q1) While views promote security by restricting user access to data, they are not adequate security measures because:
A) an unauthorized person may gain access to a view through experimentation.
B) all users can read any view.
C) a view's data does not change.
D) views are not possible to create in most DBMS.
Q2) A trigger can be used for security purposes to prohibit inappropriate actions, such as changing a salary value outside of a business day.
A)True
B)False
Q3) The Information Resource Lexicon System (IRLS) is a computer software tool used to manage and control access to the information repository.
A)True
B)False
Q4) The data administrator takes responsibility for the overall management of data resources.
A)True
B)False
Q5) What are some of the core roles of the traditional data administrator?
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Distributed Databases
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/20946
Sample Questions
Q1) What is data replication?
Q2) Which of the following factors in deciding on database distribution strategies is related to autonomy of organizational units?
A) Organizational forces
B) Frequency of data access
C) Reliability needs
D) Organizational development
Q3) In a heterogeneous environment, not all users use the same DBMS.
A)True
B)False
Q4) What are the three different kinds of transparencies used in distributed database management systems?
Q5) Simple paths to other databases without the benefits of one logical database are called:
A) freeways.
B) parkways.
C) gateways.
D) highways.
Q6) What are the functions of a distributed DBMS?
Q7) What is the difference between a local transaction and a global transaction?
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Object-Oriented Data Modeling
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20947
Sample Questions
Q1) When specifying a business rule between graphical symbols, a ________ is drawn from one element to the other.
A) dashed arrow
B) dashed asterisk
C) highlighted union
D) highlighted intersect
Q2) Which of the following is a function or service provided by all instances of a class?
A) Operation
B) Implementation
C) Class group
D) Query
Q3) Each role has a duplicity, which indicates how many objects participate in a given relationship.
A)True
B)False
Q4) The object-oriented systems development cycle consists of four phases.
A)True
B)False
Q5) What is the purpose of a constructor operation?
To view all questions and flashcards with answers, click on the resource link above. Page 16