SPRING 2016 CIS 406-02: CH9

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

Get instant access to
all materials

Become a Member