"Проектирование реляционных баз данных." - читать интересную книгу автора (Джен Л. Харрингтон)

*cus tomer_numb
cus tomer_f i rs t_jiame
cus tomer-I as t_name
cus tomer_s tree t
customer_ci ty
cus tomer_s ta te
customer-Zip
cus tomer_phone
cred i t_card_numb
card_jexp_da te
i
Order
*order_numb
customer_numb
order-date order_fi I led
l—O?
Distributor
*d i str i butor_numb d i s tr i bu tor_name d i s tr i butor_s tree t distributor_city d i str ibutor_state
distributor_zip
d i s tr i bu tor_phone
d i s tr i bu tor_con tac t.
con tac t_per son_jex t
I tern
* i tem_numb
title
d i s tr i bu tor_numb
retaiI-price
release_jdate
genre
Order Iines
*order_numb
* i tem_numb
quanti ty
d i scount_appIi ed
seI I ing_pr i ce
Iine_cost
shipped
SO—I
He tor *actor_numb actor_name
Performance
*actor_numb
* i tem_numb
role
l—CX
Produc t i on
*producer_name * i tero_numb
7
Producer
*producer_name s tud i о
РИС. 2.11. Завершенная ER-диаграмма для базы данных Lasers Only