 |
|||||
go
Recycled firm |
||
|
The firm has a few outlets that receive items for recycling. Each of the outlets receives funds to be paid to deliverers.
The primary key is {point, date}, thus receiption of money (inc) takes place not more than once a day (date column does not include time component of the date). Information on payments to deliverers is registered in the table:
In this table the primary key {point, date} also ensures bookkeeping of the funds distribution at each point not more than once a day. In case incomes and expenses may occur more than once a day, another database schema is used. Corresponding tables include code column as primary key:
In this schema date column does not also include the day time. |
||
