Data Modeling and Database Design
Exam Solutions
Course Introduction
This course explores the fundamental principles and practical techniques involved in data modeling and database design. Students will learn to analyze business requirements and translate them into effective data models using concepts such as Entity-Relationship (ER) diagrams, normalization, and relational schema design. The course covers the lifecycle of database development, including requirements gathering, conceptual, logical, and physical design, and the implementation of databases using SQL. Emphasis is placed on integrity constraints, data security, and best practices for creating scalable and efficient databases. Through hands-on projects and case studies, students will gain the skills necessary to design robust databases that support real-world applications.
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) What is a surrogate key and how does Microsoft Access 2013 create surrogate keys?
Answer: A surrogate key is usually a computer-generated unique number that serves as the identifier of each row in a table.Microsoft Access 2013 generates surrogate keys by using the Access AutoNumber data type.
Q2) Most organizations create and use their own database management system (DBMS)products.
A)True
B)False
Answer: False
Q3) Microsoft Access 2013 database files are stored using the ________ file extension. Answer: .accdb
Q4) The Microsoft Access 2013 application generator provides the ability to create and store forms,reports,and queries.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
Page 3
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) In SQL,the NOT keyword can be combined with the IN keyword to form the NOT IN condition for selecting values.
A)True
B)False
Answer: True
Q2) Microsoft Access can run QBE queries,but not SQL queries.
A)True
B)False
Answer: False
Q3) Given the table
CUSTOMER(CustID,Name,PhoneNumber,AccountBalance)
write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with 'S'.
Answer: SELECT Name,PhoneNumber FROM CUSTOMER
WHERE Name LIKE 'S%';
Q4) Using SQL commands,multiple tables can be queried using either subqueries or ________.
Answer: joins
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) Which of the following activities is not performed during the implementation phase of developing a database system?
A) Filling the database with data
B) Transforming the data model into a database design
C) Writing application programs
D) Creating forms
E) Creating reports
Q2) A(n)________ is a working demonstration of selected portions of the future system.
Q3) In crow's foot E-R notation,the crow's foot indicates a maximum cardinality of one. A)True
B)False
Q4) Microsoft Access 2013 uses banded form and report editors. A)True B)False
Q5) Use cases can be used to validate the data model,design,and implementation. A)True
B)False
Q6) Describe the use of Microsoft Access as a prototyping tool.
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) After getting data from a database,a PHP program needs to:
A) open the connection.
B) test the connection.
C) query the database.
D) process the query results.
E) close the connection.
Q2) XML stands for:
A) Experimental Markup Language.
B) Existential Markup Language.
C) Extendable Markup Language.
D) Extensible Markup Language.
E) Extensible Marketing Language.
Q3) ODBC stands for:
A) Open Database Compatibility.
B) Open Database Connectivity.
C) Open-source Database Compatibility.
D) Open-source Database Connectivity.
E) None of the above
Q4) When using Microsoft Access and IIS,the Web pages that access the database can be written using the ________ scripting language.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
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) Apache Cassandra is an example of a(n)________ non-relational DBMS.
Q2) Business Intelligence (BI)systems obtain data in ________ different ways.
Q3) Describe how to create an OLAP report for a Microsoft Access 2013 database in Microsoft Excel 2013.
Q4) Business Intelligence (BI)systems are information systems that help users analyze and use data.
A)True
B)False
Q5) What is a star schema?
Q6) 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.
Q7) Operational databases store historical data.
A)True
B)False
Q8) A dimensional database uses a(n)________. Page 10
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) To run an SQL script,click the ________ button on the Query Toolbar.
Q2) Describe how to create and run an SQL query in SQL Server 2014 Express.
Q3) Database objects are displayed in the Object Explorer window in the SQL Server Management Studio.
A)True
B)False
Q4) SQL Server 2014 uses ________ authentication by default.
Q5) What is an SQL script,and why are SQL scripts useful?
Q6) The name of the Microsoft SQL Server 2014 ODBC Client as it appears the ODBC Data Source Administrator is ________.
Q7) The Microsoft SQL Server 2014 Management Studio is included with Microsoft SQL Server 2014 Express Advanced.
A)True B)False
Q8) A new SQL Server database is created using the New Database dialog box. A)True B)False
Page 12
Q9) A new SQL Server database is created using the ________ dialog box.
Q10) An important reason for using SQL Server 2014 Express is that it has ________.
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) If T3 is a table with three columns C1,C2 and C3,where C1 is integer data,C2 is character data,and C3 is date data,which of the following would be the proper statement to have Oracle Database enter the date 02/10/14 into a row in table T3 while making sure that it is formatted correctly as shown?
A) SET INTO T3 VALUES (101, 'Smith', '02/10/14');
B) SET INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/14', 'DD/MM/YY'));
C) INSERT INTO T3 VALUES (101, 'Smith', '02/10/2014');
D) INSERT INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/14', 'DD/MM/YY'));
E) Any of the above will work correctly.
Q2) Oracle Database XE 11.2 is a Web-based Oracle Database administration utility.
A)True
B)False
Q3) Explain sequences and their relationship to surrogate keys.
Q4) The Oracle Database ODBC Client is installed ________ when Oracle Database 11g Release 2 is installed.
Q5) What is an SQL script,and why are SQL scripts useful?
Q6) The CurrVal method provides the current value in a sequence.
A)True
B)False
Q7) Oracle Database 11g Release 2 uses ________ to generate surrogate keys. 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) SQL query results are displayed:
A) in a tabbed results window.
B) in a tabbed Results1 window.
C) in a tabbed Document window.
D) in a tabbed Messages window.
E) in a tabbed Finished window.
Q2) The MySQL GUI tool is replaced by:
A) MySQL Query Browser.
B) MySQL Administrator.
C) My SQL Workbench.
D) Both A and B
E) All of the above
Q3) SQL statements can be run individually or as part of a related group of SQL statements known as a:
A) Result.
B) Resultset.
C) Script.
D) Scriptset.
E) Commandset.
Q4) MySQL 5.6 Server Community Edition uses ________ authentication.
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) SQL views contain their own data.
A)True
B)False
Q2) The SQL statement ________ is used to delete a view from a database.
Q3) The SQL keyword ________ can be used with SELECT statements retrieving view instances to sort the results of the SELECT.
Q4) SQL statements used to construct views cannot contain the WHERE clause.
A)True
B)False
Q5) A stored program that is stored within the database and compiled when used is called a trigger.
A)True
B)False
Q6) The SQL command ________ is used to create a virtual table.
Q7) The Oracle DBMS supports the SQL BEFORE trigger.
A)True
B)False
Q8) Microsoft Access ________ can use previously stored view equivalent Access queries the same way an SQL SELECT statement uses SQL views.
To view all questions and flashcards with answers, click on the resource link above. Page 16
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) Databases are created in a DBMS during the implementation step.
A)True
B)False
Q2) Databases are created in a DBMS during the ________ step.
Q3) A business process is a set of activities that transforms materials into products.
A)True
B)False
Q4) Which of the following is not included in Michael Porter's list of support activities?
A) Technology management
B) Customer service
C) Human resources management
D) Firm infrastructure management
E) All of above are considered support activities.
Q5) Systems analysis and design is the process of creating and maintaining information systems.
A)True
B)False
Q6) The classic systems analysis methodology is called the ________.
To view all questions and flashcards with answers, click on the resource link above. Page 17
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,the Crow's Foot Database Notation stencil objects include a Recursive Relationship object.
A)True
B)False
Q2) In Microsoft Visio 2013,which object can be formatted with the line end symbols needed to create IE Crow's Foot notation?
A) Dynamic connector object
B) Relationship connector object
C) Category object
D) Parent to category connector object
E) Category to child connector object
Q3) In Microsoft Visio 2013,the Crow's Foot Database Notation stencil objects include:
A) an Entity object.
B) a Relationship object.
C) a Dynamic connector object.
D) A and B
E) A, B, and C
Q4) In Microsoft Visio 2013,how do we create database designs?
Q5) 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 are built using a Microsoft Access ________.
Q2) A Microsoft Access 2013 switchboard provides networking capabilities in Microsoft Access 2013.
A)True
B)False
Q3) 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
Q4) Microsoft Access 2013 switchboards use ________ to allow users to implement application actions.
Q5) Microsoft Access 2013 command buttons are created using the Command Button Wizard.
A)True
B)False
Q6) When using Microsoft Access 2013,how do we create a switchboard?
Q7) Microsoft Access 2013 switchboards build command buttons by using the
Q8) Microsoft Access 2013 switchboards use ________ to place text on switchboards. Page 19
To view all questions and flashcards with answers, click on the resource link above.
Page 20
Chapter 16: The Access Workbench-section Microsoft
Access
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/24882
Sample Questions
Q1) Below installing the NetBeans IDE,we have to install ________.
A) the Java JRE
B) the Java SDK
C) the Java JDK
D) the Java SRE
E) Any of the above will work.
Q2) For a workstation running the Windows operating system,a commonly used file system utility is Microsoft Internet Explorer.
A)True
B)False
Q3) The IIS Web server is managed using the Microsoft Internet Information Service (IIS)Manager.
A)True
B)False
Q4) 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
Q5) What is PHP?
Page 21
To view all questions and flashcards with answers, click on the resource link above.
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) Business Intelligence (BI)systems fall into two broad categories: ________ and ________.
Q2) In unsupervised data mining,explanations are created after patterns are found.
A)True
B)False
Q3) Market basket analysis is:
A) a data mart specific technique.
B) a reporting technique.
C) an RFM application.
D) an OLAP application.
E) a data mining technique.
Q4) A report that is sent to users on a predetermined schedule is called a push report.
A)True
B)False
Q5) In a common form of RFM analysis,customers are sorted into ________ groups and given an associated score depending on their group.
Q6) What is a star schema?
Q7) In RFM analysis,R stands for ________.
Q8) Data warehouse data is often stored in a(n)________. 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) Column family databases may use columns,super columns,column families and super column families.
A)True
B)False
Q2) XML documents that conform to their DTD are said to be ________.
A) DTD-valid
B) XML-valid
C) DTD-compliant
D) not-type-valid
E) type-valid
Q3) The CAP theorem defines the three properties,one of which is authorization.
A)True
B)False
Q4) XML documents and XML Schemas are created in different languages.
A)True
B)False
Q5) What does NoSQL stand for,and what does it mean?
Q6) Graph databases are composed of three elements,one of which is the edge.
A)True
B)False
Page 24
To view all questions and flashcards with answers, click on the resource link above.