Quite a few business rules can be defined easily using Data Modeler, here some examples: business ruleĮmployee job must be ‘CLERK’, ‘SALES REP’ or ‘MANAGER’.Įmployee salary must be a multiple of 1000.ĭomain (which lets you define a constraint)Įmployee exit date must be later than hire date. I am old enough to remember the Business Rules Classification: Business Rules Classification This is the foundation of your application. My preference is to just one relational model per Logical Model to keep it simple.Īgain you should really take your time to design your relational model and to verify it using the Design Rules described later on. This allows you to use the features of those versions. Relational ModelsĮach Logical Model may be transformed into a Relation Model, one for Oracle Database 12c, Oracle Database 12cR2 and so on. You can even have one corporate domains XML file if you prefer. This is the foundation of your application.Īnd do not forget to use domains whenever appropriate. You should really take your time to design your model and to verify it using the Design Rules described later on. This is the Entity Relationship Model area where you can construct Entity Relationship Diagrams (ERD) like this: Logical Model A simple SQL script to create the view is just enough. This utility allows you to define views but I do not use it since it gave me a lot of problems. For other activities I use tools that suit me better, the Unix approach. I use Data Modeler mainly for modeling, documentation and generating DDL scripts for the initial setup and incremental migration scripts later on. Oracle SQL Developer Data ModelerĪ book I can recommend is Oracle SQL Developer Data Modeler for Database Design Mastery by Heli Helskyaho. This time I will discuss Oracle SQL Developer Data Modeler. Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (3)”, I told you about the Oracle Database and Oracle APEX. Kharnagy, CC BY-SA 4.0, via Wikimedia Commons

Er diagram in oracle sql developer