Re: Complex Database Creation
The spec as you describe it conflates user interface issues with database structure. When designing a database, its rules & queries, forget about checkboxes and other such UI questions. Thinking in terms only of data and rules entailed by the requirement. Write out everything the database has to store, in every detail. Then walk through a formal design method, eg
https://www.artfulsoftware.com/dbdesignbasics.html. Such a method will resolve the database backend aspects of most of the questions you are asking.
In general, complex constraints are usuall enforced with a combination of Check Constraints, Foreign Keys, Triggers and/or stored procedures. And btw literal limits like your 25 so-and-sos per business are usually best avoided.
Subject
Written By
Posted
Re: Complex Database Creation
July 29, 2021 08:48PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.