SPRING 2016 CIS 406-02: CH9 – Flashcards
Unlock all answers in this set
Unlock answersquestion
A data BLANK, which is a framework for organizing and storing data, consists of one or more files or tables.
answer
data structure.
question
True or False: A primary key cannot be composed of more than one field.
answer
False. For example, if a student registers for three courses, his or her student number will appear in three records in the registration system.
question
True or False: In an (M:N) many to many relationship, the two entities are linked by an event or transaction called an associative entity, which has its own set of attributes and characteristics
answer
True
question
True of False: A repeating group is a set of one or more fields that can occur only once in a single record, with each occurrence having the same value.
answer
False, can occur any number of times in a single record, with each occurrence having different values.
question
True or False: Field X is functionally dependent on field Y if the value of field X depends on the value of field Y.
answer
True.
question
True or False: A popular rule of thumb is that a design is in 3NF if every nonkey field depends on the key, the whole key, and nothing but the key.
answer
True.
question
True or False: Normal forms beyond 3NF exist, but they rarely are used in business-oriented systems.
answer
True.
question
True or False: A data warehouse allows users to specify certain dimensions, or characteristics.
answer
True. By selecting data dimensions, a user can retrieve specific information without having to know how or where the data is stored.
question
True or False: To protect stored data, users can be asked to furnish a proper user ID and password to access a file or database.
answer
True. Stored data can also be encrypted to prevent unauthorized access.
question
BLANK means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.
answer
Scalability.
question
With a(n) BLANK language, the user provides an example of the data requested.
answer
a query by example, Q.B.E. The QBE request generates the SQL commands sent to server.
question
A data BLANK language controls database operations, including storing, retrieving, updating, and deleting data.
answer
data manipulation language D.M.L. Most commercial DBMSs, such as Oracle and IBM's DB/2, use a DML.
question
BLANK is an industry-standard protocol that makes it possible for software from different vendors to interact and exchange data.
answer
ODBC, which stands for open database connectivity.
question
JDBC
answer
Java database connectivity; with any database that uses SQL statements and is JDBC-compliant.
question
To bridge the gap between a database and the Web and enable data to be viewed and updated, it is necessary to use BLANK, which is software that integrates different applications and allows them to exchange data
answer
Middleware can interpret client requests in HTML form and translate the requests into commands that the database can execute.
question
a BLANK is a field or combination of fields that uniquely and minimally identifies a particular member of an entity.
answer
primary key.
question
In the accompanying figure, a BLANK is 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.
answer
foreign key.
question
Any field that is not a primary key or a candidate key is called a BLANK key.
answer
nonkey key.
question
A(n) BLANK is a graphical model of an information system that depicts the logical relationships and interaction among system entities.
answer
ERD, entity-relationship diagram (ERD).
question
BLANK describes how instances of one entity relate to instances of another entity.
answer
Cardinality.
question
BLANK is the process of creating table designs by assigning specific fields or attributes to each table in a database.
answer
Normalization.
question
BLANK codes are numbers or letters assigned in a specific order.
answer
Sequence Codes. Human resource system issues consecutive employee numbers.
question
A long integer format uses BLANK bits to represent the number 1,234,567,890 in binary form.
answer
32 bits, or four bytes.
question
BLANK is a coding method used on mainframe computers and high-capacity servers.
answer
EBCDIC (pronounced EB-see-dik), which stands for Extended Binary Coded Decimal Interchange Code.
question
EBCDIC and ASCII both require BLANK bits.
answer
eight bits, or one byte.
question
Compared with character-based formats, a BLANK storage format offers a more efficient storage method.
answer
binary storage format.
question
An integer format uses BLANK bits to represent the number 12,345 in binary form.
answer
only 16 bits, or two bytes.
question
BLANK is the process of converting readable data into unreadable characters to prevent unauthorized access to the data.
answer
Encryption.
question
True or False. JDBC is the language of the Web.
answer
False, HTML.
question
True or False. The three normal forms constitute a progression in which the first normal form represents the best design.
answer
False, third normal form.
question
True or False. In a client/server system, processing is isolated in a single computer.
answer
False, one or more.
question
True or False. Web-based data design requires users to have powerful workstations.
answer
False.
question
Web-based systems are popular because they offer ease of access, cost-effectiveness, and worldwide connectivity.
answer
all of which are vital to companies that must compete in a global economy.
question
True or False. Web-based data must be secure but in order to be so, it cannot be easily accessible to authorized users.
answer
False, must be easily accessible.
question
True or False. A common field is an attribute that appears in only one entity.
answer
False, in more than one.
question
BLANK is a collection of tools, features, and interfaces that enable users to add, update, manage, access, and analyze the contents of data
answer
database management system (DBMS)
question
A BLANK, which is used to access stored data, allows a user to specify a task without specifying how the task will be accomplished.
answer
A query language.
question
Many database programs generate BLANK, which is a language that allows client workstations to communicate with servers and mainframe computers.
answer
SQL (Structured Query Language).
question
The complete definition of a database, including descriptions of all fields, tables, and relationships, is called a(n) BLANK.
answer
Schema.
question
JDBC enables BLANK applications to exchange data with any database that uses SQL statements and is compliant with the standard.
answer
Java applications.
