Question 1

Unified Modeling Language (UML)has quickly replaced the E-R Model as the most popular technique for creating data models.

Accepted Answer

A) True 
 B)False  False

Question 2

Describe the use of Microsoft Access as a prototyping tool.

Accepted Answer

Prototyping a database allows users to validate the data model by demonstrating the consequences of data modeling decisions.Microsoft Access is a good tool to build prototype databases because of its ease of use.Microsoft Access database files can be easily copied to create multiple copies of a database,which allows a variety of data models to be created.Further,Microsoft Access wizards allow easy mock-ups of forms and reports for prototyping.Therefore,Microsoft Access is often used to build prototype databases regardless of whether or not Access itself will be the final DBMS.

Question 3

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the:

Accepted Answer

A) degree. 
B) recursive cardinality. 
C) minimum cardinality. 
D) maximum cardinality. 
E) ordinality. 
A) degree. 
B) recursive cardinality. 
C) minimum cardinality. 
D) maximum cardinality. 
E) ordinality. C

Question 4

In crow's foot style E-R diagrams,an entity class is represented by a(n)________.

Accepted Answer

The answer of In crow's foot style E-R diagrams,an entity...

Question 5

Subtype entities may be either exclusive or inclusive.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following activities is not performed during the implementation phase of developing a database system?

Accepted Answer

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 
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

Question 7

The E-R Model assumes that all instances of a given entity class have the same attributes.

Accepted Answer

A) True 
 B)False

Question 8

How is maximum cardinality expressed in crow's foot E-R diagrams?

Accepted Answer

The crow's foot E-R diagram notation use

Question 9

In crow's foot style E-R diagrams,a circle across the relationship line near an entity indicates:

Accepted Answer

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 
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

Question 10

The Microsoft Access 2013 form editor is a(n):

Accepted Answer

A) banded form editor. 
B) wizard-based form editor. 
C) ASCII form editor. 
D) WYSIWYG form editor. 
E) Web-based form editor. 
A) banded form editor. 
B) wizard-based form editor. 
C) ASCII form editor. 
D) WYSIWYG form editor. 
E) Web-based form editor.

Question 11

Microsoft Access is a good tool for creating mock-ups of forms and reports because:

Accepted Answer

A) the form and report generators do not exist within Access itself. 
B) Access forms and reports are very simplistic. 
C) Access wizards make it easy to create the forms and reports. 
D) Access has a version of Microsoft PowerPoint built into it to allow easy creation of PowerPoint slide shows. 
E) Access has a version of Microsoft Excel built into it to allow easy exporting of data to spreadsheets. 
A) the form and report generators do not exist within Access itself. 
B) Access forms and reports are very simplistic. 
C) Access wizards make it easy to create the forms and reports. 
D) Access has a version of Microsoft PowerPoint built into it to allow easy creation of PowerPoint slide shows. 
E) Access has a version of Microsoft Excel built into it to allow easy exporting of data to spreadsheets.

Question 12

The number of entity classes involved in a relationship is the cardinality of the relationship.

Accepted Answer

A) True 
 B)False

Question 13

In crow's foot E-R notation,a circle indicates a minimum cardinality of zero.

Accepted Answer

A) True 
 B)False

Question 14

A(n)________ is a working demonstration of selected portions of the future system.

Accepted Answer

The answer of A(n)________ is a working demonstration of selected...

Question 15

Microsoft Access 2013 uses banded form and report editors.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following would not be contained in a use case?

Accepted Answer

A) Inputs provided to the system to perform a task 
B) A description of a task the user wants to perform 
C) A prototype of the system performing a given task 
D) Outputs generated by the system in performing a given task 
E) All of the above would be contained in a use case. 
A) Inputs provided to the system to perform a task 
B) A description of a task the user wants to perform 
C) A prototype of the system performing a given task 
D) Outputs generated by the system in performing a given task 
E) All of the above would be contained in a use case.

Question 17

System requirements as documented by use cases,business rules,forms,reports,and queries are sufficient to design the database without using a formal data model.

Accepted Answer

A) True 
 B)False

Question 18

Microsoft Access 2013 can be used to build a prototype database,which allows users to validate the data model by demonstrating the consequences of data modeling decisions.

Accepted Answer

A) True 
 B)False

Question 19

Microsoft Access 2013 is only used to prototype databases where Microsoft Access itself will be the final DBMS.

Accepted Answer

A) True 
 B)False

Question 20

When developing a database system,the database is constructed during the implementation phase.

Accepted Answer

A) True 
 B)False

Unified Modeling Language (UML)has quickly replaced the E-R Model as the most popular technique for creating data models.

Describe the use of Microsoft Access as a prototyping tool.

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the:

In crow's foot style E-R diagrams,an entity class is represented by a(n)________.

Subtype entities may be either exclusive or inclusive.

Which of the following activities is not performed during the implementation phase of developing a database system?

The E-R Model assumes that all instances of a given entity class have the same attributes.

How is maximum cardinality expressed in crow's foot E-R diagrams?

In crow's foot style E-R diagrams,a circle across the relationship line near an entity indicates:

The Microsoft Access 2013 form editor is a(n):

Microsoft Access is a good tool for creating mock-ups of forms and reports because:

The number of entity classes involved in a relationship is the cardinality of the relationship.

In crow's foot E-R notation,a circle indicates a minimum cardinality of zero.

A(n)________ is a working demonstration of selected portions of the future system.

Microsoft Access 2013 uses banded form and report editors.

Which of the following would not be contained in a use case?

System requirements as documented by use cases,business rules,forms,reports,and queries are sufficient to design the database without using a formal data model.

Microsoft Access 2013 can be used to build a prototype database,which allows users to validate the data model by demonstrating the consequences of data modeling decisions.

Microsoft Access 2013 is only used to prototype databases where Microsoft Access itself will be the final DBMS.

When developing a database system,the database is constructed during the implementation phase.

Getting Started

The Relational Model

Structured Query Language

Database Design

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Exam 4: Data Modeling and the Entity Relationship Model

Unified Modeling Language (UML)has quickly replaced the E-R Model as the most popular technique for creating data models.

Describe the use of Microsoft Access as a prototyping tool.

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the:

In crow's foot style E-R diagrams,an entity class is represented by a(n)________.

Subtype entities may be either exclusive or inclusive.

Which of the following activities is not performed during the implementation phase of developing a database system?

The E-R Model assumes that all instances of a given entity class have the same attributes.

How is maximum cardinality expressed in crow's foot E-R diagrams?

In crow's foot style E-R diagrams,a circle across the relationship line near an entity indicates:

The Microsoft Access 2013 form editor is a(n):

Microsoft Access is a good tool for creating mock-ups of forms and reports because:

The number of entity classes involved in a relationship is the cardinality of the relationship.

In crow's foot E-R notation,a circle indicates a minimum cardinality of zero.

A(n)________ is a working demonstration of selected portions of the future system.

Microsoft Access 2013 uses banded form and report editors.

Which of the following would not be contained in a use case?

System requirements as documented by use cases,business rules,forms,reports,and queries are sufficient to design the database without using a formal data model.

Microsoft Access 2013 can be used to build a prototype database,which allows users to validate the data model by demonstrating the consequences of data modeling decisions.

Microsoft Access 2013 is only used to prototype databases where Microsoft Access itself will be the final DBMS.

When developing a database system,the database is constructed during the implementation phase.

Getting Started

The Relational Model

Structured Query Language

Database Design

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters