Database Design Review Questions
Course Introduction
Database Design introduces students to the fundamental principles and practices for creating effective and efficient databases. The course covers concepts including data modeling, relational theory, schema normalization, entity-relationship diagrams, and strategies for ensuring data integrity and security. Students will learn to analyze user requirements, design conceptual and physical database structures, and implement them using Structured Query Language (SQL). Emphasis is placed on real-world applications, enabling students to develop databases that support business processes and information systems.
Recommended Textbook
Database Concepts 8th Edition by David M. Kroenke
Available Study Resources on Quizplus
18 Chapters
1259 Verified Questions
1259 Flashcards
Source URL: https://quizplus.com/study-set/898
Page 2
Chapter 1: Getting Started
Available Study Resources on Quizplus for this Chatper
82 Verified Questions
82 Flashcards
Source URL: https://quizplus.com/quiz/17704
Sample Questions
Q1) Personal DBMS products,such as Microsoft Access,create a clear distinction between the DBMS and the database application.
A)True
B)False
Answer: False
Q2) There is no reason for serious database developers to learn many aspects of database processing technology because DBMS products like Microsoft Access hide these aspects.
A)True
B)False
Answer: False
Q3) Microsoft Access 2016 generates surrogate key values when the ________ data type is used.
Answer: AutoNumber
Q4) In the general division of labor between database applications and the DBMS,the application program formats the results of a query into a report.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: The Relational Model
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/17706
Sample Questions
Q1) When the primary key of one relation is placed into a second relation,it is called a
A) field key
B) referential integrity
C) foreign key
D) candidate key
E) relocated key
Answer: C
Q2) Normalization is the process of removing all functional dependencies from a relation.
A)True
B)False
Answer: False
Q3) A key that contains more than one attribute is called a(n)________.
A) composite key
B) complex key
C) multi-key
D) n-key
E) candidate key
Answer: A
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Structured Query Language
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/17708
Sample Questions
Q1) The SQL keyword(s)________ mean(s)that a value must be supplied before a new row can be created.
Answer: NOT NULL
Q2) SQL stands for ________.
Answer: Structured Query Language
Q3) One way to specify all of the columns of a table is to use the special character * after the SQL keyword ________.
Answer: SELECT
Q4) Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field?
A) SORT BY Department
B) REVERSE Department
C) ORDER BY Department DESC
D) SORT BY Department DESC
E) SORT BY Department REVERSE
Answer: C
Q5) The SQL command used to add new data to a table is ________.
Answer: INSERT
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Data Modeling and the Entity Relationship Model
Available Study Resources on Quizplus for this Chatper
83 Verified Questions
83 Flashcards
Source URL: https://quizplus.com/quiz/17710
Sample Questions
Q1) In crow's foot style E-R diagrams,a single entity together with a related set of entities that each contain specific sets of attributes related to the single entity represent
A) a strong entity relationship
B) an ID-dependent weak entity relationship
C) a non-ID-dependent weak entity relationship
D) a supertype /subtype relationship
E) a recursive entity relationship
Q2) It is possible for an entity to have a relationship to itself.
A)True
B)False
Q3) There is usually only one instance of an entity in an entity class.
A)True
B)False
Q4) Microsoft Access is only used to prototype databases where Microsoft Access itself will be the final DBMS.
A)True
B)False
Q5) Explain the ambiguity in the broad definition of a weak entity.
Q6) ________ can be used to build prototype databases.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Database Design
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/17712
Sample Questions
Q1) The first step of database design is to define a table for each ________.
Q2) What relationship pattern is illustrated in the following schema?
PRODUCT (ProductID,Description)
SUPPLIER (SupplierID,ContactName,PhoneNumber)
PRODUCT_SUPPLIER (ProductID,SupplierID,Cost)
ProductID in PRODUCT_SUPPLIER must exist in ProductID in PRODUCT SupplierID in PRODUCT_SUPPLIER must exist in SupplierID in PRODUCT
A) Association relationship
B) Intersection relationship
C) Recursive relationship
D) Strong entity relationship
E) Supertype/subtype relationship
Q3) In certain circumstances,there may be a preference as to which table in a 1:1 relationship contains the foreign key.
A)True
B)False
Q4) By default,Microsoft Access creates 1:1 relationships between tables.
A)True
B)False
Q5) As far as Microsoft Access is concerned,there are no ________.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Database Administration
Available Study Resources on Quizplus for this Chatper
78 Verified Questions
78 Flashcards
Source URL: https://quizplus.com/quiz/17714
Sample Questions
Q1) An ACID transaction is one that is all but ________.
A) atomic
B) consistent
C) isolated
D) durable
E) guaranteed
Q2) Transaction results are kept in a(n)________,which contains records of the data changes in chronological order.
Q3) The recovery method in which we undo the changes that erroneous or partially processed transactions have made in the database is called ________ recovery.
Q4) What is the least restrictive isolation level that will prevent dirty reads?
A) Read Committed
B) Serializable
C) Read Uncommitted
D) Atomic Read
E) Repeatable Read
Q5) What is the difference between authentication and authorization?
Q6) Briefly explain the strategy of two-phased locking.
Q7) Microsoft Access 2016 can secure database files by storing them in a(n)________.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Database Processing Applications
Available Study Resources on Quizplus for this Chatper
84 Verified Questions
84 Flashcards
Source URL: https://quizplus.com/quiz/17716
Sample Questions
Q1) A commonly used Web server on servers running the Linux operating system is
Q2) Which of the following is a function performed by the driver manager in ODBC?
A) Submit SQL statements to the data source.
B) Determine the type of DBMS that processes a given ODBC data source.
C) Load the appropriate ODBC driver into memory.
D) Convert data source error codes into ODBC error codes.
E) Both B and C
Q3) When using Microsoft Access and IIS,the connection to the Access database must be provided by using a(n)________.
Q4) XML allows a programmer to ________.
A) define elements
B) use only predefined elements
C) use only "shrink-warped," purchased programs
D) loosely define the structure of a document
E) Both A and B
Q5) In general,the best type of ODBC data source that can be defined for a Web application is a system data source.
A)True
B)False
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Data Warehouses,Business Intelligence
Systems,and Big Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/17718
Sample Questions
Q1) A data mart is a collection of data that addresses a particular component or functional area of a business.
A)True
B)False
Q2) What is a reporting system?
Q3) Problematic data are called ________.
Q4) When distributed databases create copies of the database on different servers,this is known as ________.
A) replication
B) partitioning
C) disbursing
D) distributed two-phase locking
E) division
Q5) Non-relational DBMSs associated with the NoSQL movement include all of the following except ________.
A) Key-value
B) Document
C) Column family
D) Graph
E) Hierarchical
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Learn how to create a database in SQL Server
Available Study Resources on Quizplus for this Chatper
43 Verified Questions
43 Flashcards
Source URL: https://quizplus.com/quiz/17703
Sample Questions
Q1) To start working with SQL Server 2016 in Windows 10,use the command Start | All Apps | Microsoft SQL Server 2016 | Microsoft SQL Server Management Studio. A)True B)False
Q2) To create a new SQL query,click the New Query button. A)True
B)False
Q3) Users can click the ________ button to enable or disable the SQL editor windows set of outlining and auto-completion features.
Q4) Describe why SQL Server 2016 is sensitive to certain words being used in SQL commands or scripts,and what to do about it.
Q5) The ________ edition is a free,single-user version of the Enterprise Edition.
Q6) The Microsoft SQL Server 2016 Management Studio is included with Microsoft SQL Server 2016 Express Advanced. A)True B)False
Q7) SQL query results are displayed in a tabbed ________ window.
Q8) To create a new SQL query,click the ________ button.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Learn how to create a database in Oracle
Database XE 11g Release 2
Available Study Resources on Quizplus for this Chatper
52 Verified Questions
52 Flashcards
Source URL: https://quizplus.com/quiz/17705
Sample Questions
Q1) Which method returns the next value in a sequence?
A) CountVal
B) Next
C) UpVal
D) NextVal
E) Append
Q2) Explain sequences and their relationship to surrogate keys.
Q3) Which of the following tasks can be done using the Oracle SQL Developer?
A) See the structure of a table
B) Add and remove columns from a table
C) Insert and delete data from a table
D) Both A and B
E) A, B and C
Q4) Oracle Database XE has no set maximum database size.
A)True
B)False
Q5) Describe how to create and run an SQL script in Oracle Database Express Edition 11g Release 2.
Q6) Oracle 12c is a/an ________ class DBMS.
Q7) Describe how to create and run an SQL query in Oracle Database XE 11g Release 2. Page 12
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 11: Learn how to create a database in MySQL 57
Community Server Edition
Available Study Resources on Quizplus for this Chatper
72 Verified Questions
72 Flashcards
Source URL: https://quizplus.com/quiz/17707
Sample Questions
Q1) To access documentation about the MySQL Workbench,use the ________.
A) Help | MySQL Workbench command
B) Help | Help Index command
C) Help | MySQL Website command
D) Help | MySQL.com Website command
E) Help | Documentation command
Q2) Describe how to set table properties in a MySQL Workbench database design.
Q3) To run an SQL script,click the ________ button on the MySQL Workbench toolbar.
Q4) To run an SQL script or SQL command in MySQL Server Community Edition
A) click the Execute button on the Query Toolbar
B) click the Execute button on the Browser Toolbar
C) click the Run button on the Query Toolbar
D) click the Run button on the Browser Toolbar
E) click the Execute SQL Script button on the Toolbar
Q5) MySQL 5.7 Server Community Edition uses ________ authentication.
Q6) Database objects are displayed in the ________ window in the MySQL Workbench.
Q8) MySQL ________ (version)Community Server Edition was generally available when this text was written. Page 14
Q7) Describe how to create and run an SQL script in MySQL 5.7 Community Server Edition.
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 12: Introduce the topic of importing Microsoft Excel
2016 data into a database table
Available Study Resources on Quizplus for this Chatper
84 Verified Questions
84 Flashcards
Source URL: https://quizplus.com/quiz/17709
Sample Questions
Q1) Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of all except ________.
A) increased network throughput
B) standardized processing
C) specialization among developers
D) less work
E) greater security
Q2) How are SQL views handled in Microsoft Access?
Q3) Stored procedures have the advantage of all choices except ________.
A) greater security
B) data integrity through distributed copies
C) SQL optimized by the DBMS compiler
D) code sharing
E) decreased network traffic
Q4) The SQL statement DROP VIEW ViewName is used to delete a view from a database.
A)True
B)False
Page 16
Q5) SQL views can be used to display the results of ________.
Q6) The SQL statement ________ is used to modify a view.
To view all questions and flashcards with answers, click on the resource link above.
Page 17
Available Study Resources on Quizplus for this Chatper
54 Verified Questions
54 Flashcards
Source URL: https://quizplus.com/quiz/17711
Sample Questions
Q1) Data is composed of recorded ________.
A) facts
B) numbers
C) information
D) Both A and B
E) A, B and C
Q2) Which of the following is not a component of a computer-based information system?
A) Hardware
B) Networking
C) Data
D) Procedures
E) Software
Q3) A business process is a set of activities that transforms materials into products.
A)True
B)False
Q4) Data models are created during the component design step.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 14: Learn how to create E-R data models in Microsoft Visio 2016
Available Study Resources on Quizplus for this Chatper
33 Verified Questions
33 Flashcards
Source URL: https://quizplus.com/quiz/17713
Sample Questions
Q1) In Microsoft Visio 2016,Relationship connector objects can be formatted with the line end symbols needed to create IE Crow's Foot notation.
A)True
B)False
Q2) In Microsoft Visio 2016,the data models in this book are created using ________.
A) the Chen's Database Notation template
B) the UML database Notation template
C) the IDEF1X Database Notation template
D) the Crow's Foot Database Notation template
E) the Wireframe Database Diagram template
Q3) In Microsoft Visio 2016,both data models and database designs are created using the Crow's Foot Database Notation template.
A)True
B)False
Q4) In Microsoft Visio 2016,the arrow end of the Dynamic connector object points to the table containing the primary key.
A)True
B)False
Q5) In Microsoft Visio 2016,how do we create data models?
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 15: Learn how to create Microsoft Access 2016 switchboards
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/17715
Sample Questions
Q1) Microsoft Access 2016 switchboards are built in a report window in Microsoft Access 2016.
A)True
B)False
Q2) Microsoft Access 2016 switchboards use ________ as part of the switchboard.
A) text buttons
B) report windows
C) wizard buttons
D) command buttons
E) form buttons
Q3) Microsoft Access 2016 command buttons are created using the Command Button Wizard.
A)True
B)False
Q4) Microsoft Access 2016 switchboards build command buttons by using the
Q5) Microsoft Access 2016 switchboards use ________ to allow users to implement application actions.
Q6) Microsoft Access 2016 switchboards use text labels as part of the menu. A)True B)False Page 20
To view all questions and flashcards with answers, click on the resource link above.
Page 21
Chapter 16: Know how to configure and update PHP
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/17717
Sample Questions
Q1) For a Web server running the Linux operating system,the most commonly used Web server is ________.
A) the IIS Web server
B) the Apache Web server
C) the Tomcat Web server
D) the ASP.NET Web server
E) the JSP Web server
Q2) For a workstation running the Windows operating system,the user file system permissions Modify and Write must be granted to the Users group at the wwwroot folder.
A)True
B)False
Q3) For a workstation running the Windows operating system,the user file system permissions Modify and Write must be granted to ________ at the wwwroot folder.
A) the ISUR_{WebServerName} User
B) the IAPP_{WebServerName} User
C) the WebUsers group
D) the Users group
E) None of the above is correct.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 17: Learn the basic concepts of business intelligence (BI)systems
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/17719
Sample Questions
Q1) Market basket analysis,as described in the text,uses the statistical technique of
Q2) Refer to the table above.What is the support for Drug A and Drug B?
A) .025
B) .075
C) .100
D) .125
E) .200
Q3) Refer to the table above.What is the lift for Drug B being purchased given that Drug A has been purchased?
A) .200
B) .250
C) .333
D) .500
E) .667
Q4) In a common form of RFM analysis,customers with an F score of ________ are in the 20% of customers who have the most frequent orders.
Q5) Why is operational data sometimes unusable for Business Intelligence purposes?
Q6) In RFM analysis,R stands for ________.
To view all questions and flashcards with answers, click on the resource link above. Page 23
Chapter 18: Learn about replicated partitioned data stores for supporting clusters
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/17720
Sample Questions
Q1) XSLT is a robust and powerful transformation language that can be used to materialize XML documents into HTML.
A)True
B)False
Q2) The use of the XML Schema expression minOccurs="0" ________.
A) is an XML Schema default
B) is required as there are no defaults in an XML Schema
C) is similar to the SQL schema NULL constraint
D) both A and C
E) both B and C
Q3) The XML Schema statement xmlns:xsd indicates that ________.
A) this XML Schema uses a labeled namespace called xsd
B) this XML Schema is validated at www.xsd.com
C) this XML Schema is validated at www.xmlns.com using the xsd XML Schema located there
D) this XML Schema is using a non-standard looping procedure, where xsd is the variable name of the loop increment
E) the value of the variable xmnls is being set equal to the value of the variable xsd
Q4) What is the CAP theorem,and what does it show?
To view all questions and flashcards with answers, click on the resource link above. Page 24