qtcentre.org qtcentre.org

A SQL composite key with 3 members?

Hello everyone, I got stuck trying to normalize my database. I'm putting my client requirements and, in bold, the tables involved so you can see the whole picture: Requirements: • One Payment Application are linked to only one Contract. • One Payment Application has one or more Bills. • One Bill’s Payment can be associated to one or more Beneficiaries. This implies a many to many relationship between Bills and...