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

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.

Answer 1

D

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

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.

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.

Question 7

You would use a form in SQL searches.

Question 8

The secondary key is a 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

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

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

Question 12

You would be an instance of your 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.

Question 14

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

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.

Question 16

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

Question 17

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

Question 18

SQL is much simpler to use than QBE.

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.

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

Question 21

For the following entity-relationship diagram, the student name is what kind of field in the Student table?

A)Primary key field
B)Record field
C)Attribute field
D)Secondary field

Question 22

Normalization ensures ______ data redundancy and _______ data integrity.

A)zero; complete
B)complete; zero
C)minimum; maximum
D)maximum; minimum

Question 23

For the following entity-relationship diagram, what could the primary key be in the Grade entity?

A)Primary key from Student entity
B)Primary key from Course entity
C)The student's grade in the course.
D)Primary key made up of the primary keys from Student entity and Course entity

Question 24

Refer to the following entity-relationship diagram: a student has taken four courses so far. How many records will the student have in the Grade table?

A)1
B)2
C)3
D)4
E)5

Question 25

Join operations can only be used in ________ normal form.

A)first
B)second
C)third

Question 26

In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip). A customer could order more than one piece of jewelry at a time. Which of the following entity-relationship diagrams is true?

Question 27

In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip). Each individual piece of jewelry is treated as a separate order. Orders can be made for custom pieces which do not appear in the product list for the store. Which of the following entity-relationship diagrams is true?

Question 28

Refer to the following entity-relationship diagram: a new course has 41 students in the class. How many records will the course have in the Grade table?

A)1
B)10
C)41
D)50
E)82