Chapter 1

Question 1

Table

Answer 1

Has a name, and fixed tuple of columns, and a varying set of rows

Question 2

Column

Answer 2

Has a name and data type

Question 3

Row

Answer 3

An unnamed tuple of values each value corresponds to a column and belongs to a columns data type

Question 4

Data type

Answer 4

A named set of values from which column values are drawn

Question 5

Set

Answer 5

in an ordered collection of elements, enclosed in braces, and are the same since sets are not ordered.

Question 6

Database model

Answer 6

A conceptual framework for database systems with three parts: data structures that prescribe how data is organized, that manipulate data structures and rules that govern valid data.

Question 7

Select

Answer 7

A command that selects a subset of rose of a table

Question 8

Project

Answer 8

A command that eliminates 1 or more columns of the table

Question 9

Product

Answer 9

List all combinations of rows of two tables

Question 10

Join

Answer 10

Combines two tables by comparing related columns

Question 11

Union

Answer 11

Select all rows of two tables

Question 12

Intersect

Answer 12

Select rows common to 2 tables

Question 13

Difference

Answer 13

Select rows that appear in one table, but not another.

Question 14

Rename

Answer 14

Changes a table name

Question 15

Aggregate

Answer 15

Computes functions over multiple table rows, such as sum and count

Question 16

Relational operations

Answer 16

Based on set theory, each operation generates a result table from one or two input tables

Question 17

Relational rules

Answer 17

Unique primary key – all tables have a primary key column, or group of columns in which values do not repeat

Unique column name, different columns of the same table have different names.

No duplicate rows: no two rows of the same table have identical values in every column.

Question 18

Business rules

Answer 18

Based on business policy and specific to particular databases, EX: all rows of an employee table must have a valid entry in the department code column call or passport number values may not repeat in different employee rows.

Question 19

Business rules

Answer 19

Based on business policy and specific to particular databases, EX: all rows of an employee table must have a valid entry in the department code column call or passport number values may not repeat in different employee rows.

Question 20

SQL

Answer 20

A high-level computer language for storing, manipulating and retrieving data

Question 21

Statement

Answer 21

Complete command, composed of one or more clauses

Question 22

Clause

Answer 22

Groups, SQL keywords together

Question 23

Data definition language

Answer 23

SQL sub language that defines the structure of the database

Question 24

Data query language

Answer 24

Is SQL sub language that retrieve data from the database

Question 25

Data manipulation language

Answer 25

ASQL sub language that manipulates data stored in a database

Question 26

Data control language

Answer 26

ASQL sub language that controls database user access

Question 27

Data transaction language

Answer 27

A SQL sub language that manages database transactions

Question 28

Database system instance

Answer 28

A single executing copy of a database system

Question 29

Create database command

Answer 29

Creates a new database

Question 30

Database drop command

Answer 30

Delete a database, including all tables in that database

Question 31

Show statement

Answer 31

Provides database users and administrators with information about database such as the database contents and server status information

Question 32

Use

Answer 32

Select a database and is required to show information about tables within a specific database