Exam 9: Data Design

A primary key is composed of exactly two fields.

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

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 _____.

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?

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

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

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

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

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

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

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

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

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

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

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?

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?

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

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

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

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.