Question 1

Data redundancy is created through a process known as normalization.​

Accepted Answer

A) True 
 B)False

Question 2

A(n)____________________ is referred to as a row in the physical database.​

Accepted Answer

The answer of A(n)____________________ is referred to as a row...

Question 3

Data is in second normal form (2NF)if it contains no repeating groups and has a primary key to uniquely identify each record.​

Accepted Answer

A) True 
 B)False

Question 4

A(n)____________________ relationship means data can have multiple occurrences in both entities.​

Accepted Answer

many-to-ma

Question 5

Data is in ____________________ normal form if it does not have any repeating groups and has a primary key.​

Accepted Answer

The answer of Data is in ____________________ normal form if...

Question 6

Partial dependency can only exist if the data is uniquely identified by a composite primary key.​

Accepted Answer

A) True 
 B)False

Question 7

A field is referred to as a(n)____________________ in the physical database.​

Accepted Answer

The answer of A field is referred to as a(n)____________________...

Question 8

What represents a characteristic or attribute that is being collected about an entity?​

Accepted Answer

A)  ​record 
B)  ​row 
C)  ​field 
D)  ​both a and b 
A)  ​record 
B)  ​row 
C)  ​field 
D)  ​both a and b

Data redundancy is created through a process known as normalization.

A(n)____________________ is referred to as a row in the physical database.

Data is in second normal form (2NF)if it contains no repeating groups and has a primary key to uniquely identify each record.

A(n)____________________ relationship means data can have multiple occurrences in both entities.

Data is in ____________________ normal form if it does not have any repeating groups and has a primary key.

Partial dependency can only exist if the data is uniquely identified by a composite primary key.

A field is referred to as a(n)____________________ in the physical database.

What represents a characteristic or attribute that is being collected about an entity?

Basic SQL Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 1: Overview of Database Concepts

Data redundancy is created through a process known as normalization.​

A(n)____________________ is referred to as a row in the physical database.​

Data is in second normal form (2NF)if it contains no repeating groups and has a primary key to uniquely identify each record.​

A(n)____________________ relationship means data can have multiple occurrences in both entities.​

Data is in ____________________ normal form if it does not have any repeating groups and has a primary key.​

Partial dependency can only exist if the data is uniquely identified by a composite primary key.​

A field is referred to as a(n)____________________ in the physical database.​

What represents a characteristic or attribute that is being collected about an entity?​

Basic SQL Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Data redundancy is created through a process known as normalization.

A(n)____________________ is referred to as a row in the physical database.

Data is in second normal form (2NF)if it contains no repeating groups and has a primary key to uniquely identify each record.

A(n)____________________ relationship means data can have multiple occurrences in both entities.

Data is in ____________________ normal form if it does not have any repeating groups and has a primary key.

Partial dependency can only exist if the data is uniquely identified by a composite primary key.

A field is referred to as a(n)____________________ in the physical database.

What represents a characteristic or attribute that is being collected about an entity?