Exam 9: Data Design

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

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.

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.

Binary digits have only _____ possible value(s).

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?

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.

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.

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

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

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?

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

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

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

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

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

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

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

_____ use a keyword to encode a number.

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