Imperial Valley College Faculty Websites

You are here:Instructors»Robert Gallegos»Chapter 8 Homework
Wednesday, 04 April 2012 21:37

Chapter 8 Homework

Written by Robert Gallegos
Rate this item
(0 votes)

CIS 214 PHP and MySQL

Chapter 8 Homework                                                                                                               Date due: 04/16/2012

Your name: _______________________________________________

 

1.

A description of the data (the tables and columns) in your database, along with any other related objects and the way they all connect is known as a_________.

Answer:

2.

Creating a __________ of a table lets you keep the design of the table separate from the data that’s inside of it.

Answer:

3.

A __________ key is a column in a table that references the primary key of another table.

Answer:

4.

Large arrows show primary keys connecting to foreign keys to wire together __________.

Answer:

5.

One-to-One: exactly one row of a parent table is related to one row of a __________ table.

Answer:

6.

One-to-Many: exactly one row of a parent table is related to __________ rows of a child table.

Answer:

7.

Many-to-Many: Multiple __________ of a parent table are related to multiple rows of a child table.

Answer:

8.

Data-driven forms rely on __________ in a MySQL database to generate HTML form fields.

Answer:

9.

The __________ operator can be used to code if-else statements in a more compact form.

Answer:

10.

Normalization means designing a __________ to reduce duplicate data and improve the relationships between data.

Answer:

11.

Atomic data is data that has been broken down into the smallest __________ needed for a given database.

Answer:

12.

Making your data atomic is the __________ step in creating a normal table.

Answer:

13.

Normalization has its benefits, namely improvements in database __________ and speed.

Answer:

14.

Normalizing a database involves strictly __________ to a series of design steps.

Answer:

15.

More tables usually lead to messier__________ .

Answer:

16.

A __________ grabs results from multiple tables in a single query.

Answer:

17.

Dot notation allows you to __________ the table a column belongs to within a join.

Answer:

18.

An INNER __________ combines rows from two tables using comparison operators in a condition.

Answer:

19.

Rewrite ON with __________ for more concise inner join queries that match on a common column.

Answer:

20.

The column names must be the same in order to use the __________ statement in an inner join.

Answer:

21.

An __________ allows you to rename a table or column within a query to help simplify the query in some way.

Answer:

22.

When a column is __________ with an alias, the alias is what appears in the query results.

Answer:

23.

Joins are more efficient and require less code than __________ queries.

Answer:

 

 

For instructor use:

Total Correct:                        _______________________

Percent:                                  _______________________

Grade:                                    _______________________