Database Design Review Questions
Course Introduction
Database Design introduces students to the fundamental principles and practices involved in designing robust and efficient database systems. The course covers key concepts such as data modeling, entity-relationship diagrams, normalization, and the relational model. Students learn how to translate real-world requirements into well-structured database schemas, understand the importance of data integrity and security, and are introduced to Structured Query Language (SQL) for database creation and manipulation. By the end of the course, students will be able to design and implement databases tailored to various organizational needs, ensuring scalability and optimal performance.
Recommended Textbook
Database Concepts 7th Edition by David M. Kroenke
Available Study Resources on Quizplus
18 Chapters
1205 Verified Questions
1205 Flashcards
Source URL: https://quizplus.com/study-set/1260 Page 2
Chapter 1: Getting Started
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24869
Sample Questions
Q1) Briefly describe the four components of a database system. Answer: The components of a database system are: (1)the users,(2)the application programs,(3)the DBMS,and (4)the database.The users are the people that will employ the system to input new data,modify existing data,and delete data in order to perform their jobs.The application programs are computer programs that act as intermediaries between the users and the DBMS.The application programs produce forms,reports,and queries; they also translate user actions into data management requests for the DBMS.The DBMS manipulates the database.It receives data management requests from the computer applications and translates them into read and write commands for the database.The database contains the actual user data that the users need to perform their jobs.
Q2) Relational database tables are commonly combined,queried,and processed using Structured Query Language (SQL).
A)True
B)False
Answer: True
Q3) The DBMS receives data update requests from the application program.
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
87 Verified Questions
87 Flashcards
Source URL: https://quizplus.com/quiz/24871
Sample Questions
Q1) To create a relationship in Microsoft Access,we drag and drop the ________ of a table.
Answer: primary key
Q2) Since surrogate keys are used to uniquely identify rows,their values are normally displayed prominently on all forms and reports for the users to see.
A)True
B)False
Answer: False
Q3) What requirements must a two-dimensional table satisfy in order to be a relation?
Answer: For a table to be considered a relation,it must meet several requirements.First,every cell must contain a single value.Second,there can be no duplicate rows.Third,each column must have a unique name.Fourth,the order of the columns must have no significance.Fifth,all values for a given column must be of the same type.Finally,the order of the rows must have no significance.
Q4) Every table is a relation,but not every relation is a table.
A)True
B)False
Answer: False
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
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/24873
Sample Questions
Q1) Using SQL commands,multiple tables can be queried using either subqueries or ________.
Answer: joins
Q2) Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.
A)True
B)False
Answer: False
Q3) The order of the columns returned by an SQL SELECT statement is determined by the:
A) ORDER BY clause.
B) SORT BY clause.
C) order they are listed in following SELECT.
D) order they are listed in following WHERE.
E) order they are listed in following FROM.
Answer: C
Q4) An SQL data type of ________ would indicate a variable-length character string with maximum length 75.
Answer: VarChar(75)
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
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24875
Sample Questions
Q1) Identifiers of an entity that are composed of two or more attributes are called ________ identifiers.
Q2) In crow's foot style E-R diagrams,a circle across the relationship line near an entity indicates:
A) a minimum cardinality of zero.
B) a minimum cardinality of one.
C) a maximum cardinality of one.
D) a maximum cardinality of many.
E) Both B and C
Q3) Microsoft Access 2013 can be used to prototype databases for ________.
Q4) Microsoft Access can be used to prototype databases for which of the following DBMS products?
A) Microsoft Access
B) SQL Server
C) MySQL
D) Oracle Database
E) All of the above
Q5) ________ can be used to build prototype databases.
Q6) How is minimum cardinality expressed in crow's foot E-R diagrams?
Q7) Relationships with the degree 2 are often called ________ relationships. Page 6
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: Database Design
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/24877
Sample Questions
Q1) Which of the following is the correct technique for representing a M:N relationship using the relational model?
A) An intersection relation is created, and the key of either entity is placed as a key in both the intersection relation and in the other relation.
B) An intersection relation is created with a surrogate key, which is placed in each of the parent entities.
C) An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation.
D) The key from either relation is placed as a foreign key in the other relation.
E) None of the above
Q2) What is denormalization and why can it be desirable?
Q3) Explain the representation of ID-dependent weak entities using the relational model.
Q4) To create a 1:1 relationship between two tables in Microsoft Access,the Indexed property of the foreign key column must be set to ________.
Q5) How are one-to-one recursive relationships addressed using the relational model?
To view all questions and flashcards with answers, click on the resource link above.
Page 8
Chapter 6: Database Administration
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24879
Sample Questions
Q1) Discuss Microsoft Access 2013 security administration.
Q2) When Microsoft Access 2013 compiles VBA code in a database,the database file will be a(n):
A) *.accdb file.
B) *.accdc file.
C) *.accde file.
D) *.mdb file.
E) *.mdw file.
Q3) What is the least restrictive isolation level that will prevent nonrepeatable reads?
A) Read Committed
B) Serializable
C) Read Uncommitted
D) Atomic Read
E) Repeatable Read
Q4) Only large database systems have a need for database administration.
A)True
B)False
Q5) Distinguish between reprocessing and rollforward as database recovery techniques.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 7: Database Processing Applications
Available Study Resources on Quizplus for this Chatper
82 Verified Questions
82 Flashcards
Source URL: https://quizplus.com/quiz/24881
Sample Questions
Q1) According to the ODBC standard,which of the following is not part of the specification of a data source?
A) The associated DBMS
B) The database
C) The driver
D) The operating system
E) The network platform
Q2) Extensible Markup Language (XML)is becoming a standard means for defining the structure of documents and for transmitting documents from one computer to another.
A)True
B)False
Q3) After trying to open a connection,a PHP connection to a DBMS needs to:
A) open the connection.
B) test the connection.
C) query the database.
D) process the query results.
E) close the connection.
Q4) NetBeans is a(n)________.
Q5) Briefly describe three types of triggers.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Big Data, data Warehouses, and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/24883
Sample Questions
Q1) OLAP provides the ability to sum,count,average and perform other simple arithmetic operations on groups of data.
A)True
B)False
Q2) To use the Access 2013 database in an Excel 2013 PivotTable,it is generally useful to:
A) create a view-equivalent query in Access to organize the data.
B) store the needed data in an Excel worksheet.
C) store the needed data in a Word document.
D) store the needed data in a PowerPoint slide show.
E) store the needed data in a Visio diagram.
Q3) Business Intelligence (BI)reporting systems can analyze data using standard SQL. A)True
B)False
Q4) Business Intelligence (BI)systems obtain data in ________ different ways.
Q5) To create an OLAP report for an Access 2013 database,use the ________ tool in Excel 2013.
Q6) In the MapReduce process,the Reduce step is followed by the Map step.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Getting Started With Microsoft Sql Server 2012
Available Study Resources on Quizplus for this Chatper
40 Verified Questions
40 Flashcards
Source URL: https://quizplus.com/quiz/24868
Sample Questions
Q1) Describe how to create and run an SQL query in SQL Server 2014 Express.
Q2) An important reason for using SQL Server 2014 Express is that it has ________.
Q3) Describe why SQL Server 2014 is sensitive to certain words being used in SQL commands or scripts,and what to do about it.
Q4) What is an SQL script,and why are SQL scripts useful?
Q5) To run an SQL script,click the ________ button on the Query Toolbar.
Q6) To start working with SQL Server 2014 Express in Windows 8.1,use the command Start | All Programs | Microsoft SQL Server 2014 | SQL Server management Studio Express. A)True
B)False
Q7) SQL query results are displayed in a tabbed ________ window.
Q8) SQL Server 2014 uses DBMS authentication by default. A)True
B)False
Q9) The Microsoft SQL Server 2014 Management Studio is included with Microsoft SQL Server 2014 Express Advanced. A)True
B)False
Page 12
Q10) SQL Server 2014 uses ________ authentication by default.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Getting Started With Oracle Database 11g
Release 2
Available Study Resources on Quizplus for this Chatper
43 Verified Questions
43 Flashcards
Source URL: https://quizplus.com/quiz/24870
Sample Questions
Q1) In SQL Developer,DBMS objects are displayed:
A) in the Navigation Pane.
B) in the Object Browser.
C) in the Connections area.
D) in the tabbed document window.
E) in the command tab.
Q2) 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) A and B
E) A, B and C
Q3) To run an SQL query,click the ________ button.
Q4) With Oracle Database,using a sequence does not guarantee valid surrogate key values.
A)True
B)False
Q5) To run an SQL script,click the ________ button.
Q6) Explain sequences and their relationship to surrogate keys.
Q7) Describe how to create and run an SQL script in Oracle Database 11g Release 2. Page 13
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 11: Getting Started With Mysql 56 Community Server
Available Study Resources on Quizplus for this Chatper
71 Verified Questions
71 Flashcards
Source URL: https://quizplus.com/quiz/24872
Sample Questions
Q1) MySQL Community Server 5.6 requires that the .NET Framework version 4.5.1 be installed.
A)True
B)False
Q2) 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.
Q3) In order to create MySQL EER diagrams,users must log into MySQL using the Connect to Database and the Connect to MySQL Server dialog boxes.
A)True
B)False
Q4) MySQL ________ (version)Community Server Edition was generally available when this text was written.
Q5) What is an SQL script,and why are SQL scripts useful?
Q6) SQL query results are displayed in a tabbed ________ window.
Q7) A new MySQL Server database is known as a new ________.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 12: James River Jewelry Project Questions
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/24874
Sample Questions
Q1) Which of the following is not an SQL trigger?
A) BEFORE UPDATE
B) INSTEAD OF UPDATE
C) BEFORE INSERT
D) INSTEAD OF CONSTRAINT
E) AFTER DELETE
Q2) When an SQL SELECT statement is used to retrieve data from a view instance,the maximum number of columns that can be specified in the SELECT is the same as the number of columns in the table underlying the view.
A)True
B)False
Q3) What are SQL stored procedures and how are they used?
Q4) SQL views can be used to layer ________.
Q5) Which of the following is an SQL trigger that Microsoft SQL Server supports?
A) BEFORE
B) INSTEAD OF
C) AFTER
D) B and C only
E) A, B, and C
Q6) The SQL command ________ is used to create a virtual table.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Sql Views
Available Study Resources on Quizplus for this Chatper
47 Verified Questions
47 Flashcards
Source URL: https://quizplus.com/quiz/24876
Sample Questions
Q1) How does Michael Porter define primary or operational business activities?
Q2) Data models are created during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
E) systems maintenance
Q3) User interviews are conducted during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
E) systems maintenance
Q4) Which of the following is a component of a computer-based information system?
A) Hardware
B) Software
C) Data
D) Procedures
E) All of the above
Q5) A computer-based information system has ________ components.
Page 17
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Getting Started in Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
34 Verified Questions
34 Flashcards
Source URL: https://quizplus.com/quiz/24878
Sample Questions
Q1) In Microsoft Visio 2013,we can create database designs using Entity and Dynamic connector objects.
A)True
B)False
Q2) When using Microsoft Visio 2013,how do we create a blank diagram for use with a data model?
Q3) In Microsoft Visio 2013,the Crow's Foot Database Notation stencil objects include a Category object.
A)True
B)False
Q4) In Microsoft Visio 2013,describe the possible cardinality settings for a Relationship object that can be set in the symbols menu in a database design,and how these settings correspond to the IE Crow's Foot symbols shown in Figure G-21.
Q5) In Microsoft Visio 2013,the arrow end of the Relationship connector object points to the table containing the foreign key.
A)True
B)False
Q6) In Microsoft Visio 2013,how do we create data models?
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 15: Getting Started With Microsoft Visio 2010
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/24880
Sample Questions
Q1) Microsoft Access 2013 switchboards use ________ to place text on switchboards.
Q2) Microsoft Access 2013 switchboards use ________ as part of the switchboard.
A) text labels
B) report labels
C) Wizard labels
D) database design labels
E) All of the above
Q3) Microsoft Access 2013 switchboards are built in a report window in Microsoft Access 2013.
A)True
B)False
Q4) Microsoft Access 2013 switchboards are built using a Microsoft Access ________.
Q5) When using Microsoft Access 2013,how do we create a switchboard?
Q6) Microsoft Access 2013 switchboards are built in a(n):
A) form window.
B) report window.
C) application window.
D) database design window.
E) All of the above
19
Q7) Microsoft Access 2013 switchboards build command buttons by using the
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: The Access Workbench-section
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/24882
Sample Questions
Q1) What is the Microsoft Web Platform Installer,and what are the advantages and disadvantages of using it to install PHP?
Q2) The PHP installation in the text installed version ________ of PHP.
Q3) Below installing the NetBeans IDE,we have to install the Java JDK.
A)True
B)False
Q4) NetBeans is an IDE.
A)True
B)False
Q5) The IIS Web server is managed using the Microsoft Internet Information Service (IIS)Manager.
A)True
B)False
Q6) What is PHP?
Q7) What is the NetBeans IDE? Page 20
To view all questions and flashcards with answers, click on the resource link above.
Page 21
Chapter 17: Getting Started With Web Servers, php, and the
Netbeans IDE
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/24884
Sample Questions
Q1) In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.
A)True
B)False
Q2) Which of the following is a reason that operational data are difficult to read?
A) Dirty data
B) Missing values
C) Non-integrated data
D) Both A and B
E) All of the above
Q3) Business Intelligence (BI)systems fall into two broad categories: ________ and ________.
Q4) What is a data warehouse?
Q5) What are Business Intelligence (BI)systems?
Q6) One Business Intelligence (BI)reporting system that uses extensions to SQL is:
A) cluster analysis.
B) OLAP.
C) regression analysis.
D) RFM analysis.
E) All of the above Page 22
To view all questions and flashcards with answers, click on the resource link above.
Page 23
Chapter 18: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
77 Verified Questions
77 Flashcards
Source URL: https://quizplus.com/quiz/24885
Sample Questions
Q1) NoSQL really stands for ________.
Q2) XML Schemas consist of elements,attributes,and properties.
A)True
B)False
Q3) Column family databases that use column families and super column families contain keyspaces.
A)True
B)False
Q4) XML stands for ________.
A) Experimental Markup Language
B) Extendable Markup Language
C) Extensible Markup Language
D) Active X-control Markup Language
E) Active X-control Management Language
Q5) Unlike SQL views,XML views are not limited to one multivalued path.
A)True
B)False
Q6) The default cardinality for elements in an XML Schema is ________.
Q7) In database/ XML applications,it is a recommended practice that ________ carry data,and that ________ carry metadata.
To view all questions and flashcards with answers, click on the resource link above. Page 24