Question 1

An entity that depends on another entity for its own existence is called a(n)____________________.​

Accepted Answer

weak entit

Question 2

Independent entities have ____ in an E-R diagram​

Accepted Answer

A)  dashed borders​ 
B)  ​dark backgrounds 
C)  ​square corners 
D)  ​rounded corners 
A)  dashed borders​ 
B)  ​dark backgrounds 
C)  ​square corners 
D)  ​rounded corners

Question 3

When the existence of one entity depends on the existence of another related entity,there is a(n)____________________.​

Accepted Answer

​existence

Question 4

In IDEF1X,the ____ is the symbol for category.​

Accepted Answer

A)  ​square 
B)  ​rectangle 
C)  ​diamond 
D)  ​circle 
A)  ​square 
B)  ​rectangle 
C)  ​diamond 
D)  ​circle

Question 5

____________________ key restrictions determine the relationships between tables.​

Accepted Answer

The answer of ____________________ key restrictions determine the relationships between...

Question 6

During the ____________________ design,designers must consider the characteristics of the particular DBMS that the organization will use.​

Accepted Answer

The answer of During the ____________________ design,designers must consider the...

Question 7

You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.​

Accepted Answer

A) True 
 B)False

Question 8

To obtain information about ____________________ you might ask users questions such as: "If you know a particular employee number,can you establish other information,such as employee name?"​

Accepted Answer

​functiona

Question 9

An entity-relationship (E-R)model is an approach to representing data in a(n)____________________.​

Accepted Answer

The answer of An entity-relationship (E-R)model is an approach to...

Question 10

Nulls are used when a value is either unknown or inapplicable.​

Accepted Answer

A) True 
 B)False

Question 11

____________________ refers to the number of items that must be included in a relationship.​

Accepted Answer

The answer of ____________________ refers to the number of items...

Question 12

When designing a database,you might find it helpful to design a(n)____ to obtain the required information from users.​

Accepted Answer

A)  ​E-R diagram 
B)  ​table 
C)  ​report 
D)  ​survey form 
A)  ​E-R diagram 
B)  ​table 
C)  ​report 
D)  ​survey form

Question 13

The first step in creating a user view is to normalize the tables.​

Accepted Answer

A) True 
 B)False

Question 14

Combining the following two tables would result in ____.​ Employee (EmployeeNum,LastName,FirstName,WageRate,SocSecNum,DepartmentNum)
Employee (EmployeeNum,LastName,FirstName,Street,City,State,PostalCode)

Accepted Answer

A)  ​Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, (Street, City, PostalCode) ) 
B)  ​Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode) 
C)  ​Employee (EmployeeNum, LastName, FirstName, Street, City State, PostalCode, WageRate, SocSecNum) 
D)  ​Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, EmployeeNum, LastName, FirstName, Street, City, State, PostalCode ) 
A)  ​Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, (Street, City, PostalCode) ) 
B)  ​Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode) 
C)  ​Employee (EmployeeNum, LastName, FirstName, Street, City State, PostalCode, WageRate, SocSecNum) 
D)  ​Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, EmployeeNum, LastName, FirstName, Street, City, State, PostalCode )

Question 15

Explain the difference between a minimum cardinality of zero and a minimum cardinality of one.​

Accepted Answer

​An entity in a relationship w

Question 16

The primary key is a unique identifier.​

Accepted Answer

A) True 
 B)False

Question 17

The properties of the entities you choose as you design the user view will become the ____ in the appropriate tables.​

Accepted Answer

A)  ​rows 
B)  ​columns 
C)  ​data 
D)  ​DBMS 
A)  ​rows 
B)  ​columns 
C)  ​data 
D)  ​DBMS

Question 18

When provided with a user view or some sort of stated requirement,you must develop a collection of tables that will support it.​

Accepted Answer

A) True 
 B)False

Question 19

​In an E-R diagram,a dashed line represents an identifying relationship and a solid line represents a nonidentifying relationship.

Accepted Answer

A) True 
 B)False

Question 20

Columns that are of interest strictly for the purpose of retrieval are known as ____________________.​

Accepted Answer

The answer of Columns that are of interest strictly for...

An entity that depends on another entity for its own existence is called a(n)____________________.

Independent entities have ____ in an E-R diagram

When the existence of one entity depends on the existence of another related entity,there is a(n)____________________.

In IDEF1X,the ____ is the symbol for category.

____________________ key restrictions determine the relationships between tables.

During the ____________________ design,designers must consider the characteristics of the particular DBMS that the organization will use.

You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.

To obtain information about ____________________ you might ask users questions such as: "If you know a particular employee number,can you establish other information,such as employee name?"

An entity-relationship (E-R)model is an approach to representing data in a(n)____________________.

Nulls are used when a value is either unknown or inapplicable.

____________________ refers to the number of items that must be included in a relationship.

When designing a database,you might find it helpful to design a(n)____ to obtain the required information from users.

The first step in creating a user view is to normalize the tables.

Combining the following two tables would result in ____. Employee (EmployeeNum,LastName,FirstName,WageRate,SocSecNum,DepartmentNum) Employee (EmployeeNum,LastName,FirstName,Street,City,State,PostalCode)

Explain the difference between a minimum cardinality of zero and a minimum cardinality of one.

The primary key is a unique identifier.

The properties of the entities you choose as you design the user view will become the ____ in the appropriate tables.

When provided with a user view or some sort of stated requirement,you must develop a collection of tables that will support it.

In an E-R diagram,a dashed line represents an identifying relationship and a solid line represents a nonidentifying relationship.

Columns that are of interest strictly for the purpose of retrieval are known as ____________________.

Introduction to Database Management

The Relational : Introduction, QBE, and Relational Algebra

The Relational : SQL

The Relational : Advanced Topics

Database Design 1: Normalization

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 6: Database Design 2: Design Method

An entity that depends on another entity for its own existence is called a(n)____________________.​

Independent entities have ____ in an E-R diagram​

When the existence of one entity depends on the existence of another related entity,there is a(n)____________________.​

In IDEF1X,the ____ is the symbol for category.​

____________________ key restrictions determine the relationships between tables.​

During the ____________________ design,designers must consider the characteristics of the particular DBMS that the organization will use.​

You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.​

To obtain information about ____________________ you might ask users questions such as: "If you know a particular employee number,can you establish other information,such as employee name?"​

An entity-relationship (E-R)model is an approach to representing data in a(n)____________________.​

Nulls are used when a value is either unknown or inapplicable.​

____________________ refers to the number of items that must be included in a relationship.​

When designing a database,you might find it helpful to design a(n)____ to obtain the required information from users.​

The first step in creating a user view is to normalize the tables.​

Combining the following two tables would result in ____.​ Employee (EmployeeNum,LastName,FirstName,WageRate,SocSecNum,DepartmentNum) Employee (EmployeeNum,LastName,FirstName,Street,City,State,PostalCode)

Explain the difference between a minimum cardinality of zero and a minimum cardinality of one.​

The primary key is a unique identifier.​

The properties of the entities you choose as you design the user view will become the ____ in the appropriate tables.​

When provided with a user view or some sort of stated requirement,you must develop a collection of tables that will support it.​

​In an E-R diagram,a dashed line represents an identifying relationship and a solid line represents a nonidentifying relationship.

Columns that are of interest strictly for the purpose of retrieval are known as ____________________.​

Introduction to Database Management

The Relational : Introduction, QBE, and Relational Algebra

The Relational : SQL

The Relational : Advanced Topics

Database Design 1: Normalization

Dbms Functions

Database Administration

Database Management Approaches

Filters

An entity that depends on another entity for its own existence is called a(n)____________________.

Independent entities have ____ in an E-R diagram

When the existence of one entity depends on the existence of another related entity,there is a(n)____________________.

In IDEF1X,the ____ is the symbol for category.

____________________ key restrictions determine the relationships between tables.

During the ____________________ design,designers must consider the characteristics of the particular DBMS that the organization will use.

You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.

To obtain information about ____________________ you might ask users questions such as: "If you know a particular employee number,can you establish other information,such as employee name?"

An entity-relationship (E-R)model is an approach to representing data in a(n)____________________.

Nulls are used when a value is either unknown or inapplicable.

____________________ refers to the number of items that must be included in a relationship.

When designing a database,you might find it helpful to design a(n)____ to obtain the required information from users.

The first step in creating a user view is to normalize the tables.

Combining the following two tables would result in ____. Employee (EmployeeNum,LastName,FirstName,WageRate,SocSecNum,DepartmentNum) Employee (EmployeeNum,LastName,FirstName,Street,City,State,PostalCode)

Explain the difference between a minimum cardinality of zero and a minimum cardinality of one.

The primary key is a unique identifier.

The properties of the entities you choose as you design the user view will become the ____ in the appropriate tables.

When provided with a user view or some sort of stated requirement,you must develop a collection of tables that will support it.

In an E-R diagram,a dashed line represents an identifying relationship and a solid line represents a nonidentifying relationship.

Columns that are of interest strictly for the purpose of retrieval are known as ____________________.