Recycled firm

The firm has a few outlets that receive items for recycling. Each of the outlets receives funds to be paid to deliverers.

Database Scheme

Information on received funds is registered in a table:

Income_o (point, date, inc)

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:

Outcome_o (point, date, out)

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:

Income (code, point, date, inc)
Outcome (code, point, date, out)

In this schema date column does not also include the day time.

Read in more detail…