Exam 9: Designing the Database

Explore all topics

Classes that participate in a classification hierarchy can be represented within a relational database as a set of tables with the primary key of the general class table replicated in the other tables.

(True/False)

4.9/5

(70)

Question 81

Problem domain modeling and database normalization are incompatible techniques for relational database design.

(True/False)

4.8/5

(86)

Question 82

In a relational database,a row can be referred to as a(n)____.

(Multiple Choice)

4.9/5

(83)

Question 83

A database that is stored at multiple locations but which does not need to be interconnected or synchronized is called a(n) .

(Short Answer)

4.8/5

(78)

Question 84

In a database table a column is the same thing as a(n)______.

(Short Answer)

4.8/5

(79)

Question 85

A separate relation must be created to store the attributes of a ____ relationship among two other classes.

(Multiple Choice)

4.9/5

(65)

Question 86

A data type that is supported directly by computer hardware or a programming language is called a(n)_______ data type.

(Short Answer)

4.9/5

(81)

Question 87

A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key.

(Multiple Choice)

4.9/5

(77)

Question 88

A lock on a portion of the database by one user,which allows other users to read the data is called a(n) .

(Short Answer)

4.9/5

(70)

Question 89

A database lock that does not allow another user to update the data is called what?

(Multiple Choice)

4.9/5

(78)

Question 90

A phased database development and deployment (using iterative development)is usually the safest approach to deploying the best database solution.

(True/False)

5.0/5

(79)

Question 91

One column of a table in a relational database is called a(n)____.

(Multiple Choice)

4.7/5

(77)

Question 92

A relational database table is in ____ normal form if it has no repeating fields or groups of fields,and hence all rows have the same columns.

(Multiple Choice)

4.9/5

(77)

Question 93

When there is a piece of work or an action that includes several steps and updates to the data and which all must complete to be valid,that piece or work is called a(n)_______.

(Short Answer)

4.9/5

(80)

Question 94

Which of the following contains both global and local schemas with distinct DBMSs?

(Multiple Choice)

5.0/5

(72)

Question 95

Data elements in a relational database are organized into ____.

(Multiple Choice)

5.0/5

(91)

Question 96

Showing 81 - 96 of 96

Classes that participate in a classification hierarchy can be represented within a relational database as a set of tables with the primary key of the general class table replicated in the other tables.

Problem domain modeling and database normalization are incompatible techniques for relational database design.

In a relational database,a row can be referred to as a(n)____.

A database that is stored at multiple locations but which does not need to be interconnected or synchronized is called a(n) .

In a database table a column is the same thing as a(n)______.

A separate relation must be created to store the attributes of a ____ relationship among two other classes.

A data type that is supported directly by computer hardware or a programming language is called a(n)_______ data type.

A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key.

A lock on a portion of the database by one user,which allows other users to read the data is called a(n) .

A database lock that does not allow another user to update the data is called what?

A phased database development and deployment (using iterative development)is usually the safest approach to deploying the best database solution.

One column of a table in a relational database is called a(n)____.

A relational database table is in ____ normal form if it has no repeating fields or groups of fields,and hence all rows have the same columns.

When there is a piece of work or an action that includes several steps and updates to the data and which all must complete to be valid,that piece or work is called a(n)_______.

Which of the following contains both global and local schemas with distinct DBMSs?

Data elements in a relational database are organized into ____.

From Beginning to End: An Overview of Systems Analysis and Design

Investigating System Requirements

Identifying User Stories and Use Cases

Domain Modeling

Use Case Modeling

Foundations for Systems Design

Defining the System Architecture

Designing the User Interface

Approaches to System Development

Project Planning and Project Management

Object-Oriented Design: Fundamentals

Object-Oriented Design: Use Case Realization

Deploying the New System

The Role of the Systems Analyst

The Traditional Approach to Requirements

Project Management Techniques

Filters

Exam 9: Designing the Database

Classes that participate in a classification hierarchy can be represented within a relational database as a set of tables with the primary key of the general class table replicated in the other tables.​

Problem domain modeling and database normalization are incompatible techniques for relational database design.​

In a relational database,a row can be referred to as a(n)____.​

A database that is stored at multiple locations but which does not need to be interconnected or synchronized is called a(n)______ ______.​

In a database table a column is the same thing as a(n)______.​

​A separate relation must be created to store the attributes of a ____ relationship among two other classes.

A data type that is supported directly by computer hardware or a programming language is called a(n)_______ data type.​

A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key.​

A lock on a portion of the database by one user,which allows other users to read the data is called a(n)______ ______.​

A database lock that does not allow another user to update the data is called what?​

A phased database development and deployment (using iterative development)is usually the safest approach to deploying the best database solution.​

​One column of a table in a relational database is called a(n)____.

A relational database table is in ____ normal form if it has no repeating fields or groups of fields,and hence all rows have the same columns.​

​When there is a piece of work or an action that includes several steps and updates to the data and which all must complete to be valid,that piece or work is called a(n)_______.

Which of the following contains both global and local schemas with distinct DBMSs?​

Data elements in a relational database are organized into ____.​

From Beginning to End: An Overview of Systems Analysis and Design

Investigating System Requirements

Identifying User Stories and Use Cases

Domain Modeling

Use Case Modeling

Foundations for Systems Design

Defining the System Architecture

Designing the User Interface

Approaches to System Development

Project Planning and Project Management

Object-Oriented Design: Fundamentals

Object-Oriented Design: Use Case Realization

Deploying the New System

The Role of the Systems Analyst

The Traditional Approach to Requirements

Project Management Techniques

Filters

Classes that participate in a classification hierarchy can be represented within a relational database as a set of tables with the primary key of the general class table replicated in the other tables.

Problem domain modeling and database normalization are incompatible techniques for relational database design.

In a relational database,a row can be referred to as a(n)____.

A database that is stored at multiple locations but which does not need to be interconnected or synchronized is called a(n) .

In a database table a column is the same thing as a(n)______.

A separate relation must be created to store the attributes of a ____ relationship among two other classes.

A data type that is supported directly by computer hardware or a programming language is called a(n)_______ data type.

A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key.

A lock on a portion of the database by one user,which allows other users to read the data is called a(n) .

A database lock that does not allow another user to update the data is called what?

A phased database development and deployment (using iterative development)is usually the safest approach to deploying the best database solution.

One column of a table in a relational database is called a(n)____.

A relational database table is in ____ normal form if it has no repeating fields or groups of fields,and hence all rows have the same columns.

When there is a piece of work or an action that includes several steps and updates to the data and which all must complete to be valid,that piece or work is called a(n)_______.

Which of the following contains both global and local schemas with distinct DBMSs?

Data elements in a relational database are organized into ____.