Question 1

What can be said about the following relational database table (key is underlined): (Choose the most correct answer.)​ CourseSectionID,StudentID,Grade,StudentName

Accepted Answer

A) Not in any valid normal form 
B) ​In First Normal Form 
C) In First and Second Normal Form 
D) ​​In First, Second, and Third Normal Form 
A) Not in any valid normal form 
B) ​In First Normal Form 
C) In First and Second Normal Form 
D) ​​In First, Second, and Third Normal Form

Question 2

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if no non-key field is functionally dependent on any other non-key field.​

Accepted Answer

A) True 
 B)False

Question 3

A constraint which is stored in the schema and which ensures that all foreign keys have associated primary keys is called a(n)______ ______ ______.​

Accepted Answer

referentia

Question 4

____ is a consistent relational database state in which every foreign key value also exists as a primary key value.​

Accepted Answer

A) First normal form (1NF) 
B) ​Database synchronization 
C) Function dependency 
D) ​Referential integrity 
A) First normal form (1NF) 
B) ​Database synchronization 
C) Function dependency 
D) ​Referential integrity

Question 5

The condition that requires that every value in a foreign key must have an equivalent value as the primary key in another table is called ________ ______.​

Accepted Answer

referentia

Question 6

A _______ is an integrated collection of stored data that is centrally managed and controlled​

Accepted Answer

The answer of A _______ is an integrated collection of...

Question 7

In database design and administration the hardware and network architecture is an important consideration.The chapter describes four distinct hardware configurations for the deployment of a database based on the size and reach of the database. Identify an briefly describe each of the four.​

Accepted Answer

1.A single desktop system residing on on

Question 8

A relation describes the structure,content,and access controls of a physical data store or database.​

Accepted Answer

A) True 
 B)False

Question 9

___________  is where the value in one field determines the value in another field in the same record.​

Accepted Answer

A) First normal form 
B) ​Second normal form 
C) Referential integrity​ 
D) ​Functional dependency 
A) First normal form 
B) ​Second normal form 
C) Referential integrity​ 
D) ​Functional dependency

Question 10

The person who is in charge of the safety and operation of the DBMS is called the _____ _____.​

Accepted Answer

database a

Question 11

In a database a two-dimensional data structure consisting of columns and rows is called a(n)_______.​

Accepted Answer

The answer of In a database a two-dimensional data structure...

Question 12

A(n)____ is a field or set of fields used to uniquely identify each row.​

Accepted Answer

A) primary key 
B) ​foreign key 
C) object identifier 
D) ​attribute 
A) primary key 
B) ​foreign key 
C) object identifier 
D) ​attribute

Question 13

A database table is in _____ _____ _____ if all non-key attributes are functionally dependent on the entire key.​

Accepted Answer

second nor

Question 14

Non-key ("bad")redundancy can be systematically identified and eliminated from a relational database by ____________________ of the database.​

Accepted Answer

normalizat

Question 15

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

Accepted Answer

The answer of ​In a database table a tuple is...

Question 16

Relationships in a relational database are usually represented by embedding a foreign key in each participating table.​

Accepted Answer

A) True 
 B)False

Question 17

A write lock on a database allows other users to read the data,but they cannot update any data.​

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is NOT a component or function of a typical database management system (DBMS)?​

Accepted Answer

A) Low-level process management 
B) ​Direct query processor 
C) Application program interface processor 
D) ​Administrative interface 
A) Low-level process management 
B) ​Direct query processor 
C) Application program interface processor 
D) ​Administrative interface

Question 19

A software system whose purpose is to manage and control the data in a database is called a(n)_______ _______ ______.​

Accepted Answer

database m

Question 20

In a distributed database configuration when all the tables are copied to all locations that is called _____ ______​

Accepted Answer

data repli

What can be said about the following relational database table (key is underlined): (Choose the most correct answer.) CourseSectionID,StudentID,Grade,StudentName

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if no non-key field is functionally dependent on any other non-key field.

A constraint which is stored in the schema and which ensures that all foreign keys have associated primary keys is called a(n) __.

____ is a consistent relational database state in which every foreign key value also exists as a primary key value.

The condition that requires that every value in a foreign key must have an equivalent value as the primary key in another table is called __ .

A _______ is an integrated collection of stored data that is centrally managed and controlled

In database design and administration the hardware and network architecture is an important consideration.The chapter describes four distinct hardware configurations for the deployment of a database based on the size and reach of the database. Identify an briefly describe each of the four.

A relation describes the structure,content,and access controls of a physical data store or database.

___________ is where the value in one field determines the value in another field in the same record.

The person who is in charge of the safety and operation of the DBMS is called the _ _.

In a database a two-dimensional data structure consisting of columns and rows is called a(n)_______.

A(n)____ is a field or set of fields used to uniquely identify each row.

A database table is in ___ _ ___ if all non-key attributes are functionally dependent on the entire key.

Non-key ("bad")redundancy can be systematically identified and eliminated from a relational database by ____________________ of the database.

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

Relationships in a relational database are usually represented by embedding a foreign key in each participating table.

A write lock on a database allows other users to read the data,but they cannot update any data.

Which of the following is NOT a component or function of a typical database management system (DBMS)?

A software system whose purpose is to manage and control the data in a database is called a(n)___ _ ____.

In a distributed database configuration when all the tables are copied to all locations that is called _ __

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

What can be said about the following relational database table (key is underlined): (Choose the most correct answer.)​ CourseSectionID,StudentID,Grade,StudentName

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if no non-key field is functionally dependent on any other non-key field.​

A constraint which is stored in the schema and which ensures that all foreign keys have associated primary keys is called a(n)______ ______ ______.​

____ is a consistent relational database state in which every foreign key value also exists as a primary key value.​

The condition that requires that every value in a foreign key must have an equivalent value as the primary key in another table is called ________ ______.​

A _______ is an integrated collection of stored data that is centrally managed and controlled​

In database design and administration the hardware and network architecture is an important consideration.The chapter describes four distinct hardware configurations for the deployment of a database based on the size and reach of the database. Identify an briefly describe each of the four.​

A relation describes the structure,content,and access controls of a physical data store or database.​

___________ is where the value in one field determines the value in another field in the same record.​

The person who is in charge of the safety and operation of the DBMS is called the _____ _____.​

In a database a two-dimensional data structure consisting of columns and rows is called a(n)_______.​

A(n)____ is a field or set of fields used to uniquely identify each row.​

A database table is in _____ _____ _____ if all non-key attributes are functionally dependent on the entire key.​

Non-key ("bad")redundancy can be systematically identified and eliminated from a relational database by ____________________ of the database.​

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

Relationships in a relational database are usually represented by embedding a foreign key in each participating table.​

A write lock on a database allows other users to read the data,but they cannot update any data.​

Which of the following is NOT a component or function of a typical database management system (DBMS)?​

A software system whose purpose is to manage and control the data in a database is called a(n)_______ _______ ______.​

In a distributed database configuration when all the tables are copied to all locations that is called _____ ______​

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

What can be said about the following relational database table (key is underlined): (Choose the most correct answer.) CourseSectionID,StudentID,Grade,StudentName

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if no non-key field is functionally dependent on any other non-key field.

A constraint which is stored in the schema and which ensures that all foreign keys have associated primary keys is called a(n) __.

____ is a consistent relational database state in which every foreign key value also exists as a primary key value.

The condition that requires that every value in a foreign key must have an equivalent value as the primary key in another table is called __ .

A _______ is an integrated collection of stored data that is centrally managed and controlled

In database design and administration the hardware and network architecture is an important consideration.The chapter describes four distinct hardware configurations for the deployment of a database based on the size and reach of the database. Identify an briefly describe each of the four.

A relation describes the structure,content,and access controls of a physical data store or database.

___________ is where the value in one field determines the value in another field in the same record.

The person who is in charge of the safety and operation of the DBMS is called the _ _.

In a database a two-dimensional data structure consisting of columns and rows is called a(n)_______.

A(n)____ is a field or set of fields used to uniquely identify each row.

A database table is in ___ _ ___ if all non-key attributes are functionally dependent on the entire key.

Non-key ("bad")redundancy can be systematically identified and eliminated from a relational database by ____________________ of the database.

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

Relationships in a relational database are usually represented by embedding a foreign key in each participating table.

A write lock on a database allows other users to read the data,but they cannot update any data.

Which of the following is NOT a component or function of a typical database management system (DBMS)?

A software system whose purpose is to manage and control the data in a database is called a(n)___ _ ____.

In a distributed database configuration when all the tables are copied to all locations that is called _ __