Homework C 15

Question 1

XML

Answer 1

Extensible Markup Language

Question 2

SQL

Answer 2

Structured Query Language

Question 3

QBE

Answer 3

Query by Example

Question 4

____ is information describing other information.

Answer 4

metadata

Question 5

___ is a tagging scheme which has no standard tags.

Answer 5

XML

Question 6

The first and thus fully enclosing tag in an XML document is called the ___.

Answer 6

Root element

Question 7

The ___ rule says we should label data with tags consistently.

Answer 7

identification

Question 8

The ___ rule says to enclose in a pair of tags all tagged data referring to the same entity.

Answer 8

affinity

Question 9

The ___ rule says that when you have several instances of the same kind of data, enclose them in tags as well.

Answer 9

collection

Question 10

An ___ is anything that can be identified by a fixed number of its characteristics or attributes.

Answer 10

entity

Question 11

A(n) ____ database uses tables to organize information and describes relationships among the different kinds of data.

Answer 11

relational

Question 12

In relational databases, a(n) ___ or field is a “column of a table.”

Answer 12

attribute

Question 13

Attributes not only have a name but an associated ____ ____ (2 words) such as number, text or image.

Answer 13

data type

Question 14

Another name for a database row is a record or a ____.

Answer 14

tuple

Question 15

A(n) ___ is a collection of table definitions that give the name of the table, list of the attributes and their data types, and identifies the primary key.

Answer 15

schema

Question 16

A(n) ___ is used to ensure that all entities in a database are unique.

Answer 16

Primary key

Question 17

The ___ operation pulls rows of information that satisfy a particular test.

Answer 17

select

Question 18

The ___ operation combines two tables which contain the same attributes.

Answer 18

union

Question 19

The ___ operation pulls columns of information from a selected table.

Answer 19

project

Question 20

The ___ operation combines two tables which contain different attributes except one and only combines those rows that have a common value is the shared attribute.

Answer 20

join

Question 21

Using the Product operation on a table with 4 columns and 9 rows and a table with 7 columns and 6 rows will result in a table with ___ columns and ___ rows.

Answer 21

11, 54

Question 22

The ___ database is designed by the database administrator so that the data is fast to access from the disk drive.

Answer 22

physical

Question 23

The ___ database shows users the view of the information that they need and want.

Answer 23

logical

Question 24

When we want to ask a question of the database, we make a ____ using the six database operations. The result is a new table.

Answer 24

query

Question 25

Access and most modern database systems use a language called ___ as the standard database language.

Answer 25

SQL

Question 26

IBM created a technique in the 1970s called ___ which makes creating queries much easier.

Answer 26

QBE