Fluency with Information Technology, 6e (Snyder)
Chapter 15 A Table with a View: Introduction to Database Concepts
15.1 True/False Questions
1) Inconsistency is the main reason to avoid redundancy of information in a database.
2) Relationships connect rows of one table with rows of another table.
3) Relationships are part of the metadata of a database.
4) Relationships are specified by the user of a database.
5) The logical database is the permanent repository of the data.
6) The logical database shows users the view of the information that they need and want.
7) Queries are used to create views.
8) A logical table can be created with information from no more than two physical tables.
9) To successfully use a database, a user must be able to write SQL.
10) In relational databases, think of an attribute as a “column of a table,” where the “attribute
names” are column headings and “attribute values” are the entries.
11) A root element is the tag that encloses all of the content of the XML file.
12) XML is easy and intuitive because it is a self-describing language.
13) Every relational database can be described by XML; likewise, anything described by XML is
a relational database.
14) A table is defined with a specific set of attributes; among the instances of any table is the
“empty instance.”
15) An XML file is just an alternative notation for a database schema.
16) A database table may not contain multiple identical rows; all its rows must differ.
17) A database table is technically called a relation.
1) The key field for the student database on a campus is probably the student:
A) address
B) ID
C) phone
D) last name
2) Which is true about a row in a table?
A) A technical term for a row is a tuple.
B) A row is often called a record.
C) A row is an entity instance, defining one particular object.
D) All of the above
3) A logical database:
A) is created from existing information
B) is created fresh each time it is needed
C) may combine information from multiple tables
D) all of the above
4) What operation combines two tables based on matching fields?
A) Join operation
B) Bind operation
C) Combine operation
D) Unite operation
5) What operation takes rows from one table to create a new table?
A) Project
B) Union
C) Select
D) Difference
6) Assume that you will use the Product operation on table A (five attributes) × table B (three
attributes). The resulting supertable will have:
A) fifteen attributes
B) ten attributes
C) eight attributes
D) two attributes
7) Logical tables are created from a:
A) view
B) query
C) relationship
D) key
8) The encoding rules of XML include the:
A) Affinity Rule: Group Related Data
B) Identification Rule: Label Data with Tags Consistently
C) Collection Rule: Group Related Instances
D) all of the above
9) Relationships:
A) are not relevant in building the logical database
B) establish a correspondence between the columns within a table
C) should be given meaningful names to assist those who work with the database
D) all of the above
10) The Select operation on tables is often combined with the ________ operation to”trim” base
tables.
A) Join
B) Project
C) Union
D) Add
11) Relationships in a database schema show how:
A) data types of all attributes within each table relate to each other
B) queries are related to one another
C) information in a table is related to information in another table
D) fields are related to one another in a table
12) Rules for writing XML include:
A) a required first line that identifies an XML file
B) tags and attributes not case sensitive
C) element names can contain letters, numbers, and special symbols
D) all of the above
13) An attribute or set of attributes that could potentially be chosen as the table’s key is a:
A) primary key
B) secondary key
C) candidate key
D) provisional key
14) XML must be written using a:
A) word processor
B) text editor
C) Web browser
D) spreadsheet program
15) XML tags cannot contain:
A) spaces
B) uppercase letters
C) lowercase letters
D) numbers
1) The ________ is a collection of table definitions that gives the name of the table, lists the
attributes and their data types, and identifies the primary key.
2) The ________ operation builds a new table from the columns of an existing table.
3) A(n) ________ is a correspondence between two tables of a database.
4) The physical database is designed by ________.
5) The ________, or view of the database, is the form of the database the users see and is created
on demand from existing information.
6) The ________ operation combines two tables.
7) A technique called ________, is available to us in the Microsoft Access system. The user fills
in a template, and the software generates the SQL.
8) The design of a(n) ________ database is guided by technical considerations, while the design
of a(n) ________ database is guided by personal considerations of the users.
9) ________ are the operations that transform a physical database into a logical one.
10) The ________ operation is used to remove from one table the rows that are also listed in a
second table.
11) XML stands for the ________ Language.
12) The attributes of an entity in a database should satisfy the _______ rule in XML design.
13) The ________ defines the form of the information that can be stored in a field.
14) Database ________ allow us to ask questions of a database in a way that lets the software
find the answer for us.
15) A(n) ________ is a database command defining a table expressed using the five database
operators.
16) The ________ rule states that you should label data with tags consistently.
17) The ________ rule states that you should group data referencing an entity together.
18) An SQL ________ query can perform any or all of the operations on tables.