Курсовая работа: Проектирование базы данных Аптека

Естественное характеристическое множество

f(C):

data_supply, vremy_postavki -> supplierid

clientid, productid, data_voz, vremy_voz -> employeeid

month_r, year_r -> arenda, kommunal_yslygi, reklama, vnutr_rashodi

month_d, year_d -> viruchka_emploee

employeeid -> month_d, year_d

month, year -> rashodid, dohodid

emloyeeid -> oklad, premia, avans, zarplata

productid -> artikulid

supplierid -> name

R0 = ( data_supply, vremy_postavki, supplierid ) K0 = { data_supply,

vremy_postavki }

R1 = ( clientid, productid, data_voz, vremy_voz, employeeid ) K1 = {

clientid, productid, data_voz, vremy_voz }

R2 = ( month_r, year_r, arenda, kommunal_yslygi, reklama, vnutr_rashodi)

K2 = { month_r, year_r }

R3 = ( month_d, year_d, viruchka_emploee ) K3 = { month_d, year_d }

R4 = ( employeeid, month_d, year_d ) K4 = { employeeid }

R5 = ( month, year, rashodid, dohodid ) K5 = { month, year }

R6 = ( emloyeeid, oklad, premia, avans, zarplata ) K6 = { emloyeeid }

R7 = ( productid, artikulid ) K7 = { productid }

R8 = ( supplierid, name ) K8 = { supplierid }