Database Design Exam Solutions
Course Introduction
Database Design explores the principles and methodologies essential for effective database modeling and implementation. Students will learn to analyze data requirements, create Entity-Relationship diagrams, and translate data models into well-structured relational schemas. The course covers normalization techniques to ensure data integrity, as well as the use of Structured Query Language (SQL) for database creation and manipulation. Attention is given to database life cycle, security considerations, and the emerging trends in database technologies, preparing students to develop robust databases adaptable to real-world applications.
Recommended Textbook
Database Processing Fundamentals Design and Implementation 14th Edition by
Available Study Resources on Quizplus
25 Chapters
1978 Verified Questions
1978 Flashcards
Source URL: https://quizplus.com/study-set/2437
Page 2
David M. Kroenke
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/48385
Sample Questions
Q1) The purpose of a database is to ________.
A)help people keep track of things
B)store data in tables
C)create tables of rows and columns
D)maintain data on different things in different tables
Answer: A
Q2) Microsoft Access is just a DBMS.
A)True
B)False
Answer: False
Q3) Enterprise Resource Planning (ERP)is an example of a data mining application.
A)True
B)False
Answer: False
Q4) Which of the following is not an XML Web service standard?
A)SOAP
B)WSDL
C)Ethernet
D)UDDI
Answer: C
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Introduction to Structured Query Language
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/48388
Sample Questions
Q1) The built-in function SUM can be used with any column.
A)True
B)False
Answer: False
Q2) The INTERSECT of two relations A and B consists of all rows that are in relation B but are not in relation A.
A)True
B)False
Answer: False
Q3) Two or more tables are joined by giving the table names in the WHERE clause and specifying the equality of the respective column names as a condition in the GROUP BY clause.
A)True
B)False
Answer: False
Q4) The SQL built-in function ADDUP totals values in numeric columns.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Relational Model and Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/48391
Sample Questions
Q1) A deletion anomaly exists when deleting data about one entity results in the loss of data about another entity.
A)True
B)False
Answer: True
Q2) In general,each relation should have ________.
A)one and only one theme
B)one or more themes
C)exactly two themes
D)one or two themes
Answer: A
Q3) If a relation is in BCNF,and each multivalued dependency has been moved to a relation of its own,then the first relation is in ________.
A)Third Normal Form
B)Boyce-Codd Normal Form
C)Fourth Normal Form
D)Domain/key normal form
Answer: C
To view all questions and flashcards with answers, click on the resource link above.
5
Chapter 4: Database Design Using Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/48393
Sample Questions
Q1) The advantages of normalization include ________.
A)the elimination of modification anomalies
B)the elimination of duplicated data
C)more complex SQL for multitable subqueries and joins
D)simpler SQL queries
Q2) Reviewing the work done on a table that was created using existing data from multiple sources,you find that a column named Remarks has been included,and it is populated with inconsistent and verbose verbal data.This is an example of ________.
A)the multivalued,multicolumn problem
B)the inconsistent values problem
C)the missing values problem
D)the general-purpose remarks column problem
Q3) A defining requirement for BCNF is that every determinant must be a candidate key. A)True
B)False
Q4) Describe the steps in assessing table structure when you are given a set of tables and asked to construct a new database to store the existing data.
Q5) What are inconsistent values,and why are they a problem?
To view all questions and flashcards with answers, click on the resource link above.
Page 6
Chapter 5: Data Modeling With the Entity-Relationship
Model
Available Study Resources on Quizplus for this Chatper
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/48395
Sample Questions
Q1) The characteristics of a thing are described by its ________.
A)identifiers
B)entities
C)objects
D)attributes
Q2) You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above.What does the symbol next to the CUSTOMER entity indicate?
A)A maximum cardinality of "zero"
B)A maximum cardinality of "one"
C)A minimum cardinality of "optional"
D)A minimum cardinality of "required"
Q3) An identifier of an entity instance is one or more attributes that name or identify entity instances.
A)True
B)False
Q4) In a 1:N relationship,the parent entity is on the one side of the relationship,and the child entity is on the many side of the relationship.
A)True
B)False
7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Transforming Data Models Into Database Designs
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/48397
Sample Questions
Q1) When the child entity is required (M)in a relationship,there needs to be at least one child row for each parent row at all times.
A)True
B)False
Q2) Whether or not an attribute is required is determined during the database modeling phase.
A)True
B)False
Q3) What is an association relationship and how does it differ from an N:M relationship?
Q4) When transforming an ID-dependent E-R data model relationship into a relational database design and the parent entity has a surrogate primary key and the child entity has a data identifier,then the primary key of the child table should be ________.
A)the parent's surrogate key + the child's data key
B)the parent's surrogate key + a surrogate key in the child
C)either A or B will work,but method A is preferable
D)either A or B will work,but method B is preferable
Q5) What are MUST NOT and MUST COVER constraints?
Page 8
Q6) 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.
Chapter 7: SQL for Database Construction and Application Processing
Available Study Resources on Quizplus for this Chatper
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/48399
Sample Questions
Q1) What is embedded SQL,and what considerations are necessary when using it in an application?
Q2) SQL views are constructed from ________.
A)CREATE statements
B)INSERT statements
C)UPDATE statements
D)SELECT statements
Q3) SQL views are not used ________.
A)to hide columns
B)to show results of computed columns
C)to hide complicated SQL statements
D)to enforce primary key constraints
Q4) The SQL keyword DELETE is used to delete a table's structure.
A)True
B)False
Q5) Distinguish between Char and VarChar data types.Include examples and tradeoffs.
Q6) SQL triggers can be used when the DBMS receives an update request.
A)True
B)False
Q7) Explain the essential format of the CREATE TABLE statement. Include an example. Page 9
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 8: Database Redesign
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/48401
Sample Questions
Q1) In a real sense,information systems and organizations do not just influence each other,but rather they create each other.
A)True B)False
Q2) Converting date,money,or other more specific data types to char or varchar will usually succeed.
A)True B)False
Q3) To drop a constraint,no preliminary steps are needed and we can simply use the ALTER TABLE DROP CONSTRAINT statement.
A)True
B)False
Q4) The authors refer to the data model produced by reverse engineering as the RE data model.
A)True B)False
Q5) What is the process for adding a NOT NULL column to a table?
Q6) Discuss workable data conversion and possible data loss when changing column data types during a database redesign.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Managing Multiuser Databases
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/48403
Sample Questions
Q1) A transaction is sometimes called atomic because it is performed as a unit.
A)True
B)False
Q2) When two transactions are being processed against the database at the same time ________.
A)they are called concurrent transactions
B)they are usually interleaved
C)they always result in a lost update problem
D)Both A and B are correct
Q3) When a transaction reads a row that has been changed,but the change has not been committed,this is known as a ________.
A)Clean read
B)Dirty read
C)Nonrepeatable read
D)Phantom read
Q4) Rollforward is a method of database recovery that restores the database save and all valid transactions since the save was reapplied.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Managing Databases With SQL Server 2014
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/48383
Sample Questions
Q1) In SQL Server,SCROLL_LOCK is a version of pessimistic locking.
A)True
B)False
Q2) Explain SQL Server indexes.
Q3) The default cursor concurrency for a dynamic cursor in SQL Server is optimistic.
A)True
B)False
Q4) A view may not be assigned to a(n)________.
A)BEFORE trigger
B)INSTEAD OF trigger
C)CONCURRENT trigger
D)AFTER trigger
Q5) In SQL Server,the full recovery model creates a log entry for every change to the database.
A)True
B)False
Q6) SQL Server built-in system function names start with the @@ symbol. A)True
B)False
Q7) Briefly explain the different SQL Server recovery models.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 11: Managing Databases With Oracle Database
Available Study Resources on Quizplus for this Chatper
106 Verified Questions
106 Flashcards
Source URL: https://quizplus.com/quiz/48386
Sample Questions
Q1) Each Oracle Database tablespace has one or more datafiles associated with it.
A)True
B)False
Q2) You can use the Edit Table table editor to create an index in Oracle Database.
A)True
B)False
Q3) Oracle Database uses the SQL ALTER TABLE command to change the structure of a table.
A)True
B)False
Q4) Which of the following is a GUI tool for application development with Oracle Database?
A)The Oracle Enterprise Manager Database Express
B)The Oracle SQL*Plus command utility program
C)The Oracle SQL Developer
D)The Oracle Database Configuration Assistant
Q5) If you include a slash as the last line in an Oracle stored procedure,the procedure will be compiled and stored when you run the block of code.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: Managing Databases With Mysql 56
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/48389
Sample Questions
Q1) Which trigger type(s)does MySQL support?
A)BEFORE
B)AFTER
C)INSTEAD OF
D)Both A and B are correct
Q2) The MySQL Table Editor is accessible from the MySQL Workbench.
A)True
B)False
Q3) A new MySQL database is created using the New Database dialog box. A)True
B)False
Q4) MySQL users are created on the Users and Privileges page in the MySQL Workbench. A)True B)False
Q5) What is the MySQL Table Editor?
Q6) MySQL restores are run on the Restore from Disk tab of the Data Export and Restore page. A)True B)False
Q7) Describe how to create a new database in MySQL Community Edition.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: The Web Server Environment
Available Study Resources on Quizplus for this Chatper
128 Verified Questions
128 Flashcards
Source URL: https://quizplus.com/quiz/48405
Sample Questions
Q1) If a server is using a Microsoft Windows operating system,it is usually running Internet Information Server (IIS)as its Web server.
A)True
B)False
Q2) Applet bytecode is transmitted to the user's computer via ________.
A)the JDBC driver
B)the Java virtual machine
C)HTTP
D)the bytecode interpreter
Q3) Which of the following is true about JSP code?
A)It must be written in Java or JavaScript.
B)It does not have access to HTTP functionality.
C)It must be coded as complete Java classes and methods.
D)It is automatically converted into Java servlets.
Q4) ADO is accessible from languages such as C++ and C#,but not Visual Basic or scripting languages.
A)True
B)False
Q5) Explain the process by which JSP pages are compiled.
Q6) Distinguish among the four types of JDBC drivers.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Big Data, Data-Warehouses, and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
108 Verified Questions
108 Flashcards
Source URL: https://quizplus.com/quiz/48407
Sample Questions
Q1) Dimensional databases are used to track historical data,and therefore must have a(n)________.
A)time dimension
B)customer dimension
C)sales dimension
D)order dimension
Q2) OLAP provides the ability to sum,count,average,and perform other simple arithmetic operations on groups of data.
A)True
B)False
Q3) DBMSs associated with the NoSQL movement are often known as ________.
A)RDBMSs
B)OODBMSs
C)SSDBMSs
D)structured storage
Q4) Structured storage column families are indistinguishable from relational database tables.
A)True
B)False
Q5) What is a conformed dimension?
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 15: Getting Started With Microsoft Access 2013
Available Study Resources on Quizplus for this Chatper
53 Verified Questions
53 Flashcards
Source URL: https://quizplus.com/quiz/48384
Sample Questions
Q1) To open a new Microsoft Access Query window,click the Query Design button on the Create command.
A)True
B)False
Q2) Explain how to run an SQL query in Microsoft Access.
Q3) Microsoft Access wizards allow easy building of forms and reports.
A)True
B)False
Q4) The Microsoft Access data type of AutoNumber is used when there is a specific need for a ________.
A)foreign key
B)primary key
C)surrogate key
D)secondary key
Q5) In Microsoft Access,the primary key must be set as a field property while the table is in Design View.
A)True
B)False
Q6) What is the Microsoft Office Fluent User Interface?
Q7) Describe the tabbed Ribbon.
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 16: Getting Started With Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/48387
Sample Questions
Q1) Which of the following is not included in Michael Porter's list of primary or operational activities?
A)Procurement
B)Inbound logistics
C)Manufacturing operations
D)Outbound logistics
Q2) One definition of information is knowledge derived from data.
A)True
B)False
Q3) How does Michael Porter define support business activities? What do they include?
Q4) Information systems are used to support business processes.
A)True
B)False
Q5) Database designs are created during the component design step.
A)True
B)False
Q6) What activities take place during the component design step of the systems development life cycle (SDLC)?
To view all questions and flashcards with answers, click on the resource link above. Page 19
Q7) What are the five steps or stages of the systems development life cycle (SDLC)?
Chapter 17: E-R Diagrams and the IDEF1X Standard
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/48390
Sample Questions
Q1) In IDEF1X,extended E-R model supertype entities are called ________.
A)generic entities
B)category entities
C)nonspecific entities
D)category clusters
Q2) IDEF1X identifying connection relationships correspond to ID-dependent relationships in the extended E-R model.
A)True
B)False
Q3) The IDEF1X standard excludes the concept of domains found in the extended E-R model.
A)True
B)False
Q4) Extended E-R model 1:1 relationships are called nonidentifying connection relationships in IDEF1X.
A)True
B)False
Q5) IDEF1X entities are the same as the entities in the extended E-R model.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 18: E-R Diagrams and the UML Standard
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/48392
Sample Questions
Q1) In UML notation,the relationship line in a relationship between two strong entities is labeled as ________.
A)<persistent> B)<identifying> C)<nonidentifying> D)There is no label used.
Q2) What is OOP persistence,and how is it indicated in UML-style E-R diagrams?
Q3) Which of the following would indicate a minimum cardinality of 1 and a maximum cardinality of many in UML notation?
A)1:N
B)1 ..N
C)1 ..*
D)1:*
Q4) In UML-style E-R diagrams,a weak entity is shown by placing a filled-in diamond on the parent of the weak entity.
A)True
B)False
Q5) What cardinality format is used in UML-style E-R diagrams?
Q6) How are entity classes drawn in UML-style E-R diagrams?
Page 21
To view all questions and flashcards with answers, click on the resource link above.
Chapter 19: Getting Started With Mysql Workbench Data
Modeling Tools
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/48394
Sample Questions
Q1) In Windows,to use MySQL Workbench to create database designs,you must log into MySQL using ________.
A)the Connect to Database dialog box
B)the Connect to MySQL Server dialog box
C)the MySQL | Connect to Server command
D)No login is required
Q2) In the MySQL Table Editor,the abbreviation for Primary Key is ________.
A)PK
B)NN
C)UQ
D)AI
Q3) To add a table to a database design,click the Place a New Table button,move the cursor to the diagram area and click the left mouse button.
A)True
B)False
Q4) By default,the E-R diagrams created in the MySQL Workbench use ________.
A)IE Crow's Foot notation
B)IDEF1X notation
C)UML notation
D)Microsoft Visio 2013 Arrow notation
To view all questions and flashcards with answers, click on the resource link above. Page 22
Chapter 20: Getting Started With Microsoft Visio 2013
Available Study Resources on Quizplus for this Chatper
32 Verified Questions
32 Flashcards
Source URL: https://quizplus.com/quiz/48396
Sample Questions
Q1) In Microsoft Visio 2013,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
Q2) In Microsoft Visio 2013,clicking the FILE command tab opens ________.
A)the File menu
B)the Backstage view
C)the Open dialog box
D)the Save As dialog box
Q3) In Microsoft Visio 2013,we can create data models using ________.
A)Entity and Dynamic connector objects
B)Entity and Relationship connector objects
C)Category and Dynamic connector objects
D)We cannot create data models in Microsoft Visio 2013.
Q4) In Microsoft Visio 2013,Relationship connector objects can be formatted with the line end symbols needed to create IE Crow's Foot notation.
A)True
B)False
Q5) In Microsoft Visio 2013,how do we create database designs?
Page 23
To view all questions and flashcards with answers, click on the resource link above.
Chapter 21: Data Structures for Database Processing
Available Study Resources on Quizplus for this Chatper
39 Verified Questions
39 Flashcards
Source URL: https://quizplus.com/quiz/48398
Sample Questions
Q1) Simple networks can be represented by using ________.
A)indexes or linked lists
B)linked lists or sequential lists
C)sequential lists or indexes
D)complex networks
Q2) What is a linked list?
Q3) A multilevel index that allows both sequential and direct processing of data records is called a C-tree.
A)True
B)False
Q4) In a B-Tree whose top entry contains the values 47 and 88,the middle arrow allows access to all records whose key field values are ________.
A)less than 47
B)greater than 47 and less than 88
C)greater than 47 and less than or equal to 88
D)greater than 88
Q5) A tree structure cannot be represented using indexes.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 24
Chapter 22: the Semantic Object Model
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/48400
Sample Questions
Q1) A compound object is a semantic object that contains at least one ________.
A)single-value,group attribute
B)multi-value,simple or group attribute
C)object attribute
D)multi-value attribute
Q2) Which of the following statements about Subtype objects is not true?
A)Subtypes can be Inclusive (an object may be more than one subtype).
B)Subtypes can be Exclusive (an object may only be one of the subtypes).
C)Subtypes can be Nested.
D)All relations between the parent and subtype are 1:N.
Q3) Semantic objects are grouped into ________.
A)composites
B)entities
C)objects
D)classes
Q4) Explain the concept of semantic objects as being a sufficient description.
Q5) Semantic objects represent the user's perceptions more closely than the E-R model.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 25
Chapter 23: Getting Started With Web Servers, PHP, and the
Netbeans IDE
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/48402
Sample Questions
Q1) The Java JRE is installed directly from the Java download page at ________.
A)www.oracle.com
B)www.jre.com
C)www.jdk.com
D)www.sun.com
Q2) For a workstation running the Windows operating system,all the necessary user file system permissions to the Web page area are already granted.
A)True
B)False
Q3) The delimiters for embedding PHP code in a web page are ________.
A){ and }
B)<php and /php>
C)<?php and ?> D){php and ?}
Q4) What additional permissions must be assigned before a user can work with files on the IIS Web server?
Q5) What is theNetBeans IDE?
Q6) What are the Java JVM,JRE,SDK,and NetBeans? How do they relate?
Q7) What is PHP?
To view all questions and flashcards with answers, click on the resource link above. Page 26
Chapter 24: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
82 Verified Questions
82 Flashcards
Source URL: https://quizplus.com/quiz/48404
Sample Questions
Q1) Market basket analysis is a data mining technique for determining which sets of products customers tend to purchase at the same time.
A)True
B)False
Q2) What is a reporting system?
Q3) Refer to the table above.What is the support for Drug A and Drug B?
A).025
B).075
C).100
D).125
Q4) Report management defines who gets the report,how often,and how it is to be delivered.
A)True
B)False
Q5) Which of the following is (are)true about data mining applications?
A)They use sophisticated mathematical techniques.
B)They use sophisticated statistical techniques.
C)Their report delivery is more difficult than report delivery for reporting systems.
D)Both A and B are correct
To view all questions and flashcards with answers, click on the resource link above. Page 27
Chapter 25: Big Data
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/48406
Sample Questions
Q1) Column family databases may use columns,super columns,column families,and super column families.
A)True
B)False
Q2) In a column family database,the unit of data that most closely corresponds to a relation is the ________.
A)column
B)timestamp
C)column family
D)keyspace
Q3) JSON has sophisticated data structuring capabilities.Which of the following statements is not true about JSON?
A)A value can be a simple value such as a string or number.
B)A value can be an object (a set of [field,value] pairs).
C)A value can be an array of objects.
D)A value can be a relational table.
Q4) What is XML,and why is it significantly better than HTML?
Q5) Unlike SQL views,XML views are not limited to one multivalued path.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.