Exam 9: Data Design

MATCHING Identify the letter of the choice that best matches the phrase or definition.a.UML f.subschema b.cardinality g.EBCDIC c.secondary key h.entity d.data mining i.physical e.orphan j.logical -In e-commerce, this works best when a goal is to reduce clicks to close, which means average page views to accomplish a purchase or obtain desired information.

In an M:N relationship, the two entities are linked by an event or transaction called an associative entity, which has its own set of attributes and characteristics.

____________________ 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 data must be secure but in order to be so, it cannot be easily accessible to authorized users.

A table design specifies the fields and identifies the primary key in a particular table or file.

____ codes use a keyword to encode a number.

____ is the process of creating table designs by assigning specific fields or attributes to each table in a database.

In ASCII, the number 1,234,567,890 requires ____ bytes of storage.

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

To resolve potential database connectivity and access problems, companies use ODBC-compliant software that enables communication among various systems and DBMSs. _________________________

Perry tells Eamon that systems that interact with a database management system do not need to know about the underlying data structures used to store the physical data. As a result, a database administrator has the flexibility to change these underlying data structures without modifying the systems that use the data. What is the name of this feature of database management systems?

The three normal forms constitute a progression in which the first normal form represents the best design. _________________________