MySQL 2nd Edition Chapter 01

A relational database consists of one or more _______________________ .

table

What is an attribute of an entity, one column in the table?

Field

What are the types of database relationships?

One to one, One to many, Many to many.

What is one or more columns that uniquely identifies a row?

Primary key

What is one instance of a entity, usually one row in the table?

Record

A/An _______________________ uniquely identifies each row in a table.

primary key

If you define a column with a default value, that value is used whenever a row

that doesn't include a value for that column is added to the table.

When a column in a table is defined, it is given a data ________________ that determines what kind of data it can store.

type

SQL stands for ______________ .

Structured Query Language

What is a property of the entity?

Attribute

What is used in many programming languages to access data from database?

SQL

The most common type of relationship between two tables is a/an _______________________ relationship.

one to many

What recommendations won't improve the readability of your SQL statements?

Avoiding comments

A/An ____________________________ diagram can be used to show how the tables in a database are defined and related..

Enhanced entity relationship

What is a object or thing such as vendor, invoice, parts?

Entity

What lets any application communicate with any DBMS?

SQL

To relate one table to another, a/an _______________________ in one table is used to point to the primary key in another table.

foreign key

The three main hardware components of a client/server system are the clients, the server, and the _______________________ .

network