Database Modeling

1

Good morning!

I have the following problem in user, form, and group relationships. In the way that the relationship was modeled (CONTEM) it will become a table where you will have the user, form and group keys.WHAT IF YOU DO NOT HAVE THE FORM REGISTERED IN THE SYSTEM (HAVING PENALTY USER AND GROUP KEYS), WHAT DO I IN THE TABLE (CONTAINS) WITH RELATION TO FK THAT WOULD COME FROM FORM? WHERE THE FORM KEY GOES AS A FOREIGN KEY TO THE TABLE (CONTINUE) SINCE THE RELATIONSHIP IS FROM N N N.

    
asked by anonymous 29.11.2017 / 18:07

2 answers

0

But you can not set the Form Id to default null? Once the form is created, you make the link.

I think if it really is an FK, it should be defined in the bank schema for performance issues and guarantee the bank's relational model. But I see no reason not to set it to null.

    
29.11.2017 / 20:59
0

Create only the relational table and do not set the foreign key fields, you can store the values even if you have only one value.

    
29.11.2017 / 18:41