| Close | |
 |
|
| Close | |
|
|
|
| Data architecture compiler - Data base
designer On clicking on the words 'Data bases' from the previous menu the information architect will be presented with the following screen:  |
|
The RA5 will use this compiler to develop a new data base design, modify the name of an existing one, clone a data base design or export a design's create statements. On selecting an existing data base, either for viewing or modifying, the following screen will be displayed. This screen will enable the RA5 to decide on whether an entity will become a physical table or remain a logical object. Any attribute that has been placed into an entity that remains in a logical phase, will be automatically moved to its most appropriate physical table. For example if the 'date of birth' was placed as an attribute in the entity Birth Certificate and if the Birth Certificate was linked to a Person via an association then if the Birth Certificate remains logical, whilst the Person entity becomes a physical table, the attribute 'date of birth' will automatically be relocated to the Person table.  To add or modify attributes, the RA6 will need to double click on an entity name and the following screen will be displayed: You will note that the first name does not appear in this entity as Person is a subset of Legal entity and hence the first name is actually the legal entity name. When the actual data base is generated and if the legal entity is ignored as a physical table, the legal entity name attribute will be automatically relocated to the person table. In the above example, as an RA6 has already created pseudo code for a physical table, that entity will not be able to modified. If a change to the data base has to occur, then the RA5 can clone the design, make the necessary changes, release the new data base design and the RA6 will be able to use their existing pseudo code to copy the code from the old design to the new one. The RA6 may also have to write migration pseudo code to transfer the data between data base designs. |