The given SQL statement is intended to query how many books there are with at least
800 pages from publishers in Los Angeles, United States.
SELECT COUNT(*)
?
WHERE PUBLISHER.PUBNAME=BOOK.PUBNAME
AND CITY='Los Angeles'
AND COUNTRY='United States'
AND PAGES>=800;
With which line should the question mark in this statement be replaced?
Give this one a try later!
FROM PUBLISHER, BOOK
ADDED IN - (3) examples of a relation in 1NF
,Give this one a try later!
1. It has multiple candidate keys
2. All of the key attributes are defined
3. All attributes are dependent on the primary key
What is an important aspect of "referential integrity"?
Give this one a try later!
Reference to data in one relation is based on values in another relation.
A foreign key in a table must refer to a valid primary key in another table.
ADDED IN -An attribute (or combination of attributes) that uniquely identifies each
entity in a table is called a ____.
Give this one a try later!
SuperKey
Refer to the given SQL statement.
SELECT SPNUM, SPNAME
FROM SALESPERSON
What is the correct line to add to the end of this statement to find salespersons with a
commission percentage of 15?
Give this one a try later!
, WHERE COMMPERCT=15;
What is a methodology for organizing attributes into tables?
Give this one a try later!
Data normalization
ADDED IN -The entity integrity rule requires that ____.*
Give this one a try later!
All primary key entries are unique
What is the entity-relationship diagram about a car rental agency showing?
Give this one a try later!
One manufacturer created at least one of the agency's cars.
800 pages from publishers in Los Angeles, United States.
SELECT COUNT(*)
?
WHERE PUBLISHER.PUBNAME=BOOK.PUBNAME
AND CITY='Los Angeles'
AND COUNTRY='United States'
AND PAGES>=800;
With which line should the question mark in this statement be replaced?
Give this one a try later!
FROM PUBLISHER, BOOK
ADDED IN - (3) examples of a relation in 1NF
,Give this one a try later!
1. It has multiple candidate keys
2. All of the key attributes are defined
3. All attributes are dependent on the primary key
What is an important aspect of "referential integrity"?
Give this one a try later!
Reference to data in one relation is based on values in another relation.
A foreign key in a table must refer to a valid primary key in another table.
ADDED IN -An attribute (or combination of attributes) that uniquely identifies each
entity in a table is called a ____.
Give this one a try later!
SuperKey
Refer to the given SQL statement.
SELECT SPNUM, SPNAME
FROM SALESPERSON
What is the correct line to add to the end of this statement to find salespersons with a
commission percentage of 15?
Give this one a try later!
, WHERE COMMPERCT=15;
What is a methodology for organizing attributes into tables?
Give this one a try later!
Data normalization
ADDED IN -The entity integrity rule requires that ____.*
Give this one a try later!
All primary key entries are unique
What is the entity-relationship diagram about a car rental agency showing?
Give this one a try later!
One manufacturer created at least one of the agency's cars.
