Question 1

Which of the following statements is not true?
A)SQL is the most popular query language used for interacting with a database.
B)SQL uses typical key words in a search.
C)Keying in SQL terms is more difficult than utilizing QBE in a search.
D)A user fills out a form to construct a description of the data desired in a SQL search.
E)All of the choices are true.

Accepted Answer

SQL does not involve filling out a form to construct a description of the data; it involves writing queries using SQL syntax.

Question 2

A join operation can only be used to link 2 tables.

Accepted Answer

A join operation can link more than 2 tables as well.

Question 3

A null value is an attribute with a lot of data in it.

Accepted Answer

A null value means that there is no data in the attribute. It is empty or undefined.

Question 4

An entity is a person, place, thing, or event about which information is maintained.

Accepted Answer

This is the definition of an entity in the context of data management and database systems.

Question 5

For the following entity-relationship diagram, an attribute you would NOT expect to see in the Computer entity is 
A)manufacturer.
B)type (laptop or desktop).
C)memory size.
D)disk size.
E)student's dorm room.

Accepted Answer

The attribute "student's dorm room" does not pertain to the Computer entity and is not relevant to its function or relationship with other entities in the diagram. It is more likely to be an attribute of the Student entity.

Question 6

Which relationship has the most number of entities associated with it?
A)unary relationship
B)binary relationship
C)ternary relationship
D)All of the relationships are associated with the same number of entities.

Accepted Answer

A ternary relationship involves three entities that are associated with each other, whereas a binary relationship involves only two entities. An unary relationship involves a single entity, so it cannot have more entities associated with it than a ternary or binary relationship. Therefore, the answer is C) ternary relationship as it has more entities associated with it compared to the other relationships.

Question 7

You would use a form in SQL searches.

Accepted Answer

SQL searches do not require the use of a form. They can be executed using SQL queries directly. However, applications that allow users to interact with the database may have forms that generate SQL queries based on user input.

Question 8

The secondary key is a field that identifies a record with complete uniqueness.

Accepted Answer

The definition of a secondary key is incorrect. A secondary key may identify a record with uniqueness, but it does not have to be completely unique. A primary key is the field that identifies a record with complete uniqueness.

Question 9

ER diagram consist of entities, attributes and __________.
A)business rules
B)data dictionaries
C)relationships
D)cardinality

Accepted Answer

ER diagrams consist of entities, their attributes, and their relationships with each other. While business rules and data dictionaries can be used in the creation of an ER diagram, they are not essential components of the diagram itself. Cardinality is a term used to describe the number of entities that can be linked through a relationship in the ER diagram.

Question 10

At your university, students can take more than one class, and each class can have more than one student. This is an example of what kind of relationship?
A)one-to-one
B)one-to-many
C)many-to-one
D)many-to-many
E)some-to-many

Accepted Answer

This is an example of a many-to-many relationship because multiple students can take multiple classes.

Question 11

Which of the following is not a possible cardinality symbol?
A)Mandatory single
B)Mandatory many
C)Optional single
D)Optional many
E)One-to-one

Accepted Answer

One-to-one is not a cardinality symbol, it represents a type of relationship between entities. The cardinality symbols are Mandatory single, Mandatory many, Optional single, and Optional many.

Question 12

You would be an instance of your university's STUDENT class.

Accepted Answer

As a student of a university, you can be considered as an instance of the university's STUDENT class.

Question 13

For the following entity-relationship diagram, an attribute you would NOT expect to see in the Student entity is 
A)serial number of computer
B)student's last name
C)student's first name
D)course name
E)student's dorm room.

Accepted Answer

The entity-relationship diagram provided in the question relates to student registration and enrollment in courses. Therefore, a serial number of a computer is irrelevant to this context and would not be expected as an attribute in the Student entity. The other answer choices are all relevant attributes that may be associated with a student's record.

Question 14

Entity-relationship diagrams are documents that show the primary and secondary keys associated with a conceptual data model.

Accepted Answer

Entity-relationship diagrams show the entities, attributes, and relationships in a conceptual data model, but they do not typically show primary and secondary keys.

Question 15

In a university's relational database, the student record contains information regarding the student's last name. The last name is a(n):
A)attribute.
B)entity.
C)primary key.
D)object.
E)file.

Accepted Answer

The last name of a student is a characteristic or attribute of the student entity in the database.

Question 16

Normalization is a process that helps eliminate redundancies in a relational database module.

Accepted Answer

Normalization helps to reduce data redundancy and improve data consistency in a relational database by breaking down the data into smaller, more specific and organized tables. This process involves following certain rules and guidelines to ensure that the data is properly organized and free of unnecessary duplication.

Question 17

An attribute is any characteristic or quality that describes a particular entity.

Accepted Answer

This statement defines what an attribute is, and it is true.

Question 18

SQL is much simpler to use than QBE.

Accepted Answer

QBE (Query by Example) is designed to be a simpler, more user-friendly graphical user interface for querying databases. SQL can be more complex and technical, but also more powerful and flexible for advanced database management tasks.

Question 19

Which of the following would not be a typical key word in a SQL search?
A)SELECT
B)FROM
C)QBE
D)WHERE
E)All of the choices are typical key words.

Accepted Answer

QBE (Query By Example) is not a keyword in SQL. It is a graphical user interface used to construct SQL queries in some database management systems. The other choices (SELECT, FROM, WHERE) are all typical SQL keywords used to construct queries.

Question 20

If you wanted to find out information about why an attribute is needed in a database you should look in the _______.
A)SQL
B)QBE
C)data dictionary
D)ER diagram

Accepted Answer

The data dictionary is a tool that provides information about the structure, content, and organization of a database, including the definition and purpose of each attribute. It is the most appropriate source for finding information about why a particular attribute is included in a database. SQL is a language used to manipulate and query data in a database, QBE is a graphical interface for creating SQL queries, and ER diagrams are used to visualize the relationships between entities in a database.

Quiz 16: Plug It in 1 Business Processes and Business Process Management

Which of the following statements is not true?

A join operation can only be used to link 2 tables.

A null value is an attribute with a lot of data in it.

An entity is a person, place, thing, or event about which information is maintained.

For the following entity-relationship diagram, an attribute you would NOT expect to see in the Computer entity is

Which relationship has the most number of entities associated with it?

You would use a form in SQL searches.

The secondary key is a field that identifies a record with complete uniqueness.

ER diagram consist of entities, attributes and __________.

At your university, students can take more than one class, and each class can have more than one student. This is an example of what kind of relationship?

Which of the following is not a possible cardinality symbol?

You would be an instance of your university's STUDENT class.

For the following entity-relationship diagram, an attribute you would NOT expect to see in the Student entity is

Entity-relationship diagrams are documents that show the primary and secondary keys associated with a conceptual data model.

In a university's relational database, the student record contains information regarding the student's last name. The last name is a(n) :

Normalization is a process that helps eliminate redundancies in a relational database module.

An attribute is any characteristic or quality that describes a particular entity.

SQL is much simpler to use than QBE.

Which of the following would not be a typical key word in a SQL search?

If you wanted to find out information about why an attribute is needed in a database you should look in the _______.