PY4E: Chapter 15 (Part 2) Multi-table Relational
SQL- Questions and Answers
Which of the following is NOT a good rule to follow when developing a database model?
Use a person's email address as their primary key
If our user interface (i.e., like iTunes) has repeated strings on one column of the user interface,
how should we model this properly in a database? Make a table that maps the strings in
the column to numbers and then use those numbers in the column
Which of the following is the label we give a column that the "outside world" uses to look up a
particular row? Logical key
What is the label we give to a column that is an integer and used to point to a row in a different
table? Foreign key
What SQLite keyword is added to primary keys in a CREATE TABLE statement to indicate that
the database is to provide a value for the column when records are inserted?
AUTOINCREMENT
What is the SQL keyword that reconnects rows that have foreign keys with the corresponding
data in the table that the foreign key points to? JOIN
What happens when you JOIN two tables together without an ON clause? The number of
rows you get is the number of rows in the first table times the number of rows in the second table
SQL- Questions and Answers
Which of the following is NOT a good rule to follow when developing a database model?
Use a person's email address as their primary key
If our user interface (i.e., like iTunes) has repeated strings on one column of the user interface,
how should we model this properly in a database? Make a table that maps the strings in
the column to numbers and then use those numbers in the column
Which of the following is the label we give a column that the "outside world" uses to look up a
particular row? Logical key
What is the label we give to a column that is an integer and used to point to a row in a different
table? Foreign key
What SQLite keyword is added to primary keys in a CREATE TABLE statement to indicate that
the database is to provide a value for the column when records are inserted?
AUTOINCREMENT
What is the SQL keyword that reconnects rows that have foreign keys with the corresponding
data in the table that the foreign key points to? JOIN
What happens when you JOIN two tables together without an ON clause? The number of
rows you get is the number of rows in the first table times the number of rows in the second table
