Question

1. Fill in the blank to have a query to get the next 30 records on 5^th page from database. Explanation (5pts)

SELECT * FROM products LIMIT __, __;

2. Given the following database with 2 tables: (10pts)

Table fruits

name	calories	carbohydrates	fiber
apple	130	35	5.5
pear	102	40	3.3
grapefruit	60	22	3
orange	80	18	4
blueberries	20	3	1
watermelon	80	32	1.5
banana	120	29	2

Table weeklydiet

day	fruit	amount
Monday	apple	2
Monday	banana	1
Tuesday	apple	1
Wednesday	watermelon	2
Thursday	watermelon	1

What is the relationship between the 2 tables? (2 pts)

Which of the following queries returns exactly ONE record? Explain why? (8pts)

1. SELECT * FROM fruits WHERE calories >= 120;
2. SELECT * FROM fruits WHERE carbohydrates < 20 AND fiber < 3;
3. SELECT carbohydrates, fiber FROM fruits WHERE carbohydrates < 20 OR fiber < 3;
4. SELECT name, calorites FROM fruits WHERE name LIKE "p%";
5. SELECT day FROM weeklydiet WHERE amount < 3 LIMIT 2,1;

Answer 1

SELECT * FROM products LIMIT 5,30;

it will select 30 items strating from 5 give the results.

there is a one-to-many relationship

SELECT name, calorites FROM fruits WHERE name LIKE "p%";

will return record conatining name starting with p only.

SELECT day FROM weeklydiet WHERE amount < 3 LIMIT 2,1;

it will return the record starting from 2 since there is limit i.e. 1 hence it returns only one record starting from 2

both will return exactly one record.