bankrupt in T - 10

3
concept:        E,A,I:  example:
vehicle         E       >>vehicle(vl-1234, kia, sportage, voets)<<
diet cola       I       drink(non-alc, >>cola, diet,<< coca cola, 0.50)
price           A       >>drink(non-alc, cola, diet, coca cola, 0.50)<<
customer no.    A       >>customer(1234, theun, voets, berufschule 1 klagenfurt)<<
green           I       >>colors(23, #0f0, green)<<
cookie(brand, type, cost)
visitor(referrer, browser, cookie)
snack(type, price)

4
            song        event       customer
title       X           X
desc        X           X
venue                   X
fname                               X
pnr                     X           X
reldate     X                       X
lname                               X
type        X           X
mailadr                 X           X

6a
owner
store
movies
dvd
vhs tape
number
title
category
copies
ID
format

b
store
movies
customer

c
yes, movie title + dvd/tape number could be linked to a customer_ID

7
add actor_ID to movie table, add actor table with actor_ID, name, real_name, date_of_birth

8
customer table, ID(membership nr), fname, lname, phone, address, standing/credit.
new table rentals, rent_id, customer_id, movie_id, rented_at.