Domain Relational Calculus unsafe query

1.6k views Asked by At

I'm not sure how the following is an unsafe query. "Unsafe query" means that the answer set is infinite. I seek an explanation of why it is an unsafe query because I don't understand the query.

There are 2 tables:

invoice

number(PK)    customer   date         amount
12343         121        24/4/11      123455
23432         234        1/3/11       3234
23456         121        12/4/11      12540
67891         121        1/4/11       1432
19473         234        11/12/11     555

customer

code(PK)    name     address
121         a        ab
234         b        bc
233         c        cd
122         d        de

The query is:

{< X1, Z2 > |
    ƎY1, ƎZ1, ∀X2, ∀V2 (
            customer(X1, Y1, Z1)
        ᴧ  (invoice(X2, X1, Z2, V2) --> Z2 >= '1/4/11')
    )
}
0

There are 0 answers