Question 1:
Use the tables below to answer the following questions:
| customerid |
|
|
|
|
| customerid |
firstname |
lastname |
city |
state |
| 10101 |
John |
Gray |
Lynden |
Washington |
| 10298 |
Leroy |
Brown |
Pinetop |
Arizona |
| 10299 |
Elroy |
Keller |
Snoqualmie |
Washington |
| 10315 |
Lisa |
Jones |
Oshkosh |
Wisconsin |
| 10325 |
Ginger |
Schultz |
Pocatello |
Idaho |
| items_ordered |
|
|
|
|
| customerid |
order_date |
item |
quantity |
price |
| 10330 |
30-Jun-99 |
pogo stick |
1 |
28 |
| 10101 |
30-Jun-99 |
Raft |
1 |
58 |
| 10298 |
1-Jul-99 |
Skateboard |
1 |
33 |
| 10101 |
1-Jul-99 |
Life Vest |
4 |
125 |
| 10299 |
6-Jul-99 |
Parachute |
1 |
1250 |
1. Find the customerid of customers in the customers table that have 10101 as customerid.
2. Find the highest price of an item in items_ordered table.
Question 2:
As a database administrator, grant and revoke the following privileges to the next users:
1. user1 allowed to select and insert on table (employee, manages).
2. user2 are not allowed anymore to update on table (company).
Question 3:
What is JavaScript?