Question 1

An entity identifier can be either unique or nonunique.

Accepted Answer

A) True 
 B)False  True

Question 2

The subtype symbol is a circle with a line under it.

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

The crow's foot E-R diagram notation uses a hash mark to indicate a maximum cardinality of one and a crow's foot to indicate a maximum cardinality of many.Each symbol is placed immediately next to the rectangle symbolizing an entity.These symbols are combined in various forms to signify 1:1,1:N and N:M relationships.

Question 4

During the design phase of developing a database system,the users are asked about the need for changes to existing forms and reports.

Accepted Answer

A) True 
 B)False

Question 5

The number of entity classes involved in a relationship is known as the relationship's ________.

Accepted Answer

A)  maximum cardinality 
B)  minimum cardinality 
C)  ordinality 
D)  degree 
E)  class 
A)  maximum cardinality 
B)  minimum cardinality 
C)  ordinality 
D)  degree 
E)  class

Question 6

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 7

An entity class is described by the structure of the entities in that class.

Accepted Answer

A) True 
 B)False

Question 8

Given only the following excerpt of an E-R model:
 
If one instance of ENTITY B must be related to one and only one instance of ENTITY A,and one instance of ENTITY A may be related to many instances of ENTITY B,which of the following should be written on the end of the relationship line next to ENTITY B in the figure above?

Accepted Answer

A)    
B)    
C)    
D)    
E)  None of the above is correct. 
A)    
B)    
C)    
D)    
E)  None of the above is correct.

Question 9

Describe the use of Microsoft Access as a prototyping tool.

Accepted Answer

Prototyping a database allows users to v

Question 10

In a 1:1 relationship,a single entity instance of one type is related to a single entity instance of the same or another type.

Accepted Answer

A) True 
 B)False

Question 11

An entity that must logically depend on another entity is called a(n)________ entity.

Accepted Answer

The answer of An entity that must logically depend on...

Question 12

Subtype entities may be either exclusive or inclusive.

Accepted Answer

A) True 
 B)False

Question 13

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 14

Distinguish between a data model and a database design.

Accepted Answer

The data model is a representation of th

Question 15

During the implementation phase of developing a database system,the data model is transformed into a database design.

Accepted Answer

A) True 
 B)False

Question 16

Relationships with the degree two are often called ________ relationships.

Accepted Answer

The answer of Relationships with the degree two are often...

Question 17

Recursive relationships can be represented as 1:N or N:M,but not 1:1.

Accepted Answer

A) True 
 B)False

Question 18

In crow's foot E-R notation,the hash mark indicates both a minimum cardinality of one and a maximum cardinality of one.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system?

Accepted Answer

A)  Referential integrity constraints 
B)  User interviews 
C)  Forms 
D)  Use cases 
E)  Business Rules 
A)  Referential integrity constraints 
B)  User interviews 
C)  Forms 
D)  Use cases 
E)  Business Rules

Question 20

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

Accepted Answer

A) True 
 B)False

An entity identifier can be either unique or nonunique.

The subtype symbol is a circle with a line under it.

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

During the design phase of developing a database system,the users are asked about the need for changes to existing forms and reports.

The number of entity classes involved in a relationship is known as the relationship's ________.

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

An entity class is described by the structure of the entities in that class.

Describe the use of Microsoft Access as a prototyping tool.

In a 1:1 relationship,a single entity instance of one type is related to a single entity instance of the same or another type.

An entity that must logically depend on another entity is called a(n)________ entity.

Subtype entities may be either exclusive or inclusive.

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.

Distinguish between a data model and a database design.

During the implementation phase of developing a database system,the data model is transformed into a database design.

Relationships with the degree two are often called ________ relationships.

Recursive relationships can be represented as 1:N or N:M,but not 1:1.

In crow's foot E-R notation,the hash mark indicates both a minimum cardinality of one and a maximum cardinality of one.

Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system?

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

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 4: Data Modeling and the Entity Relationship Model

An entity identifier can be either unique or nonunique.

The subtype symbol is a circle with a line under it.

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

During the design phase of developing a database system,the users are asked about the need for changes to existing forms and reports.

The number of entity classes involved in a relationship is known as the relationship's ________.

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

An entity class is described by the structure of the entities in that class.

Describe the use of Microsoft Access as a prototyping tool.

In a 1:1 relationship,a single entity instance of one type is related to a single entity instance of the same or another type.

An entity that must logically depend on another entity is called a(n)________ entity.

Subtype entities may be either exclusive or inclusive.

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.

Distinguish between a data model and a database design.

During the implementation phase of developing a database system,the data model is transformed into a database design.

Relationships with the degree two are often called ________ relationships.

Recursive relationships can be represented as 1:N or N:M,but not 1:1.

In crow's foot E-R notation,the hash mark indicates both a minimum cardinality of one and a maximum cardinality of one.

Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system?

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

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters