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 21

Multiple Choice

Review LaterAdd Note

Review Later

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

A) entity-relationship diagram (ERD)
B) illustration flow chart
C) query relationship diagram (QRD)
D) data chart

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

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

Common fields can be used to link entities in various types of relationships.

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

Binary digits have only _____ possible value(s) .

Audit log files,which record details of all accesses and changes to a file or database,can be used to recover changes made since the last backup.

Web-based designs are dependent on a specific combination of hardware and software.

Mainframe storage refers to data that a user can view,understand,and access,regardless of how or where that information actually is organized or stored.

The data mining technique that relies on association rule learning is often called _____.

Web-based systems are popular because they offer ease of access,cost-effectiveness,and worldwide connectivity.

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

The complete definition of a database,including descriptions of all fields,tables,and relationships,is called a _____.

_____ use a keyword to encode a number.

An M:N relationship is different from 1:1 or 1:M relationships because the event or transaction that links the two entities is actually a third entity,called an associative entity,that has its own characteristics.

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 that Eamon use?

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

A table design is in third normal form (3NF)if it is in 2NF and if all nonkey fields are dependent on one another.

_____ enables Java applications to exchange data with any database that uses SQL statements and is compliant with its standard.

A _____ specifies the fields and identifies the primary key in a particular file.

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 that Eamon use?

A _____ controls database operations,including storing,retrieving,updating,and deleting data.

_____ is the process of converting readable data into unreadable characters to prevent unauthorized access to the data.