FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Data Design

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

In an entity-relationship diagram, entities are commonly represented as _____.

A) triangles
B) circles
C) rectangles
D) hexagons

E) A) and B)
F) C) and D)

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

At the beginning of the twenty-first century, many firms that used only two digits to represent the year were faced with a major problem called the _____.

A) Y2K issue
B) H2R issue
C) 2D issue
D) ​2DGT issue

E) None of the above
F) C) and D)

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

Case 9-1 ​​Eamon is planning to start an online store that specializes in books and electronics. Since it's his first business, he has a lot of doubts. Help Eamon set up his business by answering the following questions. -Eamon wants to provide a discount to premium buyers who order in large quantities. He wants to create a code for each price and share it with them. Also, he wants to ensure that only the premium buyers can decipher the code shared. In this scenario, which of the following codes would you suggest Eamon to use?

Most date formats now are based on the model established by the International Organization for Standardization (ISO) , which requires a format of _____.

-Any field that is not a primary key or a candidate key is called a _____.​

One type of validity check, called _____, is a set of rules that avoids data inconsistency and quality problems.

Case 9-1 ​​Eamon is planning to start an online store that specializes in books and electronics. Since it's his first business, he has a lot of doubts. Help Eamon set up his business by answering the following questions. -Eamon plans to operate three warehouses, in different cities, to support his business. To find the exact location of a product, he wants to establish a code that identifies a product's warehouse location, floor number, section number, aisle number, and bin number. By doing this, he can ship the ordered products faster. Which of the following codes would you suggest Eamon to use?

During the systems design phase, _____ are used to organize, access, and maintain data structures.

A(n) _____ is a graphical model of an information system that depicts the logical relationships and interaction among system entities.

A web-based data design requires users to have powerful workstations.

Like a primary key, a foreign key must be unique.

A primary key is composed of exactly two fields.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A field in one table that must match a primary key value in another table in order to establish the relationship between the two tables

Case 9-2 ​Emily is functioning with her customer, Anna, on the design of a new database. She describes to Anna that key fields are utilized to access, coordinate, and preserve the data records. -Emily tells Anna that a primary key is a field or combination of fields that individually and minimally recognizes a specific entity. She mentions that there may be an option of fields or field combinations to use as the primary key. Which of the following is the term used for a feasible primary key?

Three main types of relationships can exist between entities: a one-to-one relationship, abbreviated 1:1; a one-to-many relationship, abbreviated 1:M; and a many-to-many relationship, abbreviated M:N.

Designing tables is easier if a _____ is used to show a table's structure, fields, and primary key.

Compared with character-based formats, a _____ offers a more efficient storage method.​

Cipher codes distinguish items by using a series of subgroups of digits.​

A _____ is designed to serve the needs of a specific department, such as sales, marketing, or finance.

_____ combine data from different item attributes, or characteristics, to build a code.