CUSTOMER

$($

customer

$\_$

id

$,$

$$store

$\_$

id

$,$

$$first

$\_$

name, last

$\_$

name, email, address, active

$)$

$$

RENTAL

$($

rental

$\_$

id

$,$

$$rental

$\_$

date, inventory

$\_$

id

$,$

$$customer

$\_$

id

$,$

$$return

$\_$

date, staff

$\_$

id

$)$

$$

INVENTORY

$($

inventory

$\_$

id

$,$

$$film

$\_$

id

$,$

$$store

$\_$

id

$)$

$$

STORE

$($

store

$\_$

id

$,$

$$manager

$\_$

staff

$\_$

id

$,$

$$location

$)$

$$

STAFF

$($

staff

$\_$

id

$,$

$$first

$\_$

name, last

$\_$

name, address, email, store

$\_$

id

$,$

$$salary

$)$

$$

PAYMENT

$($

payment

$\_$

id

$,$

$$customer

$\_$

id

$,$

$$staff

$\_$

id

$,$

$$rental

$\_$

id

$,$

$$amount$,$ payment

$\_$

date

$)$

$$

FILM

$($

film

$\_$

id

$,$

$$title$,$ description, rental

$\_$

duration, rental

$\_$

rate

$)$

$$

Based on the relations above, construct the SQL statements for: