Question 1

On difficulty with designing database is the __________number of possibilities of what to include.
A)small
B)known
C)minimal
D)large
E)fixed

Accepted Answer

The number of possibilities of what to include in a database can be very large, making it difficult to design a comprehensive and effective database. There are often many different data elements to consider, each with their own relationships and dependencies. Therefore, a large number of options need to be considered when designing a database.

Question 2

Entities have___________ that describes characteristics of the entity.
A)names
B)relations
C)attributes
D)properties
E)files

Accepted Answer

Attributes describe characteristics of entities. Names, relations, properties, and files are all related to entities, but do not specifically describe their characteristics.

Question 3

A column whose value uniquely identifies a specific row in a table is known as the
A)foreign key.
B)index attribute.
C)identifier.
D)key attribute.
E)index field.

Accepted Answer

A column whose value uniquely identifies a specific row in a table is called an identifier. It is often referred to as the primary key of the table. The other options are not accurate descriptions of a primary key. A foreign key is a column in one table that refers to the primary key of another table. An index attribute or index field is used to improve the performance of querying a large table. A key attribute is any attribute that is part of the primary key, not necessarily the identifier itself.

Question 4

When a table contains inaccurate data for the same data elements in a table,it is said that the data in the table lacks__________ .

Accepted Answer

The answer of When a table contains inaccurate data for...

Question 5

The___________shows the number of entities that can be involved in a relationship.
A)UML
B)E -R 
C)cardinality
D)workflow
E)data integrity

Accepted Answer

Cardinality represents the number of entities that can be involved in a relationship.

Question 6

When you place data into a database you need to place (the)___________records first.
A)indexed
B)first
C)foreign key
D)any
E)primary key

Accepted Answer

When placing data into a database, it is important to specify a primary key for each table. The primary key ensures each record is uniquely identifiable and acts as a reference point for other tables that may have a foreign key relationship with that table. Therefore, the best choice is to specify a primary key.

Question 7

There is (are)___________ style(s)of E -R diagrams.
A)one
B)2
C)15
D)several
E)10

Accepted Answer

There are several styles of E-R diagrams, as they can vary based on the modeling tools and methodologies used.

Question 8

Entities have_______with one another.

Accepted Answer

The answer of Entities have_______with one another....

Question 9

__________would be the best identifier attribute for an employee table.
A)Social Insurance number
B)Birth Date
C)First Name and Last Name
D)Phone number
E)Last Name

Accepted Answer

Social Insurance number is a unique identifier assigned by the government and ensures that each employee has a distinct identifier. This also helps distinguish employees with the same name or birth date.

Question 10

If the same data element is stored differently in another table,this is said to be an issue of
A)normalization.
B)entity integrity.
C)data integrity.
D)data repetition.
E)inaccurate data.

Accepted Answer

Data integrity refers to the accuracy and consistency of data. If the same data element is stored differently in another table, it compromises data integrity.

Question 11

__________form removes duplicate data and other problems from a table.

Accepted Answer

The answer of __________form removes duplicate data and other problems...

Question 12

The foreign key is put on the_____side of a one -to -many relationship.

Accepted Answer

The answer of The foreign key is put on the_____side...

Question 13

If a student is allowed to have multiple majors and advisers are assigned to multiple students,these would be examples of ____________ relationships.
A)1:1
B)N:M
C)M:N
D)1:N
E)N:1

Accepted Answer

N:M relationships occur when multiple items in one set are associated with multiple items in another set. In this case, students can have multiple majors and advisors can be assigned to multiple students.

Question 14

___________Is the process of converting poorly -structured tables into two or more well -structured tables.
A)Application development
B)Clarification
C)Structuring
D)Normalization
E)Conversion

Accepted Answer

The process of converting poorly-structured tables into two or more well-structured tables is known as normalization. This is a process commonly used in database management to eliminate data redundancies and inconsistencies, and to ensure data integrity.

Question 15

Database developers__________as the first step in development.
A)create an E -R diagram
B)create a relational model
C)create a data model
D)write queries
E)interview users

Accepted Answer

Interviewing users is typically the first step in database development to understand the requirements and needs of the system.

Question 16

The cardinality of the relationship between a employer and its employees is
A)1:1.
B)N:M.
C)N:1.
D)M:N.
E)1:N.

Accepted Answer

An employer can have multiple employees, but each employee can only have one employer. Therefore, the cardinality of this relationship is one employer to many employees (1:N).

Question 17

Entities have an ___________which is an attribute whose value is associated with one and only one entity instance. 
A)attribute
B)agenda
C)initial
D)index
E)identifier

Accepted Answer

An identifier is a unique attribute associated with an entity instance. It is used to distinguish one instance of an entity from another. Therefore, an identifier value is associated with one and only one entity instance.

Question 18

Database practitioners classify tables into  various____________depending on the type of data integrity problems to which they might be subject.
A)strata
B)categories
C)types
D)normal forms
E)layers

Accepted Answer

Tables are classified into different normal forms based on their level of dependencies and anomalies.

Question 19

The most complex type of a relationship is the ___________relationship.
A)1:N
B)M:M
C)1:1
D)N:M
E)N:1

Accepted Answer

The answer of The most complex type of a relationship...

Question 20

__________is a process for ensuring that the tables in a database design are efficient and well -structured.

Accepted Answer

The answer of __________is a process for ensuring that the...

Quiz 5: Extensions A: Introduction to Microsoft Excel

On difficulty with designing database is the __________number of possibilities of what to include.

Entities have___________ that describes characteristics of the entity.

A column whose value uniquely identifies a specific row in a table is known as the

When a table contains inaccurate data for the same data elements in a table,it is said that the data in the table lacks__________ .

The___________shows the number of entities that can be involved in a relationship.

When you place data into a database you need to place (the) ___________records first.

There is (are) ___________ style(s) of E -R diagrams.

Entities have_______with one another.

__________would be the best identifier attribute for an employee table.

If the same data element is stored differently in another table,this is said to be an issue of

__________form removes duplicate data and other problems from a table.

The foreign key is put on the_____side of a one -to -many relationship.

If a student is allowed to have multiple majors and advisers are assigned to multiple students,these would be examples of ____________ relationships.

___________Is the process of converting poorly -structured tables into two or more well -structured tables.

Database developers__________as the first step in development.

The cardinality of the relationship between a employer and its employees is

Entities have an ___________which is an attribute whose value is associated with one and only one entity instance.

Database practitioners classify tables into various____________depending on the type of data integrity problems to which they might be subject.

The most complex type of a relationship is the ___________relationship.

__________is a process for ensuring that the tables in a database design are efficient and well -structured.