Database Design Process Project (Preparation) Essay

Database Design Process Project (Preparation) - raise ExampleMoreover, it offers specific built-in templates that facilitate the users to choose well suited ERD template according to the ineluctably and requirements of the projects. Once a template has been selected by the user, the shapes (entities, relationships, category, etc.) lowlife be drawn by just tweak and drop method. The entity represents a table of a database and the relationship shape represents the relation between two tables which can be one to one, one to many, etc. After dragging an entity to the drawing board, the user can tack an entity / table telephone, diverse columns and their name according to the requirements of the table, the data types of the created columns, selection of primary hear, check / tick if a particular column must have a value and the column referred to as the foreign constitute (if any). In this way, the user can add several entities / tables as per the requirements of the database des ign under eruptment. After adding all the entities to the drawing board, the user can add relationships between the entities by relating the primary list with foreign key and this can be done by dragging the particular shapes. Moreover, the MS Visio provides the functionalities to add triggers, indexes and notes on entities and their relationships. When the users be done with creating the entity relationship diagram, the file can be saved in .vsd format in the toughened drive of the PC / laptop moreover, the saved file can be edited or updated when required. The MS Visio offers the functionality of viewing the complete diagram, page setup and printing the diagram (Sethi, 2006). It is required for the Riordan Manufacturing Virtual Organization to develop policies, guidelines, standards and practices to put in place for the use of the MS Visio. I would suggest the organization to use the ceremonious standards of ERD elements to represent an entity t present should be a rectangul ar shape along with one row having the entity name and one rectangular shape should only represent one entity. The primary key of the entity should be equal by a key symbol, the relationships between the entities should be represented with dotted lines and the color of the foreign key attribute should be red. Furthermore, the overall ER diagram should be easy to understand and precise to debate by everyone, therefore, it is recommended that the users should add proper notes that would assist and aid the users to understand the diagram completely. It is pertinent to mention here that the MS Visio offers the same template to develop ER diagrams. The practices and guidelines for naming convention of the tables and attributes should be clarified to the employees and users of the MS Visio in the virtual organization. I would suggest to the management of the organization that the table / entity name should always deject with tbl characters, for example the entity name tblCustomer i-e t he entity or table having the information of the customer. The pre-characters of the attribute name should be understandable having low character of the table name and capital characters like the attribute name cFName can be articulate as the first name of the customer. The employees of the virtual organization should be given proper training on the guidelines, standards and practices for using the MS Visio to develop the ER diagrams. The employees should be guided on saving the file names and should have